Database
On this page, you will find all the information you need to connect your external database to Jira through Elements Connect.
IP allow list
If your organization has configured some origin restriction on your database, make sure to add our servers IP addresses to your IP allow list:
52.45.65.15
3.223.15.246
Supported database types
Elements Connect supports the following databases:
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, we will not be able to provide support in the event of connection issues.
Your database is not supported?
Please tell us which data source you want to use in Elements Connect.
Databases configuration
Select the data source type
If this is your first use of Elements Connect, you will be ask which data source type you want as a data source from the main landing page. Otherwise, go to the Data Sources page in the top menu.
You have a choice between REST API and Database, choose Database.
Name your database
After selecting to create a database data source , you are asked to fill in some basic information:
![](../__attachments/10964435267/image2023-9-13_18-56-21.png?inst-v=9fdb14ed-4bc9-4150-9682-af9fdd6c0846)
Configure your connection
Once the data source has been created, you need to configure it.
![](../__attachments/10964435267/image2023-9-13_19-0-18.png?inst-v=9fdb14ed-4bc9-4150-9682-af9fdd6c0846)
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* | 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. |
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.
Save your data source
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:
![](../__attachments/10964435267/image2023-9-13_19-2-59.png?inst-v=9fdb14ed-4bc9-4150-9682-af9fdd6c0846)
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.