RDBMS providers: AWS

Aurora MySQL

JDBC

MySQL 5.7. Can be used with AWS Identity and Access Management (IAM) by configuring these options:

• UseAwsIAM: if true, indicates that AWS IAM tokens should be used for this connection.

  • Default is false.

• AwsRegion: AWS Region name.

• AwsAccessKeyId: AWS Access Key for IAM user.

• AwsSecretKey: AWS Secret Key for IAM user.

Aurora PostgreSQL

JDBC

N/A

Aurora PostgreSQL Bulk loader

JDBC

N/A

AWS Redshift

ODBC native

The AWS Redshift JDBC and ODBC drivers are adequate for inserting small amounts of data into tables with fewer than 50 columns, but they are slow.

AWS Redshift

JDBC

Defaults to operating in SSL mode, which may cause connection failures on systems not configured for SSL. If this happens, do one of the following:

• Disable SSL by adding a parameter named ssl to your data connection, and setting its value to false.

• Leave SSL enabled, but disable validation by adding a parameter named sslfactory to your data connection, and setting its value to org.postgresql.ssl.NonValidatingFactory.

AWS Redshift Bulk

JDBC

Use with RDBMS Output tool for bulk inserts of an input record stream into a Amazon Redshift Database table. If you specify this provider, you may optionally configure additional properties.