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
701

Hi Experts,

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

Best Regards,

 

 

View Entire Topic
Simon_Ye
Product and Topic Expert
Product and Topic Expert
0 Kudos
You can create a connection to Oracal DB in Datasphere, then use replication flow to copy the data to Oracle DB.
Marvin_Sanjaya
Discoverer
0 Kudos

oracle1.pngoracle2.pngHi 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
Active Contributor
0 Kudos

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.