What choices are there to have BizTalk talk to Oracle E-business Suite hosted in the cloud?
Today's BizTalk integration uses OracleDB adapter. I'd like to understand what adapter to use in the new scenario when database servers are not on premises anymore...
Requirements are to be able to poll Oracle EBS Cloud for changes (row/item level) to forward those to other systems, and to be able to send updates when other systems says so (row/item level).
Ideal would have been to use a queueus (like Azure Service Bus Messaging), but that requires Oracle Integration Cloud, with additional licensing fees that I can't argue for because they don't want additional integration plattforms that can't handle other, on-premise integrations.
This is a classic case of a hybrid integration which sounds completely feasible in your environment. I think of following patters using BizTalk, Logic Apps and Service Bus
1) With Logic Apps and BizTalk
You pull the messages from your oracle database using Azure Logic Apps(Get started with the Oracle Database connector)
You push those messages to the BizTalk using logic app to BizTalk (Install and use the Logic App Adapter on BizTalk Server) (Note: You can receive and send the messages from logic apps to and receive from BizTalk)
2) With Logic Apps, BizTalk and ServiceBus
In this approach, your logic app pulls the messages from the oracle database and then pushes the messages on a service bus and BizTalk receives and sends message to this service bus topic/queue
I would suggest you to refer few of the articles below
Hybrid integration with BizTalk Server and Azure
Unlocking Azure Hybrid Integration with BizTalk Server
Update:
A thing to note here is that the Oracle connector in logic app will connect to an oracle database on premises present over a VM. In cases it is made available as database as a service, then you can add azure function to the mix