Previous Page Next Page

Example 10: Via RedShift

Assume that:

For details about how to install RedShift, refer to http://docs.aws.amazon.com/redshift/latest/dg/c_intro_to_admin.html.

Take the following steps to set up a connection which connects JReport Designer to a database via RedShift:

  1. Start JReport Designer and open the catalog.
  2. In the Catalog Manager, right-click the node of the default data source and select New JDBC Connection from the shortcut menu. Click JDBC in the Select Connection Type dialog.
  3. In the Get JDBC Connection Information dialog, enter the JDBC driver class name org.postgresql.Driver in the Driver text field.
  4. In the URL text field, specify the URL as jdbc:postgresql://jinfonet-rsdw-demo.cfcn5ogc14yr.us-east-1.redshift.amazonaws.com:5439/sampledb.
  5. Input the user name dbadmin and password test1234 respectively.

    Get JDBC Connection Information dialog

  6. Click OK to set up the connection.

Notes:

Previous Page Next Page