Skip to Content
avatar image
Former Member

SAP ECC 6.0 to External mySQL

Mar 15, 2017 at 09:46 AM | 79 Views

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Dirk Venken
    Mar 15, 2017 at 10:06 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.