topic Re: SAS Data Integration in SAS Data Management

SAS Data Integration

GearyHinolan — Thu, 10 Dec 2020 01:21:42 GMT

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

Re: SAS Data Integration

Kurt_Bremser — Thu, 10 Dec 2020 08:26:20 GMT

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.

Re: SAS Data Integration

Kurt_Bremser — Thu, 10 Dec 2020 08:30:27 GMT

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.

Re: SAS Data Integration

LinusH — Thu, 10 Dec 2020 09:06:14 GMT

For any relational data source I would be surprised if they don't offer an ODBC interface (SAS/ACCESS to ODBC).