BookmarkSubscribeRSS Feed
milts
Pyrite | Level 9
hello,

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

In DI Studio how can you create libraries for MSSQL?

thanks!
7 REPLIES 7
Doc_Duke
Rhodochrosite | Level 12
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
LinusH
Tourmaline | Level 20
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
milts
Pyrite | Level 9
which library type will i use? ODBC library or Microsoft SQL Server for Unix Hosts?

thanks!
LinusH
Tourmaline | Level 20
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
CameronLawson
Obsidian | Level 7
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.
milts
Pyrite | Level 9
is there a step by step guide/document for assigning the library via smc?

thanks!
LinusH
Tourmaline | Level 20
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 853 views
  • 0 likes
  • 4 in conversation