Database
IP allow list
If your organization has configured origin restriction, add our servers IP to the allow list: 52.45.65.15, 3.223.15.246
Databases configuration
Supported database types
Elements Connect supports:
- Microsoft Azure SQL Database
- Microsoft SQL Server
- MySQL
- Oracle Database (Service identification)
- PostgreSQL
| Database | Supported versions |
|---|---|
Microsoft Azure SQL Database | Current Microsoft Cloud version |
| Microsoft SQL Server |
|
| MySQL |
|
Oracle Database (Service identification) |
|
| PostgreSQL |
|
Note that connection to MariaDB is possible through the MySQL datasource. However, support won't be provided in the event of connection issues.
Your database is not supported?
Please tell us which data source you want to use in Elements Connect.
Configuration
When you create your a database configuration, you are asked to fill in some information:
Name your database
Configure your connection
| Type* |
|
| Host* | URL or IP where the datasource is hosted For Microsoft Azure SQL Database, only URL hosts can be used |
| Port* | Connection port number |
| Database* | Name of the database Not applicable for Oracle databases, please cf https://docs.oracle.com/database/121/CNCPT/intro.htm#CNCPT914 |
| Schema* | Name of the schema to be connected to Not present for MySQL databases, as Schema and Database are synonymous in MySQL databases Not applicable for Oracle databases, please cf https://docs.oracle.com/database/121/CNCPT/intro.htm#CNCPT914 |
| Login* | Login used to connect to the database |
| Password | Password used to connect to the database |
| Service* (Oracle Database only) | Name of the Oracle Database service |
Connection pool size | This property controls the maximum size that the pool is allowed to reach, including both idle and in-use connections. Basically, this value will determine the maximum number of simultaneous connections to the database backend. This value must be between 1 and 5. The default value is 3 (when left empty). |
Once you have saved your configuration, you can close this screen and you'll see the list of all the data sources you have created:
You can see a table that summarizes your data sources configurations. You can do a few things:
- Edit a data source by clicking on its name
- Delete a data source by clicking on the delete link. You will be asked for confirmation.
Note
You won't be allowed to delete a data source if it's used in at least one Connected field configuration.
Security
Read-only user
It is recommended to create a dedicated database user with read-only permissions that will be used only by Elements Connect.
As it is not the purpose of Elements Connect to modify data, it only reads values, it is safer to limit permissions to the minimum.