Skip to Content
avatar image
Former Member

need to access that hana view in Oracle 11g

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 25, 2016 at 07:55 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 26, 2016 at 07:13 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded