Skip to Content
0

Accessing views in Oracle remote source

Mar 26 at 04:49 PM

43

avatar image
Former Member

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.

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

2 Answers

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

Hi Murugan,

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 11 at 03:44 PM
0

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 ?

Share
10 |10000 characters needed characters left characters exceeded