Data sources

Options in the select list column can be imported and synced from external databases.

For this, administrators must first create a connection to a database. Collection with the following databases can be established:

  • MySQL

  • PostgreSQL

  • Oracle SQL

  • Microsoft SQL Server

  • REST API

To create a connection, go to Settings → Apps → Data sources. Click the ‘Add data source’ button on the' Data sources' page.

Data source connection settings

Name: Choose a unique and descriptive name for your configuration to easily identify it later.

Description. Add a comment to the connection.

Data source type: Select the appropriate database type from the available options.

Hostname/IP: Specify the connection endpoint by providing the server address or IP number.

Port. Enter the database port number.

Database name. Enter the name of the specific database you intend to connect to.

Table/view. Indicate the exact database table or view you want to sync with. This defines the source of your data within the database.

Username. Input the username of an authorized user with access to the specified database. This is required for authentication.

Password. Provide the corresponding password for the authorized database user.

 

 

© 2023, STAGIL