CODEWITHSUNDEEP
sqldatabasearchitecturesap
Martin Golpashin
Martin Golpashin

Reputation: 1062

Connecting external SAP database to MySQL

My application relies on data that is stored in a SAP Database. In addition to that, I need to persist data that references the SAP data but cannot be stored in the SAP database. So there is another (MySQL) database.

What would be the cleanest way to connect those 2 datasources?

I think it would be better/safer to constantly get the data I need from SAP and also store it in the MySQL database, since I can reference them with FKs. But I do not want to always check for changes in the SAP database and then copy all the data to MySQL since queries to SAP are usually very expensive.

Upvotes: 0

Views: 1535

Answers (0)

Related Questions