Your Data Sources must be created before you launch your Workspace. Restart your Workspace to see new Data Sources.
The environment must have the Arrow Flight SQL ODBC driver installed.
To install the Arrow Flight SQL ODBC driver, add the following lines to your Dockerfile.
USER root # ODBC Driver for Arrow Flight SQL RUN curl -s -o arrow-flight-sql-odbc-driver.rpm https://download.dremio.com/arrow-flight-sql-odbc-driver/0.9.1/arrow-flight-sql-odbc-driver-0.9.1.168-1.x86_64.rpm RUN sudo yum -y localinstall arrow-flight-sql-odbc-driver.rpm RUN yum clean all && rm arrow-flight-sql-odbc-driver.rpm USER domino
The following SAS snippet shows you how to access Domino Data Sources using the SAS/ACCESS interface to ODBC and SQL pass-through to connect and send statements directly to the DBMS.
Enter your Domino Data Source name in the
options; proc sql; connect to odbc as mycon(datasrc="sqlserver"); select * from connection to mycon (select top 10 * from yellow_cab); disconnect from mycon; quit;
Troubleshoot SAS errors by viewing the error message and stack trace in the SAS Studio UI log.
Here are some common errors and solutions:
If a Data Source is created after launching the Workspace, it won’t generate an ODBC configuration causing the error, "Data source name not found and no default driver specified". To resolve the error, restart the Workspace.
The error "Flight returned internal error" indicates issues with the SQL statement or the use of an invalid SQL dialect.