Microsoft Azure SQL is a service offered by Microsoft. Azure SQL Database is the intelligent, scalable, relational database service built for the cloud.
Kloudio's Azure SQL integration allows users to easily create reports from the data stored in Azure SQL database and run the reports in Google Sheets or Excel.
The following article will help you get started:
Create an Azure SQL connection on Kloudio
Setup your connection settings
Start creating reports
STEP 1: Create an Azure SQL connection
Go to Kloudio Connections and Click the button to create a New Connection.
You will see the below screen. Click the Setup button under the Azure SQL icon.
A form will open to fill the connection details in Step 2.
STEP 2: Setup Azure SQL connection settings
Now it's time to set up your Azure SQL database data sync settings.
This will enable you to connect to your Azure SQL database to generate reports.
Kloudio will do this on your behalf by invoking Azure SQL APIs based on your configured sync frequency.
a) Connection name
b) Fill the Azure SQL database connection details in the below form.
c) Click 'Save' to save the connection.
STEP 3: Create Kloudio reports from your Azure SQL Connection
Once the Azure SQL database connection is created as per steps 1 and 2 above, you can create reports.
Please ensure you select the connection in the Azure SQL connection settings from Step 2.
Save the report.
Once the report is saved, go to Kloudio schedules page to schedule a job to update your reports.
Feel free to chat with us or drop an email in case you have any questions related to this integration.