Skip to main content

I need to copy specific data from the SAP ECC 6.0 tables listed below and paste it into the matching SAP S/4 HANA tables. 

  • ADMI_FILES
  • ADMI_RUN 
  • ADMI_STATS
  • ADMI_VARIA

I attempted to copy the data manually, and it worked. However, could you please advise if CData JDBC Driver could be used to accomplish this?

Hi ​@ashish.pancholi 

Is your SAP ECC and S/4 Hana hosted on-premises or on-cloud via the SAP gateway?

CData provided two distinct JDBC drivers for connecting to SAP ERP systems:

1.) CData SAP ERP JDBC Driver: The driver uses the SAP RFC interface to connect to an SAP system and enables relational access to tables, queries, and function modules in your SAP R/3, NetWeaver, or ERP/ECC 6.0+ system. See Supported Editions and Content for further details about what editions of SAP and content are supported.
NOTE: This is a read-only driver and doesn’t support write-backs into SAP systems.

2.) CData SAP Gateway JDBC Driver: The driver leverages the SAP Gateway API to enable bidirectional access to SAP services that use the gateway. This includes but is not limited to S/4 HANA, S/4 HANA Cloud, ERP, and any other editions that support the SAP Gateway.
NOTE: This is a bidirectional driver and supports writebacks into SAP systems.

Depending on how your SAP ECC and SAP S/4 Hana is hosted, you can use one of the JDBC drivers mentioned above to accomplish your business use case.


I appreciate ​@Ankit Singh prompt response. As you confirmed, the CData SAP Gateway JDBC Driver will function in my case, as both SAP ECC and S/4 Hana are hosted on-premises.

Regards