Skip to Content
avatar image
Former Member

Accessing views in Oracle remote source

Hello:

We are trying to access views in Oracle remote source to create SDI extractors to bring data from Oracle into HANA.

After connection has been established we are unable to see the views in Oracle from HANA. We are able to see the tables in Oracle.

Is there a way to access views created in Oracle? Accessing tables directly in target databases is not a best practice traditionally. Is there a change in the approach? Can anyone please shed some light on this topic.

Appreciate it.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 18 at 04:12 PM

    Hi Murugan,

    Same curiosity here...Have you found something about Accessing database views thru oracle DB into HDB?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 11 at 03:44 PM

    Hi Murugan,

    I am looking for this information as well. Did you find out anything about this ?

    I came across this post : https://answers.sap.com/questions/486298/hana-sdi-accessing-database-view-from-oracle-db-in.html

    Check out the solution. Have you tried implementing this ?

    Add comment
    10|10000 characters needed characters exceeded