RDBMS providers: AWS

Data Management's RDBMS tools can connect to AWS (Amazon Web Services) Aurora databases and Redshift data warehouse services.

Database name	Database API	Notes
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.

ODBC providers have been deprecated in Data Management and may not be supported in future versions.