ServiceJVMLocation: C:\Program Files\Java\jdk1.8.0_XXX\jre\bin\server
ServiceJVMClassPath: C:\Program Files\Progress\DataDirect\oaserver81\ip\oajava\oasql.jar;C:\Program Files\Progress\DataDirect\oaserver81\ip; C:\<your-path-to> \snowflake-jdbc.jar
Note: Replace the JVM path and path to Snowflake JDBC driver appropriate to your local environment.
Note: Remove the attribute DataSourceIPSchemaPath
In the recent past, we have seen several customers having trouble to connect their Snowflake JDBC and ODBC drivers with OBIEE, Informatica, SAS and other popular applications. This is due to the DataDirect Driver Manager embedded by these applications that expect a supported ODBC driver. In this case, wrapping their JDBC or ODBC drivers with DataDirect's OpenAccess driver will make them compliant with these applications once again. Please follow the steps below to use your ODBC wrapped Snowflake JDBC (or ODBC) driver along with OBIEE:
With Progress OpenAccess SDK, you can now connect to your favorite data source using an ODBC interface via JDBC or using JDBC interface via ODBC driver. In addition to that, you can also choose to add your own customizations such as data masking etc., when you use OpenAccess SDK. Feel free to contact us if you have any questions or issues, we will be happy to assist you.