RedshiftConnectionPool

Description:

Provides Amazon Redshift Connection Pooling Service with built-in JDBC driver. Connections can be requested from the pool and returned once they have been used.

Additional Details...

Tags:

redshift, aws, dbcp, jdbc, database, connection, pooling, store

Properties:

In the list below, the names of required properties appear in bold. Any other properties (not in bold) are considered optional. The table also indicates any default values, and whether a property supports the NiFi Expression Language.

Display NameAPI NameDefault ValueAllowable ValuesDescription
Database HostnameDatabase HostnameThe hostname of the database to connect.
Supports Expression Language: true (will be evaluated using variable registry only)
Database PortDatabase Port5439The port of the database to connect.
Supports Expression Language: true (will be evaluated using variable registry only)
Database NameDatabase NameThe name of the database to connect.
Supports Expression Language: true (will be evaluated using variable registry only)
Database UserDatabase UserDatabase user name
Supports Expression Language: true (will be evaluated using variable registry only)
Authentication TypeAuthentication TypePassword
  • Password Password authentication.
  • IAM IAM authentication.
Method used for Redshift authentication.
PasswordPasswordThe password for the database user
Sensitive Property: true
Supports Expression Language: true (will be evaluated using variable registry only)

This Property is only considered if the [Authentication Type] Property has a value of "Password".
AWS Credentials Provider ServiceAWS Credentials Provider ServiceController Service API:
AWSCredentialsProviderService
Implementations: AWSCredentialsProviderControllerService
AWSIDBrokerCloudCredentialsProviderControllerService
The Controller Service that is used to obtain AWS credentials provider. Assume Role is not supported.

This Property is only considered if the [Authentication Type] Property has a value of "IAM".
SSL Context ServiceSSL Context ServiceController Service API:
SSLContextService
Implementations: StandardRestrictedSSLContextService
StandardSSLContextService
If specified, indicates the SSL Context Service that is used to communicate with the remote server. SSL is enabled by default, if SSL Context Service is not set, the default system truststore is used.

State management:

This component does not store state.

Restricted:

This component is not restricted.

System Resource Considerations:

None specified.