...

Download the driver above and install it on in your favorited Java tool for reporting & analytics.

JDBC connect string

Then configure a connection to the SQL Cloud database:

• URL: jdbc:jira-cloud:<port> (any available local port)

• Username: Must match the name of the Jira instance (https:<instance>.atlassian.net)

• Password: Must match the password on SQL Cloud - Query Server page (https://<instance>.atlassian.net/plugins/servlet/ac/expert.marketplace.jira.cloud.sql/sqlc-server)

...

SQL Cloud is a 100% JavaScript database. Therefore a browser page is always required to run the it.

As it is a an app for Jira then the user must be logged in Jira to view that the page and connect to.

This may look weird, but the JDBC Driver cares about this process automatically making all the actions on behalf the user.

...

The limit to connect is 10 seconds. After that threshold If the threshold is reached then a timeout exception will be raised.

...

The database port does not matter. You can use any one available in the local machine and the JDBC Driver will use it for all the local communication. This is also set configured in the JDBC connection URL.

Limitations

At the moment. The schema name is not supported in the queries running via JDBC.

Ex:

SELECT * FROM PUBLIC.PROJECT

will fail. Please use this instead:

SELECT * FROM PROJECT

with no schema name prefix anywhere,