OBIEE 11g and ODI 11g integration

Question

Dear Experts,

I am trying to integrate OBIEE 11g and ODI 11g by following the below url but not able to.

http://www.ateam-oracle.com/integrating-odi-with-obiee-how-to-invoke-odi-scenarios-load-plans-from-obiee/

I have deployed ODI as java web in epm environment and trying to use the WSDL in OBIEE configuration but got error.

Have anyone done integration before? Please share your ideas.

I need to trigger ODI scenario from OBIEE that my agenda.

Thanks,

Raja

Gianni Ceresa · Answer

Sorry, seeing you posted "checks" using localhost I thought it could be easy

Did you try looking into the Actions log file as the error tell? (I guess it is bi_server1-diagnostic.log)

Error in Action Framework configuration - please contact your system administrator and ask them to check the Actions log files for further information on how to correct this error.

RMDR · Answer

Dear @Gianni Ceresa,

I have used full domain name only in ear deployment. I used the same odiagant url in the ActionFrameworkConfig.xml.

Thanks

Gianni Ceresa · Answer

I didn't do that integration myself (never had the need for it), but based on the blog post I would say that in the WSIL you better use the full domain / IP of the ODI server and not localhost.

The blog post is based on ODI and OBIEE installed on the same server, so "localhost" works for reaching each other. In your case you have 2 distinct servers, so setup URLs by using the real domain / IP of your servers (for example if OBIEE try to call the ODI WSDL using the setting of your WSIL file it will try to get the WSDL from the OBIEE server (aka localhost for OBIEE) instead of the ODI server).

In the ActionFrameworkConfig.xml on the OBIEE server same thing, but you already set it right apparently (using "server 1" full domain).

So start by fixing all the URL using full domains / IP that both servers can resolve and reach and try again.