Forum Discussion

Mikki's avatar
Mikki
New Contributor III
2 years ago

Setup On-Prem Oracle DB connection in OneStream Cloud

Hi All, I have been trying to understand the process to setup On-Prem Oracle DB connection in OneStream Cloud to export data from cube. Is there a document that you guys can point to?  The doc I fo...
Data Management
Data Sources
  • JoakimK's avatar
    JoakimK
    2 years ago

    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

JoakimK's avatar
JoakimK
Contributor
2 years ago

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