How to do the reporting on SAP Commerce Cloud (CCv2)

[swapnildesai]

Having platform hosted on On-Prem gave the customers flexibility to create the DB replica (backup/restore) of Production instance and write the custom queries for heavy reporting requirements. With CCv2 in place, what are our options apart from OOTB Reporting Definitions which basically uses Backoffice and fires the flexible queries in production DB?

I am looking to avoid firing reporting queries on active prod DB instance as it will have an impact on storefront traffic.

Any inputs/pointers are highly appreciated.

[beastyisnt]

We worked with SAP and implemented their data migration process; see below in image. HAC has a new TAB for Migration. We have a Source (read only DB) and Target Database. Target DB is Via VPN. We implemented Hybris Cron jobs to sync the data we wanted. TO NOTE: That SAP of course does not support the bugs, because this is their tool they utilize to migrate our data from On Prem to CCv2.

[mansurarisoy]

It looks very similar what I suggest but your solution seems to be related with copying all the data within tables (because of the name migration 🙂 ). Does SAP provide this extension when requested? Or is it somewhere on the web as open-source?

[beastyisnt]

Mansur,

Out of the 1k tables, we only transfer only 90 tables to our internal Oracle Database. At Hybris, we have a One Full reSync (Tables with out a modified date field), which truncates and syncs the data. The rest day we have incremental syncs on the rest of the tables (5 times a day). FYI, what we are utilizing in code base.

import org.sap.commercemigration.MigrationStatus;
import org.sap.commercemigration.context.MigrationContext;
import org.sap.commercemigration.model.cron.FullMigrationCronJobModel;

During our Migration to CCv2, the BI Reporting database was a requirement. We worked with SAP to craft this out. You will need to talk to your SAP team to see if this is doable on your side.

Nope this is not "open-source", SAP Owns the code base.

[mansurarisoy]

We faced the same problem when migrating to CCV2 from On-prem. What we did was to create a custom extension which executes the query on Read-only replica and write the output into a new table on our On-prem SQL server which is connected via VPN.

You can use Read-only replica for heavy queries, it will not impact storefront or API services since it's not using main data source in Azure DB, but of course it has own usage limit, so it's possible to exhaust read-only replica with heavy queries. Be careful, in case of any high usage or blocking query on a read-only replica, you may need to create a ticket to SAP Support.

Hope this helps

[beastyisnt]

Nice!! We have another solution. See below.