topic Re: Feasibility of SAS DI accessing SQL Server without ODBC in New SAS User

Feasibility of SAS DI accessing SQL Server without ODBC

Kohl — Mon, 20 May 2019 08:28:19 GMT

Hi everyone,

I know if I wanna retrieve data from SQL Server per ETL, there are either ODBC or JDBC options, but I just wanna know in SAS, if there are other possibilities to get data from SQL Server, I have found SAS has an engine SQLSVR, I have tried, but somehow it needs still the ODBC connection created in ODBC source, is it the case? So I don't have any other choices but only using ODBC to access SQL Server, do I? Thanks for replying.

Re: Feasibility of SAS DI accessing SQL Server without ODBC

Kurt_Bremser — Mon, 20 May 2019 08:55:12 GMT

If you have the necessary SAS/ACCESS module for your DBMS licensed, and a proper client for the DBMS installed and configured on the SAS server, you can directly access the DBMS without going through ODBC.

Re: Feasibility of SAS DI accessing SQL Server without ODBC

Kohl — Mon, 20 May 2019 09:18:51 GMT

Thanks.

I have the valid license for SAS/ACCESS Interface to Microsoft SQL Server.

Acc. to http://support.sas.com/documentation/cdl/en/acreldb/65247/HTML/default/viewer.htm#n0gz66qe8msnkyn1jgnhrr0l2k8y.htm

I have successfully created a Library with SQLSVR, but in Datasrc I still need to use ODBC, or what else can I do/input?

What do you mean "a proper client for the DBMS installed", for SQL Server what's the proper client? Thanks.

Re: Feasibility of SAS DI accessing SQL Server without ODBC

Kurt_Bremser — Mon, 20 May 2019 09:55:16 GMT

Once you have succeeded in creating a library for direct access to SQL Server, the infrastructure is in place and works.

To use this connection in DI Studio, the library needs to be defined in SAS metadata.

Re: Feasibility of SAS DI accessing SQL Server without ODBC

LinusH — Mon, 20 May 2019 19:58:01 GMT

SAS/ACCESS to SQL Server is using ODBC.