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
Where is OneStream installed? On your machine? Your own hosting? Cloud? If it isn't installed on your local machine then it would not be able to use that connection string as it has no idea where your MZUBAI machine is.
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?
OneStream can connect to an external database. I haven't gone through your code but you will need a connection string that has all the details that OneStream needs to find your database and authenticate, e.g., your IP address and credentials.
I'm assuming you're doing this for testing or learning. If not I would suggest another approach to getting data into OneStream. I'm not sure what you're trying to do but you can obviously upload any file you want into OS and you can create custom tables in OS to store data.
I am doing it for learning and testing purposes. I am sharing the connection string below:
Dim externalConnectionString As String = "Data Source=localhost;Initial Catalog=BusinessRule;trusted_connection=yes;"
Can you let me know about other approaches? Also how can I make it work right now for testing and learning purposes?
Try this for connection strings: https://www.connectionstrings.com/
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.
