Microsoft SQL Server

Learn the steps for ingesting your Microsoft SQL Server data into your target.

Steps

Enable CDC for your source Microsoft SQL Server database.
Create a connection to your source Microsoft SQL Server database.
Create a connection to your target (see the Supported Targets list below for links).
Create the entities for your target per the list in the Job Type & Steps column below. Note that there are multiple options for ingesting to Snowflake:

Job Type & Steps	Supported Targets
Ingestion Job Create a staging table in the data lake Create an ingestion job to load data into the staging table Create a transformation job for each target	Amazon Redshift Amazon S3 AWS Glue Data Catalog ClickHouse Elasticsearch Polaris Catalog PostgreSQL Snowflake
Replication Job Create a replication job to ingest into multiple target schemas	Amazon Redshift AWS Glue Data Catalog Polaris Catalog Snowflake
Single Entity Job Create a staging table in the data lake Create an ingestion job to load data into the staging table Create a single entity job that auto-creates a sub-job for each source table to copy data to the target table	Amazon Redshift AWS Glue Data Catalog Polaris Catalog Snowflake

Job Type & Steps

Supported Targets

Ingestion Job

Create a staging table in the data lake
Create an ingestion job to load data into the staging table
Create a transformation job for each target

Replication Job

Create a replication job to ingest into multiple target schemas

Single Entity Job

Create a staging table in the data lake
Create an ingestion job to load data into the staging table
Create a single entity job that auto-creates a sub-job for each source table to copy data to the target table

No-code Wizard

Alternatively, you can use the Upsolver no-code Wizard to get your pipelines started in super-quick time. The Wizard generates the code for you so you can optionally customize it for your requirements, and create advanced use cases.

Microsoft SQL Server

Steps

Quickstarts

How To Guides

Reference

Articles