Has anybody done ever a SAP RFC connection out of XOJO in windows or in macOS?
You need a user un the destination system. Also, the transactions that you want to use must be enabled to perform RFC connexions (or to receive them). I am not an ABAP developer but a functional consultant, so this is about as deep as I can go right now.
In short, there needs to be some work done inside SAP or Netweaver to allow any connexion to happen. If the server is hosted in the cloud as is the current trend, it will be more complicated. You will have several security layers to deal with.
Here is a bit of information to get you started once the prerequisites are done in SAP:<.
Is the Python RFC Connector executable on macOS?
The problem for me is not the side of SAP ( ) but the side of XOJO.
There is the SAP Java Connector for all platforms. If you want to use that, you would have to use JAVA in the XOJO program and JAVA would have to be installed on every platform for using this XOJO program.
Then there is the SAP Connector for Microsoft .NET 3.0, which, as I understand it, can be used in Visual Basic.
And finally the SAP NetWeaver RFC SDK. This has a C / C ++ interface.
My hope is that maybe someone has already used the SAP Connector for Microsoft .NET. If it’s possible in VB, then maybe it could also be possible in XOJO?
I’ve read the installation description of pyrfc 1.9.94 and yes, it is executable on macOS.
I had been able to link SAP ERP 7.50 with XOJO with the “SAP Gateway”. That was the easiest way. Actually, the SAP Gateway is meant for programming Fiori SAP UI5 / openUI5 apps with it, but it is quite normal JSON data [ODATA to be exact], which you then get or send [“post”] with your XOJO app.
Hi Marcel!
The “SAP Gateway” seems to be a good way. I will take a look into the SAP documentation.
Thanks!
IRC long ago (maybe 10 years or so) i connected to SAP with the odbc plugin of REALbasic, maybe it’s still possible with Xojo now.
@Andre Kuiper : Connect an App directly with SAP is very dangerous. Do you write directly to the database?
I would always use the “SAP Gateway” - way, because an attack from outside don’t get to SAP or the database.
@Michael Eckert : I think you speak German, too? If yes, I used this book:
https://www.rheinwerk-verlag.de/sap-gateway-und-odata_4051/
But, attention, a new one will release soon: https://www.rheinwerk-verlag.de/sap-gateway-und-odata_4802/
Perhaps, this old thread is helpful, too. I had problems with the x-csrf-token of the SAP-Gateway in the past. The solution is in the same thread: https://forum.xojo.com/44032-x-csrf-token/p1#p371741
Hi Marcel!
I’ve just this afternoon ordered this book https://www.rheinwerk-verlag.de/sap-gateway-und-odata_4051/
The new edition is announced for May.