08-19-2024 08:49 PM
Does anyone know if the local SIC gateway supports JDBC data sources (SIC Version number if appropriate) and if not is there are workaround for this ?
Solved! Go to Solution.
08-21-2024 05:03 AM - edited 08-21-2024 05:05 AM
As others said, OneStream is built on the Microsoft DotNet runtime, so you can't just drop a JDBC driver on it.
This said, most datasources that "support JDBC" have an equivalent ODBC driver for Windows, which will work in a similar way and would be accessible by OneStream once installed. After all, JDBC is effectively a clone of ODBC, meant for the Java world...
For the most obscure systems that really only provide a JDBC driver, one can use bridging solutions like the ones listed in this StackOverflow post.
In both cases, if you're a Cloud customer you'll have to engage Support once you know exactly what datasource it is.
08-20-2024 08:24 AM
Interested to see what others respond with here. It would surprise me if out of the box you could use JDBC since OneStream is a .NET based platform.
Maybe there's another way to accomplish the same outcome. Can you expand a little on the data source and your use case?
08-20-2024 06:14 PM
Thanks for response,
I don't have any more detail really at present, our client has stated that one of their on-premises databases uses JDBC for connection. I have asked them if there are any other connectivity options, and will update when i get a response. Do you have any suggestions ?
08-20-2024 06:26 PM
It would totally depend on the source system/s involved.
08-21-2024 05:03 AM - edited 08-21-2024 05:05 AM
As others said, OneStream is built on the Microsoft DotNet runtime, so you can't just drop a JDBC driver on it.
This said, most datasources that "support JDBC" have an equivalent ODBC driver for Windows, which will work in a similar way and would be accessible by OneStream once installed. After all, JDBC is effectively a clone of ODBC, meant for the Java world...
For the most obscure systems that really only provide a JDBC driver, one can use bridging solutions like the ones listed in this StackOverflow post.
In both cases, if you're a Cloud customer you'll have to engage Support once you know exactly what datasource it is.