Skip to main content
crappos
Aug 20, 2024 12:49 AM UTC
Solved

Jdbc database connection for SIC

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 ?

JackLacavaAnswer
Employee - Sage
Aug 21, 2024 9:03 AM UTC

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 https://stackoverflow.com/questions/44703240/net-core-options-to-connect-to-jdbc-driver.

In both cases, if you're a Cloud customer you'll have to engage Support once you know exactly what datasource it is.

View in thread

4 replies

tschilling
Member
Aug 20, 2024 12:24 PM UTC

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?

crapposAuthor
Aug 20, 2024 10:14 PM UTC

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 ? 

tschilling
Member
Aug 20, 2024 10:26 PM UTC

It would totally depend on the source system/s involved.  

Employee - Sage
JackLacavaEmployee - SageAnswer
Employee - Sage
Aug 21, 2024 9:03 AM UTC

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 https://stackoverflow.com/questions/44703240/net-core-options-to-connect-to-jdbc-driver.

In both cases, if you're a Cloud customer you'll have to engage Support once you know exactly what datasource it is.

Terms & ConditionsAccessibility statement