I have attached a link to the step by step instructions at the end of this post on how to integrate SOAP WSDL from ODI to OBIEE so you can start ibots or do various other tasks within OBIEE from ODI without the need of a dedicated ODI agent on the OBIEE Server. This solution was developed in 12c.
Business Case
One
of our customers wanted OBIEE reports to be mailed after the completion of a
data load in ODI. We know there are different methods of achieving this. But we
did not want to deploy an ODI Agent onto the OBIEE Server in the Corporate
Environment.
That
is the need and here is the solution we came up with – Using WSDL & SOAP
approach to build bridge between the two most popular Oracle technologies in
Data Warehousing world.
Solution Technology
We
used the two following technologies that are made available as part of ODI and
OBIEE while building the solution
WSDL
(Web Service Definition Language) is often used in combination with SOAP
and an XML Schema to provide Web services over the Internet. A client program
connecting to a Web service can read the WSDL file to determine what
operations are available on the server. Any special datatypes used are embedded
in the WSDL file in the form of XML Schema.
SOAP (Simple
Object Access Protocol) is a protocol specification for exchanging
structured information in the implementation of web services in computer networks.
It uses XML Information Set for its message format, and
relies on application layer protocols, most often Hypertext Transfer
Protocol (HTTP)
or Simple Mail Transfer
Protocol (SMTP),
for message negotiation and transmission
Solution
Overview
The
solution enables us from ODI to remotely login to OBIEE and initiate an iBot
and log out. Following are the high level steps
1. Use OdiInvokeWebService to login to
OBIEE with SOAPImplementation URL
2. The above call creates a response file
with the OBIEE Session Id
3. Use a Simple mapping to move this file
content into a database table
4. Create a variable with sub string and
in string operations to extract the OBIEE session id
5. Use OdiInvokeWebService to initiate an
iBot with the above session id and iBot name to mail the required report to
recipients
6. Use OdiInvokeWebService with the same
session id to log off from OBIEE
We
have created an ODI package to orchestrate the above steps which executes the
above steps in a seamless chain.
Download The Full Document here from the DeliverBI Box Location
Click Here to Download Step by Step instructions
Cheers
Shahed M
1 comments:
Write commentsI think Power BI and its combination with Oracle and some other database operating platform can surely help in cracking some complex IT solutions.
ReplyPowerbi Read Soap
Note: only a member of this blog may post a comment.