OneStream Connector Business Rule
Hi,
I am trying to establish a connection between OneStream and my local SQL server but getting below error.
A network-related or instance-specific error occurred while establishing a connection ...
Forum Discussion
Thanks for the response.
OneStream database is not on my machine it is cloud based. Is there anyway to connect to get data from local database or this is not possible at all and you have to have both the databases i.e. external and OneStream on same server and location?
With OS in the Cloud and your SQL Server DB presumably local to you (behind a firewall), you will need to make use of OS SIC to get through the firewall and use an SIC exposed Connection. If your SQL Server is outside the firewall, then you would need to make sure you use a fully qualified server name in order for OS to find it.
Thanks for your response.
What do you mean by OS SIC and SIC exposed connection? Can you please provide some insight or documentation how to set this up?
OS SIC = OneStream Smart Integration Connector, which can be obtained with documentation from the OS Marketplace. in short, SIC replaces the need for VPN tunnels between your local network and OS in the Cloud. You install SIC on a server inside your firewall on your local network and define connections on the SIC to your various DB Servers, FTP, etc that you need access to, and then you define Custom Connections from OS to the SIC advertised connections. It sounds more complicated than it is. No more need for VPN, and sensitive information like credentials to the DB Servers is kept within your firewall and can be updated at will.