Double-click tRedshiftConnection to open
its Basic settings view.
Select Built-In from the Property Type drop-down list.
In the Host, Port, Database, Schema, Username, and Password fields, enter the information required for the connection to Redshift.
- In Advanced settings view, select Auto Commit check box to commit any changes to Redshift upon each transaction.