Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

How to import data from Oracle view

Hi,

i want to import data from Oracle view. I see only tables in the list, no views.

Is it possible at all to import data from a view ? If so, how to do it ?

Thanks,

Michel

Find more posts tagged with

AI Studio

Accepted answers

michel7

Hi Balazs,

I have overlooked the input field for sql script - thanks for the hint ! I'm using the operator Read Database.

Warm regrads,

Michel

All comments

BalazsBaranyRM

Hi!

It seems that the detection of views is not correct for Oracle, at least not in your Studio. It works correctly for me in other database types (no Oracle to test).

However, you can always specify the view name and read from it if you have the access permissions.

Which operator are you trying to use? Read Database? The In-Database extension?

Regards,
Balázs

michel7

Hi Balazs,

I have overlooked the input field for sql script - thanks for the hint ! I'm using the operator Read Database.

Warm regrads,

Michel