IP allow list

If your organization has configured origin restriction, add our servers IP to the allowlist: 52.23.37.176 and 52.22.231.96

Database datasource configuration

Elements Connect supported databases are:

  • 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.6
  • 5.7
  • 8.0

Oracle Database (Service identification)

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

Your database is not supported? 
Please tell us which datasource you want to use in Elements Connect.

When you create your first datasource configuration, you are asked to fill in some information:

NameDescription
Name*Name of the database configuration (only visible in Connect administration section)
Type*
  • Microsoft Azure SQL Database
  • Microsoft SQL Server
  • MySQL
  • Oracle Database
  • PostgreSQL
DescriptionA brief description of the database  (only visible in Connect administration section)
Host*

URL or IP where the datasource is hosted

For Microsoft Azure SQL Database, only URL hosts can be used

Port*Connection port
Login*Login used to connect to the database
PasswordPassword used to connect to the database
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

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, go back to the previous screen so you can see the list of all the datasources you have created: 

You can see a table that summarizes your datasources configurations. You can do a few things:

  • Edit a datasource by clicking on its name
  • Delete a datasource by clicking on the delete link. You will be asked for confirmation. 

Note

You won't be allowed to delete a datasource if it is used in at least one Connected Item configuration.

Security

Readonly user

It is recommended to create a dedicated database user with readonly 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 Item configuration