How to Install Oracle BI Publisher for Development of Reports

This document is for Steelman Employees, Resellers and Customers. It is meant as a guild line for installing on your local server and connecting to your SEMS™ development database. Information provided in this document is proprietary reproduction of this information is required please contact info@esteelman.com ©Steelman Software Solutions Inc. 2010.

Oracle Business Intelligence Publisher Enterprise provides a single reporting environment to author, manage, and deliver all of your reports and business documents. Data models can be built against practically any data source from database to web service to file and more. Utilizing a set of familiar desktop tools, users can create and maintain their own report layouts based on data from these diverse sources. Reports can then be viewed on line or scheduled for delivery to a wide range of destinations.

Self help training is available at http://www.oracle.com/technology/products/xml-publisher/demoshelf/shelf.html

Step 1

First go to Oracle OTN and download the installation file for Oracle BI Publisher http://www.oracle.com/technology/software/products/publishing/index.html download windows version. For Steelman Employees the file is centrally located at I:\Oracle\Current\BI_Publisher\bipublisher_windows_x86_101341\Windows\Oracle_Business_Intelligence_Publisher_Standalone. Once you have downloaded the files extract it and run Setup.exe.

Select Oracle home.

Next

Select Basic.

Next

Enter your admin password this is for oc4jadmin very important don’t for get it!

Next

INSTALL

You should see this screen when the installation has completed successfully.

Exit installer.

STEP2

You know need to start the BI Publisher’s OCJ4 Service.

NOTE:

To access URL for developing reports is http://your.server.com:9704/xmlpserver

Default user name is Administrator with the same password.

STEP3

If you did everything right you should have a screen like this and be able to logon to the server

STEP4

Now you need to create the JDBC connector to your databases. After you logon click on the Admin tab at the top of the screen. You will see Data source click on JDBC Connection.

Click on Add Data Source

Now add your database connection information this should be the same as what you are used to for TNSNAMES. Plus you need to add the user in this case for non production it is DA.

Don’t for get to press test connection to make sure it works.

Press Apply settings.

NOTE: BI Publisher is a web based development tool and you need to press apply and save on various screens to save your work or changes.

Your connector should look like this now!

STEP5

File share and structure:

Oracle saves reports under the tree: C:\oracle\OraBiHome1\xmlp\XMLP I recommend sharing this directory so reports that are developed under a user can be moved to the production folder.

Production folder: C:\oracle\OraBiHome1\xmlp\XMLP\Reports

User development folder: C:\oracle\OraBiHome1\xmlp\XMLP\Users

Users need read and write rights to the directory to be able to move items to production.