How to import data from Oracle view

michel7michel7 Member Posts: 26 Maven
edited March 2022 in Help
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

Best Answer

  • michel7michel7 Member Posts: 26 Maven
    Solution Accepted
    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

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn
    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
Sign In or Register to comment.