DATA Step, Macro, Functions and more

ms sql

Reply
Super Contributor
Posts: 318

ms sql

hello,

what are the different ways SAS can connect to a MSSQL source?

In DI Studio how can you create libraries for MSSQL?

thanks!
Trusted Advisor
Posts: 2,113

Re: ms sql

The MIcrosoft preferred method to connect to SQL Server is via ODBC and that is the route that SAS supports.

If you still have SAS 8.2, you can connect via SAS/Access to Sybase.

Sorry, don't have DI Studio access.

Doc Muhlbaier
Duke
Super User
Posts: 5,256

Re: ms sql

You can also use ACCESS to OLEDB.
In DI Studio just run the New Library Wizard (accessed via Source/Target table Designer wizards).

In management console this can be done in the Data Library Manager plugin.

/Linus
Data never sleeps
Super Contributor
Posts: 318

Re: ms sql

which library type will i use? ODBC library or Microsoft SQL Server for Unix Hosts?

thanks!
Super User
Posts: 5,256

Re: ms sql

Can't say that I had an opportunity to compare the both. I might go for ODBC beacuse it would give some flexibility to read other sources. And I believe that nativity is not a problem since ODBC and SQL Server are from the same factory...
You might want to contact the institute for a second opinion.

/Linus
Data never sleeps
Contributor
Posts: 66

Re: ms sql

two ways you can assign the library;
1. Via smc: you will need appropriate access. With this method you can control security etc.
2. The easiest way is to place the libref in the application server autoexec.sas file. Whenever a session opens, the library will be assigned. It will make it more difficult however to control security etc.
Super Contributor
Posts: 318

Re: ms sql

is there a step by step guide/document for assigning the library via smc?

thanks!
Super User
Posts: 5,256

Re: ms sql

If you cared to search support.sas.com you'd probably come up with this doc:

http://support.sas.com/techsup/technote/ts726.pdf

among others.

Linus
Data never sleeps
Ask a Question
Discussion stats
  • 7 replies
  • 130 views
  • 0 likes
  • 4 in conversation