on 11-09-2017 6:38 PM
Hello,
Could FIM job have a Oracle view when using Oracle datastore as a source or only a table?
Thank you,
Ayoub
Hi Ayoub,
Yes, this should work
The documentation is a little misleading
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.