SQL Connector for Jira (DC)

Adding Database Configuration

You can use our comprehensive step-by-step guide to configure database you need.

  1. Being signed in to your Jira instance, select SQL Connector, and then select Databases.

SQL - Database.jpg
  1. Select Add Database.

sql_connector_for_jira_dc_how_to_add_DB_2.gif
  1. In the Title* section, enter the title for your database.

  2. [Optional] In the Comment field, enter any useful information.

  3. In the Database Type* field, select the type of your database.

  4. In the Host* field, enter the host of your database.

  5. In the Port* field, enter the host of your database.

  6. In the Database Name*, enter the name of your database.

  7. [Optional] In the Database Schema*, enter the data schema.

By leave the Database Schema* field empty, the default data schema will be applied.

  1. In the Username* field, enter your username.

  2. In the Password* field, enter your password.

  3. Select Test connection to check if everything is correct, and then select Create.

sql_connector_dc_add_database_2.png

Driver Properties

Driver properties allow you to pass additional JDBC parameters (e.g., SSL settings, connection timeouts, etc.) directly to the database driver. This is useful when the standard connection fields don't cover your specific configuration needs.

Add custom JDBC driver properties as key/value pairs by selecting Add Property, entering the property name and value, and repeating as needed.

sql_connector_dc_add_database_property_1.png
sql_connector_dc_add_database_property_2.png

The reserved keys user and password cannot be used as driver properties. Duplicate or blank keys will trigger a validation warning, and the Test Connection / Create buttons will be disabled until resolved.