The Netherlands Tax Authority is rolling out the German application SAP for their key processes. The American application SAS is implementend for BI and Analyses of the key processes of the Netherlands Tax Authority. The connection between de process apllication SAP ECC and the BI application SAS is yet pragmatic, using extracted text files. In which way can the Netherlands Tax Authority professionalize the connection between SAP and SAS?
Zéger Nieuweboer, Data Steward, 2015
Have you discussed this with your SAS account manager? I believe that SAS has the ability to connect very nicely to SAP data, but I'm not familiar with the details.
The local SAS office should be able to set up a demonstration.
Tom
Just to get you started:
SAS/ACCESS(R) 9.4 Interface to R/3: User's Guide, Second Edition
SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Sixth Edition
Just to add to what Linus said, not that it needs it.
There is a relatively new product out.
SAS/ACCESS to SAP Hana - it is covered in the ACCESS manual.
There is also a Scoring Accelerator for Hana.
I don't see a problem with using SAP unloads (text files) as import data for SAS. That way the unloads can be run when the SAP system is mostly idle, with direct access you risk deteriorating SAP performance when SAS analyses are run.
We (large worldwide operating insurance company) do the same, with our main DB/2 database and SAP.
Can you please contact me directly on this subject? I can't answer you publicly
Regards,
Rens Feenstra
SAS Netherlands
I believe in this public forum we should try to not provide any information which can be traced back directly to customers.
Thanks Patrick, we have edited out the sensitive information.
Anna
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.
Lock in the best rate now before the price increases on April 1.
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.