Skip to main content
OnCommand Unified Manager 9.5
A newer release of this product is available.

Creating a JDBC data source using BIRT

Contributors netapp-adityaw

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.