Connecting KNIME with SAP

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 

1 Like

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.

1 Like

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

2 Likes

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

2 Likes