Hi,
I hope any one can help me. I'm confused between SAS Data Integration and SAS/ACCESS.
I know that SAS DI includes SAS/ACCESS and use DI to Extract, Transform, Load Data (ETL).
But in what scenario you don't need DI and use SAS/ACCESS only?
if the database/data source not supported by SAS/ACCESS that's the time we need to get DI?
thanks
Apples and Oranges.
SAS/ACCESS modules are separately licensed parts of the Base SAS software that enable access to different data sources (like MS Office files, ODBC, DBMS systems like Oracle, Teradata, ...).
Data Integration Studio and DI Server are a framework that assists in automated creation of jobs (from metadata that describes data), and helps in following the path of data during the whole ETL process, for impact analysis. It works with a Business Intelligence Server backend.
For those who do not need the DI framework (because they already have something that is similar in function), SAS/ACCESS is still useful in accessing foreign sources (e.g. we use ACCESS to PC Files without having the DI framework). DI is not needed to make use of SAS/ACCESS modules.
For your last question: to have direct access to a DBMS, you need the respective SAS/ACCESS module, period.
If a certain DBMS is not covered by any of the SAS/ACCESS modules (which would mean it's either very new or very exotic), you can always go the way that we do: export data from the DBMS to text files and read those with simple data steps. Can be done by writing code on your own or using the respective transformation available in DI Studio.
For any relational data source I would be surprised if they don't offer an ODBC interface (SAS/ACCESS to ODBC).
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.