Skip to Content
0

SAP ECC 6.0 to External mySQL

Mar 15, 2017 at 09:46 AM

57

avatar image
Hemamalini Madhu

I would like to connect my SAP ECC 6.0 Release 702 system to external mySQL database. What are the best ways and basic requirements/steps to connect?

SAP Data Integrator
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
avatar image
Dirk Venken Answered
Mar 15, 2017 at 10:06 AM
0

See https://blogs.sap.com/2017/03/13/extracting-data-from-sap-ecc/ for details on how to get dat out of ECC.
For your target database, simply create a data store withthe right connection settings.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Hemamalini Madhu
Mar 15, 2017 at 10:23 AM

I have to extract data from external mySQL database to SAP.

0
Dirk Venken
Mar 16, 2017 at 08:26 AM
For writing into ECC, you only have 2 options: IDOCs and functions.

In general, it's not supported to write straight into the SAP tables, though this can safely be done for Z-tables. In that case you have to create a 2nd data store definition on the SAP database.

0
Comment