There are 3 ways of sharing your queries with third-party tools:
Connecting through JDBC driver with industry instruments like Power Bi, Google Sheets, Tableau, Microsoft Excel, Pentaho, etc.
Through CSV format using a browser
Connecting through ODATA protocols
How does it work?
SQL Cloud is a 100% JavaScript database. Therefore a browser page is always required to run it.
As it is an app for Jira, a user must be logged in to Jira to view the page and connect to it.
The SQL Cloud - Query Server page is displayed below:
The page displays the database connection status:
DISCONNECTED This means that Server is enabled and waiting for a connection.
CONNECTING Query Server has received a connection request and is checking the remote user’s authentication
CONNECTED The remote user has been authenticated and the server is connected and listening to incoming user's queries
DISABLED Query server is disabled, so it will not be possible to connect to it in any way.
The limit to connect is 10 seconds. If the threshold is reached then a timeout exception will be raised.
The database username is the Jira instance name (same as in the URL).
The database password can be read from that page (click on the Edit password link). Initially, a random password is created, but User can change it or create a new random one automatically whether it is saved blank.
The database port does not matter. You can use any available on the local machine.