There are two ways of connection connecting your queries with third-party tools:
JDBC driver with Java applications
ODATA protocol for the tool of your choice (lime like MS Power BI, Tableau, etc.)
...
The page to run the database and which is able to accept third-party connections is the SQL Cloud - Query Server page:
...
Some steps are required in order to get this working:
Security Level 1: Log
...
into Jira
The Query Server page can be viewed only if you are logged in to Jira. In other words, none can connect to your data until you log in into Jira before.
Security Level 2: SQL Cloud Global permission
You cannot see the SQL Cloud - Query Server action menu nor the page until your Jira administrator grants you explicitly with the SQL Cloud Connect global permission.
...
By default, this feature is disabled for all the users and every user must explicitly enable if it after they have been granted by the Jira administrator and before to start accepting any third-party connection.
...
These credentials are not the same to as the Jira user’s credentials!! One is for you to connect to Jira and the other is for anyone else to connect to your SQL Cloud database instance.
In this way, only the remote users that knows know this password (created by YOU) can connect.
...
The username is the same name than as your Jira Cloud instance name and it cannot be changed (read-only).
...
This is the initial state and must be manually changed by the user as described above. The server will reject any connection attempt.Status colour Red title DISABLED
Once the service has been enabled, this is the default state. The server is ready and waiting for connections. Please, keep in mind that you may have more than one Query Server page opened, but one only can be connected to the same tool at a time. The rest will be in this disconnected status.Status title Disconnected
Once the page has been loaded, the Query Server page is connecting to the third-party tool.Status colour Yellow title CONNECTING
The remote user has been authenticated and the server is connected and listening to incoming userusers' s queries. After closing the connection the page status will automatically change to Disconnected.Status colour Green title CONNECTED
How does it
...
work?
You may see how a Query Server page is automatically opened and connected to the tool.
This will happen everything each time , that the third-party tool asks for Jira data tries to fetch data from Jira and there is not a no any SQL Cloud database connection opened yet.
Why? Since SQL Cloud is a 100% JavaScript database running on a an HTML page, some restrictions are inherited from he bowser the browser security sandbox like (as example: opening a TCP/IP port that is listening to connections- is forbidden). This introduces some behavior, different to from the rest of the database servers.
You, as usera User, do not have to care about all theses these details, as they are automatically managed in some way behind the scene.
...
Start a new instance of the SQL Cloud databaseDatabase
Authenticate the remote user
Connect to the third-party tool and start serving Jira data (answering the remote user’s queries).
...