HANA --> SAS Connectivity

[KamalMehta]

Hi Team,

Can anybody please suggest how does HANA and SAS are connected.

Do we have to use BODS to transfer data from HANA to SAS or some driver such as ODBC can be used .

Thanks

Kamal

[ChristophMorgen]

SAS stores data is individual files per talbe on the operating system in a properietary format (*.sas7bdat), which cannot be read by other applications.

To transfer data from HANA to SAS:
a) push from HANA is not really possible. While SAS provides a ODBC driver it is rarely present and used + may require additional SAS modules (SAS/Share, ...). One may write flat-file export scripts and call SAS to import those.

b) pull, from SAS on can use SAS/Access to HANA (module introduced with SAS 9.4.

To transfer data from SAS to HANA

c) pull from HANA, similarly to a).

d) push from SAS to HANA, similar to b).

Rgds,

Christoph

[KamalMehta]

Can anybody update on this.

Thanks

[ruediger_karl]

Hi Kamal,

SAS provides an embedded process running on the HANA server. HANA and the SAS process exchange data via shared memory. This is a native, in-memory hand-shaking between SAS and HANA for predictive analytics. Finally, SAS servers communicate via this SAS process with HANA.

Regards, Ruediger

[KamalMehta]

Hi Karl,

Thanks for your reply.

Can you please let me know what exactly is required in order to setup the medium to exchange data between these 2 environments.

Also it seems as per your reply that we dont need tools like BODS to do the same. Still can you elaborate on the prerequisite to have the same done.

Thanks