search

piersharding / RSAP

SAP NW RFC connector for R
21 stars 16 forks source link

SAP ECC/ABAP connection with R #17

Open lejarx opened 4 years ago

lejarx commented 4 years ago

Hi Pier,

I was looking for ways to connect R with SAP (not Hana), and stumbled upon your RSAP package. Do you any whether this is currently feasible?

Thanks!

piersharding commented 4 years ago

Hi - RSAP should still work for RFC calls against the ABAP NetWeaver stack.

lejarx commented 4 years ago

Is there any tutorial on how to make a simple select query from SAP table? Thanks

piersharding commented 4 years ago

Hi - there is no tutorial, but a starting place might be to look at the tests for instance https://github.com/piersharding/RSAP/blob/master/tests/7.R

Cheers, Piers.

lejarx commented 4 years ago

Hi @piersharding

Apologize for the late reply.

I'm on Windows , how do I find the path for the arguments below?

Thanks

install_github('piersharding/RSAP', 
               args=c("--configure-args='--with-nwrfcsdk-include=/home/piers/code/sap/nwrfcsdk/include --with-nwrfcsdk-lib=/home/piers/code/sap/nwrfcsdk/lib' --no-clean-on-error"))
lejarx commented 4 years ago

Hi @piersharding

My SAP NetWeaver is currently installed in this folder

C:\Program Files (x86)\SAP\FrontEnd\SAPgui So what I did is, I run the installation with the following argument

install_github('piersharding/RSAP', args=c("--configure-args='--with-nwrfcsdk-include=C:/Program Files (x86)/SAP/FrontEnd/SAPgui --with-nwrfcsdk-lib=C:/Program Files (x86)/SAP/FrontEnd/SAPgui' --no-clean-on-error"))

And below is the error I get

 installing *source* package 'RSAP' ...
** using staged installation
ERROR:  C:/nwrfcsdk/lib  lib directory does not exist.  You must download the NW RFC SDK and ensure that it is located in C:/nwrfcsdk. 
ERROR: configuration failed for package 'RSAP'

I tried moving the files from C:/Program Files (x86)/SAP/FrontEnd/SAPgui to C:/nwrfcsdk but apparently my installation doesn't have this lib folder.

Are you aware of any latest guide on making this work on Windows?

I followed this one https://blagrants.blogspot.com/2012/06/analytics-with-sap-and-r-windows.html

Thanks