topic Re: SAS passthrough execution in Spark with JDBC or ODBC connection in SAS Programming

SAS passthrough execution in Spark with JDBC or ODBC connection

umeshMahajan — Tue, 29 Jan 2019 21:21:00 GMT

Does SAS Support passthrough execution in spark using either JDBC or ODBC driver?

If I used JDBC or ODBC friver from SIMBA (https://www.simba.com/drivers/spark-jdbc-odbc/ ) can i do execution in spark and return result in sas as a sas dataset? is there SAS Access for spark available? or i have to use JDBC/ODBC drivers? and will it work?

Re: SAS passthrough execution in Spark with JDBC or ODBC connection

ChrisNZ — Wed, 30 Jan 2019 00:33:18 GMT

There is no reason ODBC should not be usable.

You should also be able to use pass-through.

libname SPARK odbc <connection parameters>;
proc sql;
  connect using SPARK;
  execute by SPARK ( pass-through code );
  select * from connection to SPARK ( pass-through query );
quit;