connect Netezza database to CASLIB using odbc data connector

marathon2 — Fri, 16 Sep 2022 22:25:53 GMT

I used the following codes to create a caslib that connects to Netezza databases. However, I can't make the connections successfully.

proc cas;
caslib odbctables desc="odbc_conn" sessref=mySession datasource= (srctype="odbc", authenticationDomain="NZAuth", odbc_dsn="INSERT_DSN_NAME", schema="INSERT_SCHEMA_NAME", catalog="*");

quit;

ERROR: The connection to the data source driver failed.

ERROR: Invalid value for connection string attribute CATALOG: ODBCCASLIB

ERROR: Function failed.

ERROR: The action stopped due to errors.

I set up an odbc connection using "ODBC Data Sources" on Windows, where the dsn name equals "INSERT_DSN_NAME"; I also tested the connection, to make sure the connection worked.

topic connect Netezza database to CASLIB using odbc data connector in SAS Programming

connect Netezza database to CASLIB using odbc data connector