Skip to Content
avatar image
Former Member

hana sdi: Accessing database view from Oracle DB into HDB

Hi,

While creating Flowgraph/replication task...Is it possible to access database views as a data source thru oracle DB into HDB??

Thank you in advance!!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 23 at 04:33 PM

    Hi Suresh,

    You should be able to locate Oracle views under HANA Catalog > Provisioning > Remote Sources > your Oracle Remote source > Oracle schema.

    Then you can right click on the View name, and create a Virtual Table on that view in a specified HANA schema. When you are defining your flowgraph or rep task, select this Virtual Table as the source, and it will read the data from the Oracle view.

    Best regards,
    Jeff K

    Add comment
    10|10000 characters needed characters exceeded