Creating a new MySQL data set using BIRT

After creating the data source, you must create a MySQL data set to create the output results for your report. You can also edit the output types after creating the data set.

Before you begin

You must have created a JDBC data source using BIRT.

You must have downloaded and installed MySQL Connector/J.

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

Steps

  1. From Eclipse, select a workspace.
  2. Select Data Explorer > Data Sets > New Data Set.
  3. In the New Data Set dialog box, select the data source previously created, the data set type, and the data set name, and click Next.
  4. Define an SQL query text using the available items, or manually enter the query, and click Finish.
  5. Click Preview Results to confirm the SQL query, and then click OK.
  6. In the Edit Data Set dialog box, define the output columns as necessary and click OK.
  7. Drag items into the newly created report.

After you finish

You should now import the newly created report into Unified Manager.