How to configure ODBC/JDBC in Viya Marketplace

[fnajera]

Hi team,

We're configuring SAS/ACCESS to ODBC in a SAS Viya Marketplace deployment, in order to connect to Denodo. However, although we modify the /viya-share/access-clients/odbc/odbc.ini and odbcinst, these changes are not reflected in the platform, even when we restart the environment.  Can you please give us a hand? 

We tried to use the JDBC alternative, but it's like if the /data-drivers/jdbc is not mounted correctly in the pods. Because, even when we put the driver in /viya-share/access-clients/jdbc. This is not detected by the platform.

It's important to say, that we are able to connect to Denodo from the Jumpserver, the problem comes when we want to make the drivers and odbc.ini files available to the compute and cas pods.

NOTE: In the official documentation, we don't have an example for ODBC configuration.

Please let us know if you need further information.

Thanks

Fernando.

[fnajera]

Please validate that the files sas-access.properties, and the data-mount-job.yaml files are correctly configured in the marketplace environment, because it seems like it's not working as expected.