Microsoft SQL Server

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:

Whitelist Kondado's IPs on the database server (and on your VPC) for the port that will be used to connect with SQL Server
Have the address, port, database, user, and password data to access your SQL Server at hand
On the Kondado platform, go to the page to add data sources and select the Microsoft SQL Server data source
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.

Integrations

Tables and Views

With our integration, you will be able to integrate tables and also views

If your table has a datetime/timestamp type column that marks when a record was changed/inserted, your integration can be incremental

It will be necessary to define the primary key, which can be defined by several columns and refers to the column (or set of columns) that define a record as being unique

The table created in your destination will have a similar format to the one below:

Field   Type
col_x   text
col_y   date
col_z   float

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.

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.

Gather connection credentials

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

Select SQL Server on the platform

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

Configure and name your source

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

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

Thassyo Pereira·Published 2023-08-02·Updated 2026-04-25