Could FIM job have a Oracle view as a source or only a table?

[former_member249606]

Hello,

Could FIM job have a Oracle view when using Oracle datastore as a source or only a table?

Thank you,

Ayoub

[Marc_Kuipers · Accepted solution]

Hi Ayoub,

Yes, this should work

The documentation is a little misleading

https://help.sap.com/viewer/3b4cdc77c1464529a1b8d8add2fc6bc7/10.0.15/en-US/f9ddab816faf1014878bae8cb...

1. On the Source page, select datastore that corresponds to the source data.

2. In the Table box, select the table that you want to use as the source of data.

3. Click Next.

I just tested it in SQL server, and Oracle will behave the same

1. Create view

CREATE VIEW SAP_VIEW

AS

SELECT * FROM fc.dbo.ct_account where name like 'A%'

2. In FIM, select the table

The documentation should really say table/view

Marc

[former_member249606 · Accepted solution]

Thanks Marc

[pierre_bournaveas]

Dear Ayoub,

It should work normaly as the query generated in FIM to retrieve the Oracle datastores during the creation of the job is:

select TABLE_NAME from USER_TABLES UNION SELECT VIEW_NAME FROM USER_VIEWS ORDER BY TABLE_NAME

Regards,

Pierre

[former_member249606]

Thanks Pierre