BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Rodgers_125
Obsidian | Level 7

Hello experts,

 

I'm studying how can Hadoop is integrated with SAS, and I read that SAS Data Loader is responsible for extract data to or into Hadoop. But I read the same thing about SAS/Access for Hadoop. 

Anyone knows if it are the same thing or have different goals?

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
LinusH
Tourmaline | Level 20

They are not the same thing.

 

SAS/ACCESS is a data bse engine that leats you read/create data in an external RDBMS (like Hive) from a SAS session, using SAS code, like SQL, data step and procedures.

 

Data Loader is a package, with an application that lets you do data management stuff via a UI.

Not sure if SAS/ACCESS to Hadoop is included in that package, but similar functionality definitely is.

And there are more functionality available in the Loader, like in-database processing (which could be purchased as an add-on to a regular SAS/ACCESS license).

 

Check the product pages for each product as support.sas.com, they are quite informative.

Data never sleeps

View solution in original post

1 REPLY 1
LinusH
Tourmaline | Level 20

They are not the same thing.

 

SAS/ACCESS is a data bse engine that leats you read/create data in an external RDBMS (like Hive) from a SAS session, using SAS code, like SQL, data step and procedures.

 

Data Loader is a package, with an application that lets you do data management stuff via a UI.

Not sure if SAS/ACCESS to Hadoop is included in that package, but similar functionality definitely is.

And there are more functionality available in the Loader, like in-database processing (which could be purchased as an add-on to a regular SAS/ACCESS license).

 

Check the product pages for each product as support.sas.com, they are quite informative.

Data never sleeps

sas-innovate-wordmark-2025-midnight.png

Register Today!

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.


Register now!

How to connect to databases in SAS Viya

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.

Discussion stats
  • 1 reply
  • 999 views
  • 0 likes
  • 2 in conversation