Skip to Content
0

hana sdi: Accessing database view from Oracle DB into HDB

Apr 18 at 04:13 PM

82

avatar image
Former Member

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!!!

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

1 Answer

Jeff Kresse
Apr 23 at 04:33 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded