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.
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
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
Regards
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers