Hana virtual table from oracle sql view

[former_member693168]

Hi to all.

I have a oracle remote source, which I used for create virtual tables on Hana Database, I already create several virtual tables from my oracle remote source, but now I create a view on my oracle remote source, and when I try create a virtual table on my Hana DB from the view on my oracle remote source the Hana DB doesn't see my view on oracle

So I want to know, can I create a virtual table from a view placed on oracle remote source? If yes, what must I do?

Thanks best guards.

[former_member693168 · Accepted solution]

The remote source database tables are not show on the HANA explorer, so if you need create a virtual table from a remote source view you must do it by HANA SQL manually as described on the SAP Note 3022390 - Create a virtual table on a remote database view - SAP HANA Smart Data Integration.

Bye.