Hi guys,
Is there any ways to import data from SAP to KNIME?
Hi guys,
Is there any ways to import data from SAP to KNIME?
Hi mba026,
You can connect to SAP Hana using our Generic Database Connector with the SAP HANA jdbc
lib https://help.sap.com/viewer/52715f71adba4aaeb480d946c742d1f6/2.0.00/en-US/ff15928cf5594d78b841fbbe649f04b4.html
one of our partners offers a commerical SAP Hana Connector. If you are interested please send us an email to contact@knime.com
Best regards, Iris
Hi,
I read data from SAP ERP ECC 608 using the Python node.
It was quite tricky to prepare the environment, but it works fine now (install: pyrfc library, SAP Gui and the SAP nwsfcsdk library). The data is uploded via the Python node into the workflow table.
Have a nice day,
Laufi
PS You can use also the Theobald universal connector (for Knime 4.2+) but it needs investment.
Hello,
one can also connect to SAP using generic DB Connector node with appropriate JDBC driver. See here for more: SAP HANA Connection KNIME
Also here is a bit more on above mentioned Theobald connector: https://www.knime.com/whats-new-in-knime-42#sap-reader-theobald
Welcome to Community @Laufi!
Br,
Ivan
Ipazin could you please tell me from where can I get the URL template and URL database that are required to configure the connection
Regards
Hello @antacecor,
and welcome to KNIME Community!
For details about the driver and the connection URL please check out the SAP driver documentation. Iris provided link in reply to original post.
Additionally SAP connectivity can be achieved with DVW KNIME Connector for SAP(KCS):
Br,
Ivan