on 06-10-2022 10:25 AM
Hello,
Is there a way of connecting SAP Business ByDesign to DWC? For example, can we connect directly to the underlying HANA DB or use the oData connection in DWC?
I know there is a dedicated connector for SAC: help.sap.com/SAC/...
But I cannot see anything from the level of DWC: help.sap.com/DWC/...
Nor from the open connectors: help.sap.com/OC/...
Thanks,
Sebastian
If there was anyone else looking for a way to connect, use the following setup in SAP byDesign:
SAP Business ByDesign / Retrieving Analytics Data Using OData / OData API for Data Sources
Once the setup is completed, the OData should work fine. Use automatically generated technical user credentials to authenticate.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sebastian,
we mostly use the already mentioned data source connector for your implementations.
Unfortunately, there is a strong limitation of performance and capabilities on SAP ByD side, hence it's quite hart to extract a larger amount of data in one request as well as handling some of the required filters (i.e. "specific date") via remote tables. Thus, I think it's still - but improvable - way to connect SAP DWC to SAP ByD.
However, since the data source API does not support already created KPIs within SAP ByD, you may also consider using the reporting APIs for some cases (like the SAC to SAP ByD connector is doing). While they are much slower in general, they might be a good fit, if only a selected part of the data shall be extracted and if there is already plenty of business/ reporting logic being implemented within SAP ByD.
Some more tips to improve this connectibity:
a) Consider creating your own data sources to reduce required data
b) Consider using DWC data flows in case of specific filter options
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you, Andreas. Very valuable tips. Could you please tell me what authentication method do you use to consume the OData of byDesign Reports instead of the Data Sources? Are you using the
https://<your system information>.sapbydesign.com/sap/byd/odata/<shortened name of work center>_analytics.svc/RP<report ID>QueryResults
for data extraction as explained in OData API for Reports?
As you comment, there is no native connector from DWC.
The SAC connector, actually uses odata, so you could get the same data using the oData connector from DWC. Plus with the new options for oData in the update (2022.12) it may be somewhat less "traumatic".
Looking in my crystal ball 🙂 ... a new integration with SAC has to come, which should allow sharing tables between SAC and DWC without the need to replicate data in the two systems.
The main usage scenario is planning, but I think it could also serve to use SAC models that have been created with the connections that are allowed in SAC and not in DWC. The bad thing is that I'm not 100% sure and I don't know when it will be available.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks, Xavier; I am trying the oData connection with the "traumatic" experience 😉
Hi Martijn,
They may share the HANA Cloud on which they reside and we may see them as different schemas, or DWC may see SAC as a HANA HDI. Let's hope it's the best possible and it comes soon 🙂
The important thing is that they have to take the integration of the two products to the next level.
User | Count |
---|---|
75 | |
8 | |
8 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.