SAS VA | SAP
Hi All,
Can anyone help me with materials, docs, website URLs that explains how to connect SAS Visual Analytics to SAP Data Source and fetching the data?
It would be good to see how it can be done, it's architecture and other relevant information.
satlr
@sat_lr, You can SAS Visual Data Builder to create queries to pull data from any SQL database using SAS/ACCESS to SAP. I know that is a pretty basic answer and having seen other posts and responses from you, I get the feeling that you are looking for more detail. I'd be happy to provide those details if you can give me a better idea of what it is you are looking for or what problems you are trying to solve.
-David.
Hi David, thanks for your prompt reply.
That's correct, I am looking for in-depth details of how it can be done, what are the resources that I need to consider to perform this task successfully. what would be the steps/ procedures to be followed and above all need to know what are the requirements that I need to gather and plans to be made before initiating the overall task.
The source system is SAP Production module. I am in need to have a holistic view from business perspective to the granular level of performing the task and that is what I am looking for here. I got several questions in mind after going through the SAS/Acccess Interface to SAP doc available on SAS Access Site. But for now, it would be helpful to get a holistic view of the complete task.
The end output would be to develop production related dashboards, KPIs, reports in SAS VA.
If your SAP environment happens to be SAP HANA, you may want to check out this SAS Global Forum Paper http://support.sas.com/resources/papers/proceedings14/2445-2014.pdf, summarizing how you can leverage data from SAP HANA within your SAS environment and applications.
-Christoph
hi chrismo, I've gone through this paper before. I have drawn several requirements that I have with me. how to pull up the relevant data that I need by not missing the useful fields. so little bit field clarity is needed here which I am looking for. the source system has 65k tables. any suggestions?
satlr
Is your SAP environment based on SAP HANA? SAP HANA Live virtual data models provide excellent insight to the SAP Business Suite data models.
Rgds,
Christoph
yes this must be one of the SAP Business Suites ERP module i.e SAP PP. I am looking here to understand how the data is stored. Objective is to build relations between production and sales data. Requirements to be drawn so as to what data to pull out. greetings
satlr
The latest release update for Visual Analytics 7.1 also supports direct SAP HANA connectivity for data loads!
Cheers,
Christoph
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.