| View file | ||
|---|---|---|
|
| Table of Contents |
|---|
Preconditions:
| Info |
|---|
To be able to run a query in third-party-tool User need permission “SQL Cloud Share“ which gives access to SQL Cloud Server, through which he can share queries usingJDBC/ODATA. More information about permissions you will find here. |
Step 1. Download the library above and install it on your PC.
Step 2. Open the SQL Cloud Query Server and set your password:
Username: Must match the name of the Jira instance (https:<instance>.atlassian.net)
Password: Each time you open SQL Cloud Query Server - the new password is generated automatically. To check the password or change it - Click the button “Edit password”.
Below the STATUS SELECT the checkbox “ENABLED”, so the local server could connect to it.
| Info |
|---|
More information about server Status you will find here. |
Your server is disabled and no one can connect to it
Now your server is ready to be connected
Step 3. Open the installed driver and copy the URL from there.
Step 4. Insert copied URL into the search bar in your Browser and press enter. It will ask you to insert the login and password that you have already set in SQL Cloud Query Server (look at Step 2)
If the password and login are set correctly, you will see this message in your browser
Step 5. Now you can go back to SQL Cloud Query Server. In the right upper corner will appear a button that will bring you to OData feed builder, where you can insert Query, select primary key (it's not required), and build feed URL
The action button appears in the right upper corner of SQL Query Server window
Insert your SQL query and press “Build Feed URL”
Now you can Copy URL and connect third-party tool through it (example below)
Example
Let's connect it to Power Bi
1. Select the type of Data (ODATA Feed)
2. Insert copied URL from ODATA feed Builder (look at Step 5)
3. Insert the login and password that you previously set in your SQL Cloud Query Server (look at Step 2) and select the name of your local host (look at Step 3)
DONE!!!
Now your query is transformed into tables that are ALREADY interconnected and you can build your best report!
