The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

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, 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
Sign In or Register to comment.