Our app offers a powerful feature that enables seamless synchronization with an external database.
Establishing a database connection entails aligning Jira fields with corresponding database columns. The data transfer happens in a single direction - only from the database to Jira. Throughout the synchronization process, the values contained within these mapped fields are synchronized and reconciled.
To create a database connection, go to Apps → STAGIL Assets → Database SQL sync.
On this page, administrators can create new connections and manage existing ones.
To create a new connection, click on the ‘Create synchronizer’ button.
To edit an existing connection, click a 3-dot icon associated with the particular connection and select ‘Edit'.
Connection settings
Name: Choose a unique and descriptive name for your configuration to easily identify it later.
Database type: Select the appropriate database type from the available options, such as Oracle, MySQL, PostgreSQL, or Microsoft SQL Server.
Server and port: Specify the connection endpoint by providing the server address and port number.
Database name: Enter the name of the specific database you intend to connect to.
Database table or view: Indicate the exact database table or view you want to sync with. This defines the source of your data within the database.
Database user: Input the username of an authorized user with access to the specified database. This is required for authentication.
Database password: Provide the corresponding password for the authorized database user.
SQL Where filter: Optionally, you can add an SQL WHERE filter to narrow down the data you want to synchronize. This filter allows you to select specific records based on conditions defined by your SQL query.
Field mapping
After successfully establishing the connection, the next step is to synchronize database columns with issue fields. To configure this mapping, follow these steps:
Select the Connection: Choose the desired connection you wish to configure.
Access Field Mapping: Click on the three-dot icon (···) associated with the selected connection. From the dropdown menu, select 'Map Fields.'
Using the Updated Data Field
The 'Updated Data' field is a feature that allows you to condition the synchronization process. Here's how it works:
In the 'Updated Data' field, choose a specific database column that will act as a trigger for synchronization. The sync will only occur when changes are detected in this selected column.
To run the sync, select ‘Run sync’ option in the (···) icon menu.