The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
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 ...
Create a custom connection in Systeam config
Thanks for your response.
Can you please guide me how can we create custom connection in system config? Where does this system config located? can you share some screenshots?
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.
