How to ingest CDC data from SQL DATA SYNC to Event hub?

THIMMAIAH GARI,PRASHANTH,, 201 Reputation points
2020-11-10T12:28:43.067+00:00

Hi

we have a scenario to implement real-time CDC from SQL DATA SYNC to Azure SQL DB.

Which tools are good for near real-time processes and prices as well.
By using data bricks we can merge stream data into delta lake. But How to ingest real-time CDC from SQL data sync to the Event hub?

we are exploring Event hub, Stream Analytics, Databricks

Any better approach?... Please help me with this

Azure SQL Database
Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
546 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,890 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
329 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,341 questions
0 comments No comments
{count} votes

Accepted answer
  1. HarithaMaddi-MSFT 10,126 Reputation points
    2020-11-11T13:05:37.26+00:00

    Hi @THIMMAIAH GARI,PRASHANTH,, ,

    Welcome to Microsoft Q&A Platform. Thanks for posting the query.

    Please refer to the Microsoft documentation on various possible components that can be used for real time data processing. This article explains the approach on pushing real time data from SQL into an Azure Event Hub. The best component and architecture can vary according to various factors like data, project requirements, features needed and team skill set. Capability guides are shared in these articles - Ingestion and stream processing in choosing technology in azure that are helpful. Prices can be estimated for individual components from Azure Pricing Calculator.

    Hope this helps! Please suggest for further queries and we will be glad to assist.

    ---------------

    • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification.

0 additional answers

Sort by: Most helpful