Forum Discussion

ZubairCSC's avatar
ZubairCSC
New Contributor II
3 months ago

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 ...
Connectors
naveen1's avatar
naveen1
New Contributor II

Create a custom connection in Systeam config 

ZubairCSC's avatar
ZubairCSC
New Contributor II
3 months ago

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?

  • DanielWillis's avatar
    DanielWillis
    Valued Contributor
    3 months ago

    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.

    • ZubairCSC's avatar
      ZubairCSC
      New Contributor II
      3 months ago

      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?

      • DanielWillis's avatar
        DanielWillis
        Valued Contributor
        3 months ago

        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.