Setup On-Prem Oracle DB connection in OneStream Cloud

As was already replied above, our excellent customer support would help you set this up, but in general terms you will need to setup the Oracle drivers/client on all the OneStream application servers, setup the tnsnames.ora file on all the same servers, and then setup the external connections inside the OneStream app config so that the connection becomes visible in your OneStream applications and can then be leveraged to read and write data (of course pending on access rights). This is a very high level overview, and in order to accomplish the steps above, you might need a VPN tunnel setup, and possibly other security measures such as firewalls needing opening, IPs needing whitelisting etc, all depending on your current IT policies.

Keep an eye out for the new solution coming soon, called Smart Integration Connector, where all the configurations for this will move from OS servers, to be handled inside your own environment instead.

I hope that helped a little.

Joakim