# Is it possible to copy selective data from SAP ECC to SAP S/4 HANA using the CDATA JDBC Driver?

**URL:** <https://community.cdata.com/t/is-it-possible-to-copy-selective-data-from-sap-ecc-to-sap-s-4-hana-using-the-cdata-jdbc-driver/942>\
**Category:** CData Drivers\
**Tags:** ecc-6.0, question\
**Created:** [November 18, 2024, 8:33am UTC](https://community.cdata.com/t/is-it-possible-to-copy-selective-data-from-sap-ecc-to-sap-s-4-hana-using-the-cdata-jdbc-driver/942 "2024-11-18T08:33:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ashish.pancholi](https://avatars.discourse-cdn.com/v4/letter/a/d6d6ee/32.png) [@ashish.pancholi](https://community.cdata.com/u/ashish.pancholi)\
**Post date:** [November 18, 2024, 8:34am UTC](https://community.cdata.com/t/is-it-possible-to-copy-selective-data-from-sap-ecc-to-sap-s-4-hana-using-the-cdata-jdbc-driver/942/1 "2024-11-18T08:34:16Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Ankit\_Singh](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ankit_singh/32/1614_2.png) [@Ankit\_Singh](https://community.cdata.com/u/Ankit_Singh)\
**Post date:** [November 18, 2024, 8:48am UTC](https://community.cdata.com/t/is-it-possible-to-copy-selective-data-from-sap-ecc-to-sap-s-4-hana-using-the-cdata-jdbc-driver/942/2 "2024-11-18T08:48:13Z")

</div>

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&nbsp;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](https://cdn.cdata.com/help/RYK/jdbc/pg_editionsandcontent.htm) for further details about what editions of SAP and content are supported.  
**NOTE:** &nbsp;This is a read-only driver and doesn’t support write-backs into SAP systems.

**2.) CData SAP Gateway JDBC Driver:**&nbsp;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.

---

<div class="post-metadata">

**Author:** ![ashish.pancholi](https://avatars.discourse-cdn.com/v4/letter/a/d6d6ee/32.png) [@ashish.pancholi](https://community.cdata.com/u/ashish.pancholi)\
**Post date:** [November 18, 2024, 8:54am UTC](https://community.cdata.com/t/is-it-possible-to-copy-selective-data-from-sap-ecc-to-sap-s-4-hana-using-the-cdata-jdbc-driver/942/3 "2024-11-18T08:54:39Z")

</div>

I appreciate ​ @Ankit_Singh &nbsp;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

​