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

[Marvin_Sanjaya]

Hi Experts,

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

Best Regards,

[Simon_Ye · Accepted solution]

You can create a connection to Oracal DB in Datasphere, then use replication flow to copy the data to Oracle DB.

[Marvin_Sanjaya · Accepted solution]

Hi Simon, can you share the detail (link of the article) that we can review for this approach?
from what we understand, now connection in oracle only as source in SAP Datasphere

[ssurampally · Accepted solution]

Hi, Replication flows target applications are limited, you can find your application supported as target or not in the help document link below. I see Oracle is not supported there. But Simon can confirm on this. 

https://help.sap.com/docs/SAP_DATASPHERE/be5967d099974c69b77f4549425ca4c0/eb85e157ab654152bd68a87140...

You can also go through the replication flows supported targets with detailed steps in this blog series.  Azure, Google, Kafka, Confluent etc..  It is additional charge for using it.

https://community.sap.com/t5/technology-blogs-by-sap/replication-flow-blog-series-part-2-premium-out...

If your trying to export data of Datasphere tables or views, you can call the APIs and process the data to the target. 

[ssurampally]

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]

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.

[S_Sriram]

Hi Sanjay

Have you checked this SAP blog about the connectivity from the SAP cloud to Oracle DB.

https://community.sap.com/t5/technology-blogs-by-members/connecting-sap-cloud-platform-with-an-on-pr...

Regards

SS

[Marvin_Sanjaya]

Hi Sriram, I have read the article..

i think the article objective is "how to connect SAP Cloud Platform to an on-premise JDBC databases we will show you, how to consume data from a JDBC-database (Oracle, in our case)"
while in my case is not to consume, but to export data to oracle..

do you have other reference for this requirement (SAP datasphere export data to oracle)

Thanks.