Microsoft SQL Server SSH (data source)

Microsoft SQL Server is a relational database management system created by Microsoft. SSH integration differs from traditional integration in that it connects to the database through an intermediate server, also called a tunnel or bastion.

SQL Server SSH data integration for Data Warehouse created by Kondado enables you to have access to SQL Server SSH data in your analytics cloud.

Adding the data source

To automate SQL Server SSH ETL with Kondado for your database, follow the steps below:

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

2) On the database server, allow the connection to the intermediary server on the port that will be used

3) On the Kondado platform, go to add data sources and select the Microsoft SQL Server SSH data source

4) Give your data source a name and fill in the information for your intermediate server and then your database. In “Server PEM key” just copy the text of the file with the PEM key.

Now just save the connector and start replicating your SQL Server SSH data into the Data Lake or Data Warehouse.

Pipelines

Tables and Views

With our pipelines, you will be able to replicate tables as well as views
If your table has a datetime/timestamp type column that marks when a record was changed/inserted, your pipeline 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 the destination will have a format similar to the one below:

Field	Type
col_x	text
col_y	text
col_z	text