cancel
Showing results for 
Search instead for 
Did you mean: 

Data Replication between SAP Commerce Cloud and SQL

VijayBhaskaran
Explorer

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

Accepted Solutions (0)

Answers (2)

Answers (2)

andyfletcher
Active Contributor

I think that's what this project is for
https://github.com/SAP/sap-commerce-db-sync

I've not used it myself but it seems to be based on / inspired by the Commerce Migration Toolkit
https://github.com/SAP-samples/commerce-migration-toolkit

VijayBhaskaran
Explorer
0 Kudos

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
Product and Topic Expert
Product and Topic Expert
0 Kudos

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.