The good folks from the Oracle BI development team are still hard at work making Oracle BI ubiquitous to end-users.  I ran across one of the nicely hidden gems which is the updated OBIEE 11g Custom WebPart of Microsoft Sharepoint.  And, although my MCTS certifications for MSSS and MSSP  are still strong, I don’t have the time to test the implementation at the moment.  As you know, I had previously blogged about the OBIEE and Sharepoint integration and all of those integration points still hold true for Oracle BI 11g.

If you decide to implement this please let me know how it goes.  If I find the time, I’ll post back here in detail.

Download OBIEE 11g Sharepoint Custom Webpart

Resources:

• http://www.artofbi.com/index.php/2009/09/integrating-sharepoint-with-obiee/
• http://www.oracle.com/technetwork/indexes/samplecode/bi-sample-522115.html

Integrating Oracle BI with other technologies is always an interesting topic.  One such integration is taking Oracle BI components and/or output, mainly output, and integrating it with WebDav.  Typically the questions comes across as, “Can we integrate Oracle BI and Sharepoint?”  Though I answered that question in detail on this post two years ago (wow, really two years ago? How time goes by when you are having fun!), many people are still attempting the integration.  I basically recommend the WebDav option depending on a client’s requirements and even with that recommendation, team typically don’t understand how to either conduct the integration or test the integration in Sandbox environment.

So, this post won’t give you a step-by-step (I’ll save that when I actually have time…hmm…), but it will point you in the right direction on how to conduct the integration and test it in a sandbox/laptop environment.  First, with Oracle BI (Not BI Publisher) you will ultimately need to write some Java Code.  You can create a custom Java Job to be run in the Oracle BI Job Manager (Good for Oracle BI 10g and 11g) or you will need to create an Enterprise Java Bean (EJB) and deploy that to the WLS server to leverage Java code via the Oracle BI 11g Action Framework.

The Java code you write should implement a very brilliant Java/WebDav library called, Sardine.  This is the brain-child of Jon Scott Stevens and Sardine is Open-Source code (hosted on Google) that you can easily implement in your Java coding.

The next thing you will need to test implement your code and movement of objects to a WebDav server is a WebDAV server.  But what if you don’t have dev/test environment at your company or they won’t let give you access to it.  We’ll you’ll need to go get your own to run on your local environment.  The fastest and easiest way to do that is to use a project from none other than the Apache Foundation called JackRabbit.  JackRabbit is a standalone WebDAV server that starts as basically a singleton server instance under a Java Virtual Machine.  Instructions and step-by-step startup procedures are listed on the JackRabbit site.

Now all together you should have a Java IDE, Oracle BI 11g, JackRabbit, and Sardine.  Write some custom Java Code (you are on your own for now) and you’ll have a fully functioning Oracle BI + WebDAV implementation ready to dev, test, and demo.

Best of Luck!

References:

http://jackrabbit.apache.org/

http://jackrabbit.apache.org/standalone-server.html

A colleague of mine is huge on Microsoft SharePoint (MOSS) and with good reason; It is Microsoft’s #2 best sold licensed software product behind Microsoft Office. It is a collaboration tool, a CMS, a document repository, and now with PeformancePoint 2007 rolled into the suite is will be an analytical tool. And, since quite a few organizations that have implemented SharePoint use it as their launchpad portal for all things internal (intranet) it only makes since to be able to integrate SharePoint with more powerful heterogeneous analytical tools like OBIEE. But the big question I have heard over the last few months is, “What is the best approach to integrating OBIEE into SharePoint?”.  In this blog post I will point you to a White Paper on the subject and some integration code you can use to get started with your integration.

Ultimately we need to look at the limitations of communicating with OBIEE as I describe below.
Read the full story