Hi,
Is anyone able to provide some pointers on the right way to integrate custom ODI with FDMEE (we are running 11.1.2.3.500)? I understand that with FDMEE's hard coded repository id's we are best to create our own ODI repositories for our custom processes but I am not sure how to best integrate an ODI Agent to run/schedule them.
For example, we want a custom ODI to orchestrate/perform the following flow:
1)Run FDMEE Metadata load (batch call)
2) Update Metadata Dimension attributes
3) Poplate FDMEE Open Interface
4) Run FDMEE Data Load (batch call)
If we create the above custom ODI repositories & process, what is the recommended approach for an Agent (schedule to run overnight)? We would like our Agent for this new ODI process to run on the same server as FDMEE (as we have some security constraints limiting access between servers and ODI process needs to run the FDMEE batch commands).
We have tried to import a custom Agent into the existing FDMEE WLS Domain but it corrupted the 'standard' FDMEE agent.
So my questions are...
Has anyone integrated a custom Agent with FDMEE install? Or should we be creating a new WLS domain for our Agent? Or do we need a full (new) ODI install? If so, can we do this on the same server as FDMEE?
If anyone has any pointers in this area it would be appreciated.
Thanks.