cancel
Showing results for 
Search instead for 
Did you mean: 

How to export data from SAP Datasphere or its database (SAP HANA Cloud) to Oracle DBMS

Marvin_Sanjaya
Discoverer
0 Kudos

Hi Experts,

How to export data from SAP Datasphere or its database (SAP HANA Cloud) to Oracle DBMS

Best Regards,

 

 

View Entire Topic
ssurampally
Active Contributor

Datasphere OData service API can be used to get the data from analytical models/views in Dataphere. How to access it and different parameters and endpoints of the API explained in the sap help link below. 

https://help.sap.com/docs/SAP_DATASPHERE/43509d67b8b84e66a30851e832f66911/7a453609c8694b029493e7d87e...

You can use any integration tool, and call this API and get the response and write the data into your target Oracle DB table.  Example API call.

https://<tenant_url>/api/v1/dwc/consumption/analytical/<space_id>/<asset_id>/<asset_id>[<params>]

 

Marvin_Sanjaya
Discoverer
0 Kudos

Hi Ssurampaly, thanks for your reply, but our requirement is to export the data from SAP Datasphere to other DBMS (oracle in this case), not to import or consume data.