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.
To automate the ETL for your SQL Server data warehouse with Kondado, follow the steps below:
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!
Add SQL Server as a Data Destination on Kondado
Configure Microsoft SQL Server as your data warehouse destination on the Kondado platform by allowing IP access and entering your database credentials.
Allow Kondado IP addresses on your database server
Configure your SQL Server database server (and VPC) to allow Kondado's IP addresses on port 1433, the standard port for SQL Server connections. This ensures secure external access for the ETL pipeline.
Select SQL Server on the Kondado destinations page
On the Kondado destinations page, click to add a new destination and choose the SQL Server data destination from the available options.
Name your destination and enter connection details
Provide a clear name for your destination, then fill in the Address (IP or DNS for external access), Port (typically 1433), Database name, and credentials for your SQL Server instance.
Configure database user permissions
Ensure your database user has the required permissions: DROP, INSERT, CREATE, ALTER, SELECT, and DELETE. These permissions allow Kondado to fully manage your data integration and warehouse operations.
Save and start using SQL Server as your Data Warehouse
After verifying all fields are correct, save the destination. You can now use SQL Server as your Data Warehouse and connect it to visualization tools like Looker Studio or Power BI for analysis.
