/
How to Create Database

How to Create Database

Before exporting data, we kindly recommend you to create a separate database for Jira data export and add its configurations to SQL Connector. Since it’s just a recommendation, feel free to export Jira data in a convenient way for you.

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

If you already have a database you’d like to use, please proceed to the steps below.

  1. Being signed in to your Jira Cloud instance, select Apps, and then select SQL Connector for Jira.

sql_connector_for_jira_tempo_-_admin_1_.gif

  1. On the left-side menu, select Databases, and then select Create database.

sql_connector_for_jira_tempo_-_database_2.gif

  1. In the Title* field, 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.

Private IP address is not allowed. Read more.

  1. In the Port* field, enter the port of your database.

  2. In the Database name*, enter the name of your database.

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

  4. In the Username* field, enter the username of your database.

  5. In the Password* field, enter the password to your database.

  1. Select Validate connection, and then select Save.