Creating a JDBC data source using BIRT

After you have created the new report using BIRT, you must create a data source to connect the report to Unified Manager.

Before you begin

You must have created a report using BIRT.

You must have downloaded and installed MySQL Connector/J.

You must have created a database user with the Report Schema role.

Steps

  1. In Eclipse, select Data Explorer > Data Sources > New Data Source.
  2. Select Create from a data source type in the following list.
  3. Select JDBC Data Source, and then click Next.
  4. In the New JDBC Data Source Profile dialog box, select com.mysql.jdbc.Driver(v5.1).
    1. If the MySQL driver does not appear, click Manage Drivers.
    2. In the Manage JDBC Drivers dialog box, click Add.
    3. Browse to the location where the MySQL Connector/J .jar file was installed, and then select the file.
    4. Click OK.
      You should be able to view and select the MySQL driver.
  5. Enter the fully qualified host name or the IP address of the Unified Manager instance using appropriate format:
    Address Type Format
    IPv4 jdbc:mysql://xx.xx.xx.xx:3306/ocum_report
    IPv6 jdbc:mysql://address=(protocol=tcp)(host=xx:xx:xx:xx:xx:xx:xx:xx)(port=3306)/ocum_report
  6. Enter the user name for the database user, enter the password, and then click Finish.