SAP Connection from KNIME

Hi, I’d like to be able to analyse SAP data with KNIME on a daily basis, therefore I’m needing an SAP-KNIME connection. I actually need to connect both SAP ERP and SAP Sales Cloud with KNIME.
My understanding is that there are 3 ways to do it :
1/ Using the SAP Reader (Theobald Software) node that connects to Xtract Universal to extract the data from SAP
2/ Using the DVW KNIME Connector to SAP
3/ Using the proper driver sold for example by Cdata Software

Am I correct or is there any other way to do this? Specially I’m looking for a “no” or “low-cost” solution. Happy to get any suggestions!

Thank you in advance for your support, Amelie

The best low-cost solution is a direct database connection to SAP, something KNIME can handle out of the box with DB Connector and DB Query reader nodes. This is how I currently retrieve data from SAP ERP.

Perhaps you can arrange a read-only connection.

Thank you very much Arjen!
May I know which driver you’re using please?
Also would you know whether it’s also doable to connect KNIME withe SAP Sales Cloud data in the same way?

Hi Amelie,

The SAP instance I connect to is hosted on oracle so I use the associated db type and dialect and fill in the database URL accordingly.


What you have to use in your case is really dependant on how SAP is hosted, this can be on a lot of different db types. I recommend contacting your SAP admin to find out more.

Cloud I don’t know specifically but I expect it requires a similar approach.

1 Like

Oh ok, perfect, I’ll contact our SAP Admin.

Many thanks Arjen, that was very helpful!


This is for relational db like sap hana not bw right?

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.