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.
Procedure
- In Eclipse, select .
- Select Create from a data source type in the following list.
- Select JDBC Data Source, and then click Next.
- In the New JDBC Data Source Profile dialog box, select com.mysql.jdbc.Driver(v5.1).
- If the MySQL driver does not appear, click Manage Drivers.
- In the Manage JDBC Drivers dialog box, click Add.
- Browse to the location where the MySQL Connector/J .jar file was installed, and then select the file.
- Click OK.
You should be able to view and select the MySQL driver.
- 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 |
- Enter the user name for the database user, enter the password, and then click Finish.