SAS ACCESS to ODBC Setup on SAS Viya 4 (Kubernetes)

[Mahis]

Hi everyone,

Has anyone successfully configured SAS ACCESS Interface to ODBC for a database like ClickHouse on SAS Viya 4 (Kubernetes)?

We tried to follow a setup example for SAS ACCESS Interface to Oracle, but we noticed that the environment variable setup and YAML configuration structure are quite different for ODBC.

We have already installed the driver: clickhouse-odbc-1.4.1-Linux

At this point we're not sure about the next steps and would really appreciate some guidance:

• Where should the ODBC DSN and environment variables be defined?

• Do we need to create .odbc.iniand .odbcinst.inimanually or are they generated automatically after installing the driver?

• Which Kubernetes config files (e.g. kustomization.yaml, config maps) should be created or updated to integrate ODBC correctly?

Any help or shared experience would be really helpful.

Thanks in advance

[gwootton · Accepted solution]

The README.md file in $deploy/sas-bases/examples/data-access/README.md describes how to configure SAS/ACCESS Interface for ODBC. You would be supplying to Viya a Kubernetes volume containing your drivers and your ODBC/ODBCINST files, and setting variables in sas-access.properties that point to those files from within the pod.