Hey Mahesh,
If the customer is interested in pulling data periodically or near real-time from S/4HC to send to Cognos so they can mash up with existing data in Cognos (from various sources) to build analytics report, the way to do this at the moment is using CDS View Replication technology in S/4HC. A couple of points to keep in mind with the S/4HC CDS View Replication app, they will need to subscribe to HANA Cloud/HaaS in SCP cause at the moment CDS View Repl. app can send data (from SAP standard/publicly released CDS Views in S4HC, no access to HANA DB tables as you already know) to HaaS (HANA2.0) and from there a customer could use SDI to replicate to Cognos or other BI/DW solutions they might have in the ecosystem.The second piece, CDS View Repl. app can only replicate CDS Views in S4HC that are publicly released and one cannot replicate custom CDS Views. And last point, CDS View Repl. is in maintenance mode and end of 2020 the strategy is to use newer replication technology in S4HC to send data out(more info on that to come in H1 2020).
Outside of CDS View Repl. app, you could also look at whitelisted APIs to replicate data out to Cognos (of the api fulfills the data export need) but then architecturally one needs to ask the question about how much data am I sending, how frequently am I sending, can the APIs handle the load if it is super large volumes w/ high frequencies, am I needing near real-time data replication, can my middleware integration flow handle change replication, error
handling and monitoring, stop and restart upon failure, maintenance of middleware logic etc...
Please ping me if you wanna discuss further.
Thanks.
Fabian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.