Data Migration to Snowflake with Azure Data Factory
This is the second part in a 2 part series on how the cloud data integration service, Azure Data Factory, can be used to load data from on-premises databases into Snowflake, a cloud data warehouse. In this article, we’ll take you through a step by step guide of how Smartbridge does just that.
Azure Data Factory (ADF) can be used to migrate data directly from an on-premises database into a Snowflake database. This article explains the process used by Smartbridge in setting up our internal demonstration instance.
2. Download and install Azure Data Factory Integration Runtime on the on-premises server
Download the latest version of Integration Runtime HERE and Install on the local (on-premises) server.
3. Pair Cloud and On-Premises Integration Runtime
Once Integration Runtime is installed on the local server, it will open the Registration page. Past the first authentication key from Azure Integration Runtime in the box.
6. Create Azure Linked Service pointing to On-Premises Source Database
On the “Linked Services” tab (under “Connections”), click on “New” and add a RDB data source pointing to the on-premeiss SQL Server database.
7. Create Azure Linked Service pointing to Snowflake Target Database
On “Linked Services” tab, click on “New” and add an ODBC data source pointing to the target Snowflake database.
There’s more to explore at Smartbridge.com!
Sign up to be notified when we publish articles, news, videos and more!