Connect SAP R/3 using KNIME nodes directly

Dear Team

Can you let me know if we can connect the SAP R/3 systems via KNIME nodes directly (without using other software (theobald or dvw connectors))? Kindly help to suggest the recommended methods? Thanks.

Hello @Ashwath5245,

I asked internally, we do have support for connecting to HANA using its jdbc driver. You can find more details in this documentation about registering JDBC drivers and connecting to databases.

However, it is not recommended to do so. Following response is from internal team member:

If they are using S/4HANA (SAP on HANA), then they can query the database, as long as they have a license to do so. This is a feature they would need to license from SAP to be able to use. Not sure if it’s a paper license, or if there is code that would enforce this feature.
Regardless of the DB that SAP is running on, the table layout is not designed to be human readable, so they would need to know the specific tables the data they want resides in. Also, a good number of tables only exist in the application, and are not in the database.
There are many API’s available to get data from the application layer, Java (JCo) , REST and Python. Depending on what data they are trying to retrieve and api connection maybe an easier option.

Best,
Ali

2 Likes