Any guidance on using SAP Datasphere to replicate SAP OTC, PTP modules directly from S4HANA to GBQ cortex data foundation? Should the tables be exact replica in definition at Hana and target GBQ? Please advice
Hi @mohtalha, the models in Cortex Data Foundation assume the tables will have the same names and formats as in the source. Cortex is agnostic in terms of the replication tool and intently avoids dependencies on transformations or business logic in the source or the replication tool, so customers can choose the tool that works best for them. In other words, as long as the same types and names are there, the models will work, whether you use datasphere or a spreadsheet to move the data around. If you wanted to add more tables and have the CDC generator create the MERGE script for you, all you'd need to do is declare the table in the cdc_settings.yaml and the script will pick the definition up from dd03l. Then you'd need to add your own JOINs or SQLs in the reporting layer if you wanted the deployer to manage them too. I normally do not recommend replicating pre- aggregated models (e.g., ODP extractors or CDS views) unless they are mimicking raw tables and you have no other way. Does that help?
A lot has changed in a year, so we removed this video from the README. Hierarchies can now be flattened with a newly released set of scripts you'll find here: github.com/GoogleCloudPlatform/cortex-reporting/tree/b05a3345d55d5e196d8d636daf0c81541d0604e7/local_k9 The good thing about this new approach is it doesn't require configuration. If you want to learn exactly when this changed, I'd recommend going to the release notes. There's a new playlist that will be linked as soon as it's complete here, but maybe it helps: ua-cam.com/video/n1d654fkPjY/v-deo.html
@@LuciaSubatin Thank you. I was able to actually check the old tags. and project contents. There is reference to sets.yaml in the latest readme too. That was the confusion. I will go through your recommended document,
Hi Lucia, great information. Do you know if data replication can be accomplished for “SAP Business By Design” using Cloud Cortex? My understanding is that Odata is available.
Hi Lucia! Thanks for sharing this valuable video. I successfully deployed Cortex Framework with this this tutorial. However, I am going to deploy Cortex Framework 3.0 I would like to validate with you if the procedure is different. Are you planning to release the video for Cortex 3.0? Thanks you so much!
Hi Espartaco, thanks for watching. The procedure is the same, we keep the cloud build backwards compatible always. I would recommend taking a look at the readme to understand the new options and features introduced in 3.0 though. Good luck! 🦄
@@LuciaSubatin Thank you for your quick reply. I will follow your recommendation. On the other hand, Could I have deployed the previous Cortex Version and the Cortex 3.0 in the same project with the same BQ instance? I think so. But, I want to confirm with you if we could have multiple Cortex deployments on the same project.
@@espartacogonzalez7874 Yes, you can multiple deployments per project, just keep an eye on the names of the datasets so they don't overlap. If you are using our test data, I'd recommend deleting raw and CDC before deploying if using the same dataset between releases.
Thanks, Thorsten! You'll find the options in cloud.google.com/solutions/sap/docs/sap-data-integration-guides and a video about one of those options, the BigQuery Direct Connector, here: ua-cam.com/video/IPKcdJ-Xyyc/v-deo.html
Any guidance on using SAP Datasphere to replicate SAP OTC, PTP modules directly from S4HANA to GBQ cortex data foundation? Should the tables be exact replica in definition at Hana and target GBQ?
Please advice
Hi @mohtalha, the models in Cortex Data Foundation assume the tables will have the same names and formats as in the source. Cortex is agnostic in terms of the replication tool and intently avoids dependencies on transformations or business logic in the source or the replication tool, so customers can choose the tool that works best for them. In other words, as long as the same types and names are there, the models will work, whether you use datasphere or a spreadsheet to move the data around. If you wanted to add more tables and have the CDC generator create the MERGE script for you, all you'd need to do is declare the table in the cdc_settings.yaml and the script will pick the definition up from dd03l. Then you'd need to add your own JOINs or SQLs in the reporting layer if you wanted the deployer to manage them too. I normally do not recommend replicating pre- aggregated models (e.g., ODP extractors or CDS views) unless they are mimicking raw tables and you have no other way. Does that help?
In the new version of the github repo, I did not find the sets.yaml file. Has it been deprecated? What is the alternative?
A lot has changed in a year, so we removed this video from the README. Hierarchies can now be flattened with a newly released set of scripts you'll find here: github.com/GoogleCloudPlatform/cortex-reporting/tree/b05a3345d55d5e196d8d636daf0c81541d0604e7/local_k9
The good thing about this new approach is it doesn't require configuration. If you want to learn exactly when this changed, I'd recommend going to the release notes.
There's a new playlist that will be linked as soon as it's complete here, but maybe it helps: ua-cam.com/video/n1d654fkPjY/v-deo.html
@@LuciaSubatin Thank you. I was able to actually check the old tags. and project contents. There is reference to sets.yaml in the latest readme too. That was the confusion. I will go through your recommended document,
Hi Lucia, great information.
Do you know if data replication can be accomplished for “SAP Business By Design” using Cloud Cortex?
My understanding is that Odata is available.
Hi Lucia! Thanks for sharing this valuable video. I successfully deployed Cortex Framework with this this tutorial. However, I am going to deploy Cortex Framework 3.0 I would like to validate with you if the procedure is different. Are you planning to release the video for Cortex 3.0? Thanks you so much!
Hi Espartaco, thanks for watching. The procedure is the same, we keep the cloud build backwards compatible always. I would recommend taking a look at the readme to understand the new options and features introduced in 3.0 though. Good luck! 🦄
@@LuciaSubatin Thank you for your quick reply. I will follow your recommendation. On the other hand, Could I have deployed the previous Cortex Version and the Cortex 3.0 in the same project with the same BQ instance? I think so. But, I want to confirm with you if we could have multiple Cortex deployments on the same project.
@@espartacogonzalez7874 Yes, you can multiple deployments per project, just keep an eye on the names of the datasets so they don't overlap. If you are using our test data, I'd recommend deleting raw and CDC before deploying if using the same dataset between releases.
great video :) Do you have any pointers how to do the replication to BigQuery?
Thanks, Thorsten! You'll find the options in cloud.google.com/solutions/sap/docs/sap-data-integration-guides and a video about one of those options, the BigQuery Direct Connector, here: ua-cam.com/video/IPKcdJ-Xyyc/v-deo.html