Skip to Content
0
Former Member
Mar 26, 2018 at 04:49 PM

Accessing views in Oracle remote source

208 Views

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.