Data Replication between SAP Commerce Cloud and SQL

[VijayBhaskaran]

Dear experts,

I'm wondering to know whether possible to replicate whole tables from SAP Commerce Cloud to SQL with delta configurations for future data load purposes.

Does anyone knows the architecture to connect both solutions?

I appreciate any comment to move forward.

Thanks in advance,

Vijay Bhaskaran

[VijayBhaskaran]

Hi Andrew,

Thanks for that. I've gone through this repository, and it gives the migration details only from on-premise Commerce to Commerce cloud. There is no detail steps/instructions to migrate/replicate the tables from Commerce to External SQL server.

[joris_quenee]

Hi Vijay B.

You should use this following guide https://github.com/SAP/sap-commerce-db-sync/blob/main/docs/user/USER-GUIDE-DATA-REPLICATION.md

From Commerce Cloud, you can use two different cronjob FullMigrationCronJob and IncrementalMigrationCronJob. You just have to make sure source database is Commerce Cloud instance and target database is your external SQL server. Of course, you're both databases should have exactly the same database schema.