Back
 

How to configure MySQL database connectivity in BI Publisher?

iWare Logic > Blog  > How to configure MySQL database connectivity in BI Publisher?

How to configure MySQL database connectivity in BI Publisher?

How to configure MySQL database connectivity in BI Publisher?

Introduction
This article describes the required tasks to be performed to configure MySQL database after the successful installation of the BI Publisher server into an OC4J instance.
The points covered in this article include:

  • Preconfigured Settings
  • Configure the JDBC demo data source for MySQL



Preconfigured Settings

Prerequisite:
You must download the MySQL JDBC driver and register it with the application server where BI Publisher is running.
The MySQL JDBC driver can be downloaded from: http://www.mysql.com/products/connector/j/

How to register MySQL JDBC driver with oc4j?

•    Copy MySQL JDBC driver (mysql-connector-java-5.1.1.jar) file to
<BI-HOME>/oc4j_bi/j2ee/home/lib
(Different versions compatible .jar files available on net)
•    Add the <library path> entry of MySQL JDBC driver file in application.xml located at <BI-HOME>/oc4j_bi/j2ee/home/Config/application.xml

application.xml
<?xml version=”1.0″ standalone=’yes’?>
|
|
|
|
<! — Scheduler supporting classes –>
<library path=”../../home/lib/scheduler.jar” />
<library path=”../../home/lib/mysql-connector-java-5.1.1.jar” />
|
|
For application/web server rather than oc4j, see your application server documentation for information on registering the driver.

Configuring the JDBC Demo data source of MySQL

1, my SQL1. Log in to BI Publisher with Administrator credentials and select the Admin tab.

2, my sql2.  Under Data Sources, select JDBC Connection.

3 my sql3.    Click on Add Data Source

4.    Enter the following fields for the Database Connection:

  • Data Source Name – enter the Data Source Name, which is used in your Publisher report under Data Model section as Data Source.
  • Connection String – enter the connection string for your selected database. Sample strings are provided in the database-specific sections that follow.
  • Username and Password – enter the scheduler user you set up for your database. The user must have permissions to connect to the database and create tables. Other permissions may be required depending on your database type. Please see the appropriate database-specific section below.
  • Database Driver Class – when you select the database type this field is automatically updated with the recommended driver. If you wish to use another driver, specify it in this field.

5.    Click Test Connection to ensure that BI Publisher can connect to the database. If the connection fails, ensure that you have entered the fields as shown and set up your database appropriately.

4 my sql

I hope, this article will give you idea of MySQL or any other database connectivity with Oracle BI Publisher.

Mahesh Jadhav

Know more about BI Publisher Reports

Share