Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

Preconditions:

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 using JDBC/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.

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!

  • No labels