You can configure a new Redshift account in Fast Data Loader (FDL) by using the user credentials from your existing account in Redshift.
Login credentials and access to Redshift account. Contact your administrator, if you do not have access or settings details. For more information on the Redshift account configuration, see Redshift documentation.
The Fast Data Loader is tested against Redshift 8 and may be compatible with later versions.
Create new connection tag
Required. Enter a name that will help identify your Oracle account in FDL.
Required. Enter the server address to establish a connection.
Required. Enter the database server's port number to which the application must connect.
Required. The database name to which the application must connect.
Required. Enter the username that you have configured for your Redshift account. The username must be valid to set up the destination endpoint.
Required. The password used to connect to the destination endpoint.
Required. Enter the external S3 Bucket name residing in an external AWS account, to use for staging data on Redshift.
Required. Enter the relative path to a folder in S3 Bucket. This is used as a root folder for staging data on Redshift. If you want to create files at the root level, enter a forward slash '/' to the file path.
san-francisco for using s3://sl-bucket-ca/san-francisco
S3 Access-key ID
Required. Enter the S3 Access key ID part of the AWS authentication.
S3 Secret Key
Required. Enter the S3 Secret key part of the AWS Authentication.