Any Alternative Change Data Capture in SSIS from an azure SQL database

RTamagnini 40 Reputation points
2024-01-04T12:55:19.27+00:00

Since SQL Azure below S3 does not allow using CDC in SSIS, is there any alternative?

if Sql Azure allows the activation of CDC, even creating tables/views and functions related to CDC , is there any way to use it in SSIS?

Thanks in advance

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,697 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 34,661 Reputation points MVP Volunteer Moderator
    2024-01-04T14:08:51.91+00:00

    You can track your LSN windows and write yourself the CDC apply logic. SSIS has the CDC extract and apply functionality built-in, and you can run SSIS CDC data flows either on your on-premises SQL Server, or in an Azure Data Factory SSIS runtime.

    You can also use timestamps and triggers to achieve the same. On the comments I gave you an example.

    Another option is to try Striim on Azure Marketplace which offers some CDC functionality.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.