# Redshift DWH

Please enter the following parameters to connect to a Redshift data source:

- Host / Port: IP address or hostname and port of the server where the data source is running
- SSL: use encrypted connection (available for Redshift data source)
- Schema / Database : schema / database name of the Redshift data source to connect to
- User name / Password: credentials to connect to data source
- Data source parameters: additional connection parameters
- Translator parameters: additional translator parameters
- JDBC parameters: additional JDBC parameters

Below are some examples of the most common data source parameters, see the reference manual for the full list:

- `importer.useFullSchemaName=TRUE` - schema names will be prefixed to table names to avoid duplicates
- `importer.importProcedures=TRUE` - stored procedures will be imported
- `importer.useProcedureSpecificName=TRUE` - when two stored procedures being imported have identical names, an index will be appended to their names in order to avoid conflicts

AWS S3 Load Options will set the credentials for using AWS S3:

- S3 Key ID: ID of the key which has proper permission to access the S3 bucket
- S3 Secret Key: secret key used to access the S3 bucket
- S3 Bucket Name : name of the S3 bucket to access
- S3 Region: region which the S3 bucket is located

To test the connection parameters press the Test connection button.