Before you begin

Pentaho Data Integration
Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-15

Before using the Bulk load into Amazon Redshift entry in PDI, you must perform the following steps to download the Redshift driver and copy into the Pentaho distribution:

  1. Download the latest JDBC 4.0 driver from the Download the Amazon Redshift JDBC Driver site.
  2. Copy the downloaded JAR file into the server/pentaho-server/tomcat/lib directory to update the Pentaho Server.
  3. Copy the downloaded JAR file into the design-tools/data-integration/lib directory to update PDI.
  4. Verify that your cluster is configured to support the COPY command.
    See Credentials and Access Permissions for more details.
You can now use the Bulk load into Amazon Redshift entry in your PDI jobs.