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.
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!
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.
