CODEWITHSUNDEEP
azure-data-factory
Harsimranjeet Singh
Harsimranjeet Singh

Reputation: 524

Does Incremental Sync with Azure Data Factory V2 support only Sql Server to Azure SQL

I was trying incremental sync to design incremental sync data between MySQL and Azure Sql referring article and while designing pipeline for new watermark found that lookup component only support SQL SERVER.

Question

Is there a way to sync incrementally on cloud from hosted Mysql to Azure SQl using ADF v1/v2?

What other component we can use to select data from Mysql i tried Store Procedure but it support Sql server only.

Upvotes: 0

Views: 381

Answers (2)

ShirleyWang-MSFT
ShirleyWang-MSFT

Reputation: 266

We (ADF team) are actively working on expanding Lookup activity to support more data stores including MySQL. We will announce when it's ready. Please stay tuned!

Upvotes: 1

Mark Kromer MSFT
Mark Kromer MSFT

Reputation: 3838

Currently, the ADF Control Flow activity "Lookup" does not support MySQL, so the watermark table must exist in an entity that Lookup can communicate with, ao you can create the watermark table and associated sprocs in Azure SQL DB, while pulling the source data from MySQL tables.

Upvotes: 0

Related Questions