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
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/