Example 10: Via RedShift
This topic introduces how to set up a JDBC Connection via RedShift.
Assume that:
- You have already installed the PostgreSQL JDBC driver, and have appended the archive files of the driver to the ADDCLASSPATH variable in the file setenv.bat in
<designer_install_root>\bin
. - The RedShift database server is with the following information:
Driver: org.postgresql.Driver
URL: jdbc:postgresql://jinfonet-rsdw-demo.cfcn5ogc14yr.us-east-1.redshift.amazonaws.com:5439/sampledb (The URL is dynamically generated when you apply an instance.)
User: dbadmin
Password: test1234 - A catalog has been created with a default data source.
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 Logi JReport Designer to a database via RedShift:
- Start Logi JReport Designer and open the catalog.
- In the Catalog Manager, right-click the node of the default data source and select New JDBC Connection from the shortcut menu. Select JDBC in the Select Connection Type dialog.
- In the Get JDBC Connection Information dialog, enter the JDBC driver class name org.postgresql.Driver in the Driver text field.
- In the URL text field, specify the URL as jdbc:postgresql://jinfonet-rsdw-demo.cfcn5ogc14yr.us-east-1.redshift.amazonaws.com:5439/sampledb.
- Input the user name dbadmin and password test1234 respectively.
- Select OK to set up the connection.
Notes:
- Redshift does not support the "Double" data type and it uses "Decimal" or "Double Precision" instead.
- Redshift does not support "Bytea", "Bit(N)" or "Bit varying (N)" data type, and so far there is no alternative data type for that, therefore Logi JReport binary data fields like photos stored in the demo database cannot be imported to Redshift.
- For detailed features, functions, and data types that are not supported in Redshift, see http://docs.aws.amazon.com/redshift/latest/dg/c_redshift-and-postgres-sql.html.