How oracle views can be extract in data services

[Former Member]

Hi all

     i have client and they have requirement of extract oracle views in bods can anyone suggest me how to do it or extract it from oracle to DS

[former_member213365]

I'm not sure what you mean.  Do you want to have a view in your Datastore?  If so, that is very easy.  Just import the view into your Datastore just like you do a table.  As far as Data Services knows, it is a table.  Inserting into it will be possible only if you set up the triggers on the view to allow for that.

[Former Member]

Hi Jim

     Yes you got my question can you please suggest me how to import view like table because i done it but i can not achieve appropriate output can you please help me  

[former_member187605]

Oracle allows you to insert data into the underlying table through a view without any further measures, when the insert columns are limited to columns of a single underlying table.

[former_member213365]

What type of view are you working with?  Is this a simple view, a multi-table view or perhaps you have a materialized view?

[former_member213365]

I deal with views so infrequently that I had forgotten about that.  Thanks for the reminder.

[Former Member]

Hi Jim,

     I am working with multi-table view can you help that

Thanks for your valuable replies

[Former Member]

Hi Dirk,

     Can you help me to create multiple table view

[former_member187605]

Why don't you check the official Oracle documentation (CREATE VIEW)? There are several examples at the bottom of that page.

[Former Member]

Hi Dirk,

    I got my solution how to go for view in ETL thanks for help.

[former_member226568]

It would be nice if you can put the solution.

In that way it will be helpful for others.