Microsoft SQL Server

Microsoft SQL Server (MS SQL Server or even SQL Server) is a Microsoft relational database that is behind many applications, being one of the most popular databases in the world. By using SQL Server as a data destination on the Kondado platform, you can create your Data Warehouse quickly.

Click here to access the tutorial on how to connect to your visualization tool:
Looker Studio
Power BI

Click here if you don't have a Microsoft SQL Server database to use as a data warehouse and want to create one on Azure

To automate the ETL for your SQL Server data warehouse with Kondado, follow the steps below:

1) Allow Kondado's IPs addresses on the database server (and in your VPC) for the port that will be used to connect with the SQL Server (usually 1433)

2) On the Kondado platform, go to the add new destinations page and select the SQL Server data destination

3) Name your destination and fill in your database information:

Address: Use the IP or DNS of your database for external access

Port: Fill in the port to be used for access (usually 1433)

Database: fill in the database of your database (if you don't know the value of this parameter, you can create a new one following these instructions)

User: database access user. This user must have DROP, INSERT, CREATE, ALTER, SELECT and DELETE permissions

Password: User access password to the database

Now you can save the destination and start using SQL Server as your Data Warehouse!