Connect MySql DB to SAC Planning to extract data

[vshrika]

Hi Team,

What are all the options available to connect MySQL database to extract and retract data from/to SACP

MySql (ECC)--> SAC Planning and

SAC Planning ---> Mysql (ECC)

Your suggestion will be highly helpful

[William_Yu]

With setup of Cloud connector and Cloud agent with JDBC adapter, SAC can import from MySQL DB via import connection. Please refer to help page here: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/0d5ffbb6951b45778c1a9... But import and export can be achieved via external application by calling the import and export API of SAC:

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/14cac91febef464dbb1efce20e3f1613/fe6efb8aba9444c6a3ce2...

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/14cac91febef464dbb1efce20e3f1613/db62fd76514b48f8b71d6...