How to import data from Oracle view

michel7
michel7 New Altair Community Member
edited November 5 in Community Q&A
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

Tagged:

Best Answer

  • michel7
    michel7 New Altair Community Member
    Answer ✓
    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

Answers

  • BalazsBarany
    BalazsBarany New Altair Community Member
    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
    michel7 New Altair Community Member
    Answer ✓
    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

Categories