Skip to Content
0

need to access that hana view in Oracle 11g

Nov 25, 2016 at 06:09 AM

111

avatar image
Former Member

I have created a view in hana by joining 3 tables .. I need to access that hana view in Oracle 11g to delta update my master table in Oracle. so that data is fetched real time.

Can anyone suggest ? How to do this please

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

James Zhang
Nov 25, 2016 at 07:55 AM
0

Hi,

I think this is more or less needed to answered by hana team, because oracle does not have api for hana.

However if you are using sap system, please check whether dbco connection can help you.

Best regards,
James

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 26, 2016 at 07:13 AM
0

Hi James.. thanks for answering .

I figured out I can use ODBC technique.

I have one scenario where i need to read data real-time in Oracle from SAP Hana column store tables and update oracle 11g tables. Is there any performance impact : Real-time data is read from HANA column store tables in Oracle 11g ? due to compression or deduplication ? As compression ratio is much higher rate in columnar tables than row store.

Share
10 |10000 characters needed characters left characters exceeded