Select Page

Art of BI: Oracle BI + WebDAV

Christian Screen | | August 24, 2011

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

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018
code

Recover a Table from an RMAN Backup in an Oracle 12c

This blog post will is to show a table restore for one table in a container database

Megan Elphingstone | February 2, 2017

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS