I would like to share some information regarding FDMEE integration with SAP HANA, S/4HANA and HANA Cloud – General Guidelines
In cloud Data management SAP HANA, S/4HANA and HANA Cloud it is not supported.
In FDMEE we can connect to SAP HANA, S/4HANA and HANA Cloud using UDA.
- The UDA feature allows you to register a table or view in on-premises FDMEE, and you must select one of the technologies in ODI as the basis for the table or view.
- So for on-premises SAP this should work for the UDA, but not for cloud.
- For cloud, you will need to connect to the SAP cloud instance via one of their APIs which you should be able to call from the cloud.
Is there any other method in FDMEE other than using UDA to connect to SAP HANA, S/4HANA and HANA Cloud ?
- UDA does not connect to the cloud, but you can connect to a cloud instance by calling the SAP API from a script in FDMEE.
Can we push data directly into EPBCS Cloud from SAP HANA / SAP HANA Cloud. Is it possible to achieve this using REST API’s?
- You will need to call the SAP API and then the EPM REST API/EPM Automate for this.
- You can choose any tool you want to orchestrate the APIs
Regarding the integration there is a Blog which explains the Integration which includes the setup made in ODI and FDMEE
https://fisingmania23.blogspot.com/2017/05/universal-data-adapter-for-sap-hana.html
With on-premise FDMEE, we should be able to call an API on the SAP side to pull the data we need.
Here are a number of useful links from SAP
- https://www.sap.com/developer/topics/api.html
- https://api.sap.com/package/SAPS4HANACloud?section=Artifacts
- In the list of APIs, the following looks like it gives you the trial balance for a ledger: https://api.sap.com/api/C_TRIALBALANCE_CDS/resource
To do this, the customer will need an SAP resource that knows how to call the required API, and the API that will provide what we are looking for.
No comments:
Post a Comment