question

KuldeepChitrakar-0966 avatar image
KuldeepChitrakar-0966 asked ·

Realtime time data from on premise databases

Hi

Suppose I have 8 databases on premise and if i want to implement the lambda architecture then How can i ETL the data from these on-premise databases into cloud databases/storage in realtime.

  1. Can i use the Event hub for this?

  2. Is there any better approach to do this

  3. do i need to write producer app too for event hub to stream realtime on-premise relational data to cloud

azure-stream-analyticsazure-event-hubs
3 comments
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


Hello @KuldeepChitrakar-0966 and welcome to Microsoft Q&A.

Before I can give you a good answer, I need to know more about your situation and goals.
ETL stands for Extranct Transform Load. What transformations are you looking to do, or do you just want to move/copy the data to cloud? Also, what sort of sink are you planning to use?

While Event hub is one approach,The approach depends upon the details of your needs.

If your source databases are SQL, there are two features you should look into. "Data sync" and "Transactional replication".


0 Votes 0 · ·

@KuldeepChitrakar-0966 did you get a chance to review my suggestion or get more details on your requirements?

0 Votes 0 · ·

I haven't heard back from you, @KuldeepChitrakar-0966 . Are you still in need of assistance?
If you found your own solution, could you please share it here to benefit the community?

Thank you.

0 Votes 0 · ·

0 Answers