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