Oracle EBS Cloud import data into OS Cloud
Hi, We want to import data from Oracle EBS Cloud (v.12.2.9) into OneStream Cloud. What would be the best way to do this? Should we use REST API? Thanks!
Forum Discussion
REST API is absolutely the most common method to have these two clouds talk to each other. Normally we would prefer to use a direct ODBC connection, but with cloud databases that is not always an option.
However, other options can also be to use a middleware solution, be it a file storage solution or a Datawarehouse, and have your Oracle Cloud push data there, then OneStream can go and retrieve tha data from the same. This is typically used when the size of the datasets are on the larger side and therefore not suited for a REST API approach.
Feel free to submit a ticket to our support desk, and they can route it to us in AAS Integrations to discuss the options you have available.