Our app provides an option to create a synced connection with an external database.
Connection to a database implies mapping Jira fields with database columns. The sync occurs in one direction - from database to Jira. During sync the values in mapped fields are syncronised.
To create a database connection, go to Apps → STAGIL Assets → Database SQL sync.
On this page administartiors can create new connections and manage existing.
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 an select ‘Edit'.
Connection settings
Name: Specify a name for your configuration.
Database type: select a database type (Oracle, MySQL, PostgreSQL, Microsoft SQL Server)
Server and port: specify connection endpoint.
Database name: specify the database’s name.
Database table or view: specify a database table.
Database user: An authorized user for the database.
Database password: Authorized user password.
SQL Where filter: add a filter from your database.
Field mapping
Once the connection is established, database columns need to be synced with issue fields. To configure, select the connection and click on the 3-dot icons and select ‘Map fields’.
The Updated data field allows to select a database column to condition the sync: the issues will only be updated if the values in this column are updated.