Sharepoint Integration

[Brian]

Greetings all.

We have just rolled out our first set of dashboards and analytics with
OBIEE and are now being asked to present them through a Sharepoint
portal. Has anyone had any experience integrating OBIEE with
Sharepoint? Any "lessons learned" that you are willing to share?

Thanks in advance for your replies.

Brian.....

[Kris]

Hi Brian,

I don't know if you managed to found how to do it but for the few I
understood if it can help you here it is.

Note that we have two distinct requirements :
1) bipublisher & obiee reports or dashboard publication inside moss
items list
The webdav method, as the prequisites were to change moss
configuration, basic auth + digest if i remember, moss architect asked
us to find another way for security purposes. The IT architect as well
asked us for all ouputs to use the EAI as it is monitored. So we went
to the easiest way doing some local exports and the EAI is in charge
of the flows. Quite dirty and heavy but it works... In reality, if
there were another way to achieve it that doesn't need to change moss
security itselft it should be better.

2) obiee reports included inside a moss page, your requirement i guess
Easiest way : embedded obiee contents inside an iframe with the goURL
method ( <- note if used directly inside an HTML page, system account
credentials will be displayed in the html source. Using the
siebel=syndicate option, only the dashboard content can be displayed

The best pratice should be to work with web services. For test, oracle
delivered a MOSS webpart including the method was available, i can't
manage to find the link in the Oracle website now. For this case, we
were using a system account, so security access was managed by MOSS
and assuming all users could share the same point of view.
Using the webpart we managed to display some reports. We encountered
some issues like drill-down and action link unvalaible but for the
basics it worked.

2bis) Some of our reports / dashboards include data restriction
regarding the data visibility of each users.
We didn't work yet on this requirement but i guess SSO should be
implemented to automatically recognize user.

few links about this :
- http://www.artofbi.com/index.php/2011/11/obiee-sharepoint-webpart/
- http://oraclebizint.wordpress.com/2007/07/31/customizing-obi-ee-soap-api/

If you can not find the webpart just send me a mail

Regards,
Kris

[Steven Landry]

Hi Brian,

OBIEE has functionality that is useful for embedding by using the
Portal:

See the Integrator's Guide for more info:
http://docs.oracle.com/cd/E21764_01/bi.1111/e16364/apiwebintegrate.htm#i1005204

By using a URL like this: the header and footer of OBIEE won't show.

http://localhost:8080/analytics/saw.dll?PortalPages&PortalPath=%2fshared%2fdashboardfolder1%2f_portal%2fdefault&Page=page%202&Done=close

Hopefully you will have some type of SSO in place so the user won't be
prompted for credentials.

Steve