Intro to Portal: Connecting Your Data - SQL Databases

Connecting SQL Database

apricot_text_13 Portal allows you to connect to a configured SQL database.

To begin, navigate to the homepage by pressing on the homepage_button button on the top left.

Datasource Configuration

Navigating to add a datasource page

  • Hover the configuration_button button and select the datasource_button option.
  • Next, click on the add_datasource_button button.

sidebar_datasources

Choose a datasource type

  • Select which type of SQL database server to connect to.

Add Datasource Credentials and Configuration

  • After selecting on the datasource type, input the configuration for the datasource.
  • Name: Name of the datasource connection in APRICOT Portal,
  • Host: The hostname and port of the database server,
  • Database: Name of database to connect to on database server,
  • User: Username credential for the database server,
  • Password: Password credential for the database server

datasource_configuration

1 Like

Looking for a easy upload? Upload your own .csv file and start exploring APRICOT quick and easy! Check on this post to start.