Azure Pub Sub solution based on Oracle on prem database table events

Question

I am trying to create a proof of concept for a PUB SUB pattern using changes to an on prem Oracle Database table. New rows added to the table should be pulled from the table in near real time and published to Service Bus queue.

I have set up a Data Factory and Dataset on the table and we have the Service Bus queue. Could I copy the Oracle Data to a Data Lake or Blob Storage, and then use a logic app to send new events to the Service Bus queue?

Answer 1

Hello @Hunter, Natalie - Thanks for reaching out and posting on MS Q&A! Regarding:

Could I copy the Oracle Data to a Data Lake or Blob Storage, and then use a logic app to send new events to the Service Bus queue?

Not sure how you're planning on handling the copying part but the Oracle Database connector supports on-premise connection: Connect to Oracle Database from Azure Logic Apps Since this connector doesn't support any triggers at this time, it might take some legwork to determine the new rows. If you choose to use this connector, be sure to thoroughly review its reference page for any gotchas: https://learn.microsoft.com/en-us/connectors/oracle/#known-issues-and-limitations

Once the data is on Data Lake or Blob Storage, Logic Apps can definitely handle taking that data to the Service Bus Queue part. Referencing the following docs as they may be helpful:

• Azure Data Lake Connector
• Azure Blob Storage Connector
• Service Bus Connector

I hope this helps, if you have any questions, tag me in the comments and let me know.

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

Please consider contributing to MS Q&A by marking 'Accepted Answer' and ‘Upvoting’ as applicable.