In the current business environment, there are lot of data sources being used and constantly data is being pulled into one DataMart/DataWarehouse from another data source. In certain environments I have seen SAS being used very heavily. One of my blog readers had a question about how to import data from SAS into SQL Server. One of things to be taken into consideration is what environment is SAS running currently. SAS runs on large UNIX environments and also PC windows based environments. In case SAS is running on windows, Here are the options available: The following Link talks about Bulk Loading For ODBC:
http://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a002105630.htm,
Here is a reference to:
SAS/ACCESS Interface to Microsoft SQL Server
http://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a002299545.htm.
The above link mentions about how to export data from SAS to SQL Server. The other approach is to use SAS and export data to a file location in a flat file/.csv format and then use ETL tools to pull data from the file location.
There are cases where we would want to use SSIS to pull data from SAS. First one would need the SAS Providers for OLE DB, please use the link below:
http://support.sas.com/demosdownloads/setupcat.jsp?cat=SAS+Providers+for+OLE+DB
Please refer to the blog by Rafi Asarf: titled loading SAS files with SSIS.
http://sqlserverjedi.wordpress.com/2012/02/08/loading-sas-files-with-ssis/
The above link provided detailed information on how to import data from SAS using SSIS. Also read the comments section where in certain error situations have been discussed.
Hope all of these provide enough information on working with data from SAS.
thanks for the links. can u turn off the Capcha? its annoying.
ReplyDeleteHi Stas,
DeleteThanx for the feedback, turned off the capcha.
Thank you