If i have a database on my system and have developed a flow can i host it on cloud
Is your on-prem database accessible from outside your local network?
I am trying to connect to Oracle DB(hosted on premise) through Boomi cloud atom and so it just seems impossible. However, the same connection was successful through local atom. We even made it accessible from outside our local network, and it still did not work. I see you comment "If yes, you should be able to connect to it via the atom cloud", can you provide additional info other that what I have done to make this work?
Are you able to connect to the db from outside of your network via another db client (e.g. sqlplus, sql developer)?
Yes, the db can be connected via sql developer from outside the local network.
FYI: the Oracle DB is 12c, which Boomi does not support. However, we have upload the 12c compatible ojdbc.jar file via custom library feature in Boomi. We used the same jar file in a local atom and can successfully connect.
If you've ruled out all networking issues between the atom cloud and your db, it might be caused by a conflict between your 12c driver and the default oracle driver included with the atom (v10.2). Depending on the classpath order, the first driver found will likely be used. It's possible that even though you are including the 12c driver, the 10.2 driver is still being used. I'm sure there are others who have had the need to connect to an oracle 12 db, so try reaching out to support.
Seth, Thank you for response. As advised, I will reach out to support.
Hi Ritushree Shukla,
Unfortunately that is a broad question and doesn't have a single answer. It would certainly depend on your organization's network and security. For us, we use an on-prem molecule for running integrations that need to interface between applications inside of our network. We also use those on-prem processes for reverse/forward proxy services so that on-prem applications are able to make/receive requests from outside of the network.
If you are looking for a solution with VPN - Boomi doesn't do this.. You either have to open firewall ports / ACLs to the outside world - or run local Atoms. You could probably build a hybrid architecture similar to what John is talking about where you expose internal services / applications / endpoints via API in Boomi on-premise.. And then orchestrate using Cloud Atoms.
Retrieving data ...