SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SAS and SAP BW / HANA interfacing via Data Surveyor

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

SAS and SAP BW / HANA interfacing via Data Surveyor

Hi,

 

After reading several guides and forums on interfacing between SAS and SAP BW/HANA I am still confused therefore I still have a question.

 

When we use the Data Surveyor and use it with BW is it meant to ETL data or can we keep the data in BW and report via SAS on this data?

If we can keep the data in BW and use SAS reporting is it performant for big datasources?

 

Or is it not possible and should we use the OLE DB setting within the BW query?

 

 

Thanks in avance,

Best Regards,

Eelco de Vries


Accepted Solutions
Solution
‎10-18-2017 05:14 AM
SAS Super FREQ
Posts: 108

Re: SAS and SAP BW / HANA interfacing via Data Surveyor

Hi,

 

Generally speaking, if you use Data Surveyor for SAP, you are querying SAP for metadata about available data, and you will be using that information to pull data into SAS Data Sets. From there, you can use any number of SAS applications to interact with the data. There's an extra step involved (loading the data into a SAS LASR server for SAS Viya CAS server) if you want to use SAS Visual Analytics for reporting.


Ron

View solution in original post


All Replies
Solution
‎10-18-2017 05:14 AM
SAS Super FREQ
Posts: 108

Re: SAS and SAP BW / HANA interfacing via Data Surveyor

Hi,

 

Generally speaking, if you use Data Surveyor for SAP, you are querying SAP for metadata about available data, and you will be using that information to pull data into SAS Data Sets. From there, you can use any number of SAS applications to interact with the data. There's an extra step involved (loading the data into a SAS LASR server for SAS Viya CAS server) if you want to use SAS Visual Analytics for reporting.


Ron

☑ This topic is solved.

Need further help from the community? Please ask a new question.

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