SAP RFC connection

  1. 2 months ago

    Michael E

    Mar 15 Europe (Deutschland, Heggen)

    Has anybody done ever a SAP RFC connection out of XOJO in windows or in 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.

  2. Louis D

    Mar 15 Pre-Release Testers, Xojo Pro Montreal, QC, Canada
    Edited 2 months ago

    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:<.

  3. Michael E

    Mar 16 Europe (Deutschland, Heggen)
    Edited 2 months ago

    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?

  4. Michael E

    Mar 16 Europe (Deutschland, Heggen)
    Edited 2 months ago

    I've read the installation description of pyrfc 1.9.94 and yes, it is executable on macOS.

  5. Marcel Z

    Mar 16 Pre-Release Testers, Xojo Pro Answer Kirn, RP, Germany.
    Edited 2 months ago

    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.

  6. Michael E

    Mar 16 Europe (Deutschland, Heggen)

    Hi Marcel!
    The "SAP Gateway" seems to be a good way. I will take a look into the SAP documentation.
    Thanks!

  7. Andre K

    Mar 16 Pre-Release Testers

    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.

  8. Marcel Z

    Mar 16 Pre-Release Testers, Xojo Pro Kirn, RP, Germany.
    Edited 2 months ago

    @Andre K : 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 E : 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

  9. Jean-Yves P

    Mar 16 Pre-Release Testers, Xojo Pro Europe (France, Besançon)

    the book exists in english.
    https://www.amazon.com/SAP-Gateway-OData-Third-PRESS/dp/1493217550

  10. Michael E

    Mar 16 Europe (Deutschland, Heggen)

    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.

or Sign Up to reply!