3.4 Configuring Your JDBC Connection in Jaspersoft Studio

Before customizing your report, you need to configure a new datasource for the reporting PostgreSQL database within Jaspersoft Studio. You only need to perform this step once.

  1. Launch Jaspersoft Studio, if you have not done so already.

  2. Click the Repository Explorer button on the main toolbar to open the Connections/Datasources dialog box.

  3. Right-click on Data Adapters and select Create Data Adapter.

  4. Select Database JDBC Connection and click Next to advance to the Database JDBC connection page.

  5. Configure the PostgreSQL JDBC connection:

    1. Select the PostgreSQL (org.postgresql.Driver) JDBC driver.

    2. Specify the database URL to your database (jjdbc:postgresql://localhost:5432/REPORTING_DB_NAME).

    3. Supply your database username and password.

      NOTE:Specify the database username and password you use for your PostgreSQL database.

    4. Click the Test button to test your database connection.

    5. Click OK to close the message box.

    6. Save the database connection information.

  6. Close the JDBC configuration dialog box.