Try our plataform
Microsoft SQL Server

Creating the data source

Microsoft SQL Server is a relational database management system created by Microsoft. The data integration from SQL Server to the Data Warehouse created by Kondado allows you to access your SQL Server data in your analytical cloud.

Adding the data source

To automate the ETL from SQL Server with Kondado to your database, follow the steps below:

  1. Whitelist Kondado's IPs on the database server (and on your VPC) for the port that will be used to connect with SQL Server
  2. Have the address, port, database, user, and password data to access your SQL Server at hand
  3. On the Kondado platform, go to the page to add data sources and select the Microsoft SQL Server data source
  4. Give a name to your data source and enter the information from step (2)

Now just save the data source and start integrating your SQL Server data into the Data Lake or Data Warehouse.

Pipelines

Summary

Relationship chart

Click to expand

Notes

  • Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information

Add Microsoft SQL Server as a Data Source on Kondado

Configure your SQL Server database as a source in Kondado to automate ETL into your cloud data warehouse.

1
Whitelist Kondado's IPs

Allow Kondado's IP addresses through your database server and VPC firewall for the SQL Server port. This secure connection is part of Kondado's security infrastructure.

2
Gather connection credentials

Collect your SQL Server address, port, database name, username, and password. These will authenticate Kondado's access to your relational database.

3
Select SQL Server on the platform

In the Kondado platform, navigate to the data sources section and choose the Microsoft SQL Server connector.

4
Configure and name your source

Enter a descriptive name for this source and input the credentials from step 2. Save to complete the setup.

5
Start integrating tables and views

Begin syncing your SQL Server tables and views to your destination. Enable incremental loads by selecting a datetime/timestamp column and defining the primary key.

Frequently asked questions

What type of database is Microsoft SQL Server?▼
Microsoft SQL Server is a relational database management system (RDBMS) created by Microsoft. It stores structured data in tables with defined schemas, making it ideal for analytical workloads when connected to Kondado's data warehouse.
What information do I need to connect SQL Server to Kondado?▼
You need the server address, port, database name, username, and password. You must also whitelist Kondado's IPs on your database server and VPC before attempting the connection.
Can I integrate both tables and views from SQL Server?▼
Yes. Kondado's SQL Server integration supports both tables and views, giving you flexibility to sync raw data or pre-modeled business logic directly into your data warehouse.
How does incremental integration work for SQL Server?▼
If your table has a datetime or timestamp column that tracks when records are inserted or modified, you can configure incremental loads. You must also define a primary key—possibly across multiple columns—to uniquely identify each record.
What will my synced data look like in the destination?▼
The destination table preserves your source schema with appropriate type mappings. For example, text fields remain text, dates stay as date types, and numeric fields map to float or equivalent types in your target warehouse.
Where can I send my SQL Server data after integration?▼
You can route SQL Server data to any Kondado destination, including data warehouses, BI tools, or spreadsheets for further analysis and reporting.
Written by·Published 2023-08-02·Updated 2026-06-01