Can SAP Integration Suite Push Data to S/4HANA On-Premise via JDBC Adapter?

[shin861231]

Hello experts,

I am currently working on a data integration process where I need to fetch data from a third-party system, perform some transformations within SAP Integration Suite, and then insert the data into an on-premise S/4HANA database using the JDBC adapter.

Would this be a feasible approach?

For reference, the workflow looks like this:

📁 CSV File → SAP Integration Suite → (JDBC Adapter) → SAP S/4HANA DB (On-Premise)

I understand that OData adapter is the more common approach, but we are currently exploring alternative ways to exchange data between Integration Suite and S/4HANA DB.

Has anyone successfully implemented a similar solution? Any insights or recommendations would be greatly appreciated!

Thank you! 😊

[Ryan-Crosby]

At no point should a direct update via JDBC be explored... there's a reason that there is an application layer sitting on top of the database.

[bryan_cain]

Why would you do this?  First, S/4 HANA has much better integration options with SAP IS through the ABAP layer.  Second, direct DB updates could cause data inconsistency.  Third (and possibly most important), direct DB updates might be a violation of your license with SAP.  You’ll need to check your own contract.

That said, in theory it’s possible.  There is a HANA JDBC driver.  But you shouldn’t do it though, it’s a very bad idea.

[Ryan-Crosby]

Kudos to your more thorough response... 😉