Skip to main content
Skip table of contents

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
DatabaseSupported versions

Microsoft Azure SQL Database

Current Microsoft Cloud version
Microsoft SQL Server
  • SQL Server 2019
  • SQL Server 2017
  • SQL Server 2016
  • SQL Server 2014
  • SQL Server 2012
MySQL
  • 5.7
  • 8.0

Oracle Database (Service identification)

  • 21.1
  • 19.x
  • 18.3
  • 12.1, 12.2
PostgreSQL
  • 8.2 and higher


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*
  • PostgreSQL
  • MySQL
  • Azure SQL
  • MS SQL Server
  • Oracle
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
PasswordPassword 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).


Elements Connect allows users to configure database connections according to their specific security requirements. You have the option of establishing a secure (recommended) or non-secure connection, depending on your preferences and the security measures required for your database environment. This is the responsibility of the database administrator. Our app will follow whatever the database specifies when establishing the connection.



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.

What's next?

Connected fields configuration

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.