Open TD Console.
Navigate to Integrations Hub > CatalogSearch for and select
- Click the search icon on the far-right of the Catalog screen, and enter Amazon Redshift.
- Hover over the Amazon Redshift connector and select Create Authentication.
Specify the required credentials.
Host: The host information of the source database, such as an IP address.
Port: The connection port on the source instance. The PostgreSQL default is 5432.
User: Username to connect to the source database.
Password: Password to connect to the source database.
Use SSL: Check this box to connect using SSL
JDBC Connection options: Any special JDBC connections required by the source database (optional).
Region: The AWS regions in which your Redshift instance is hosted.
Socket connection timeout: Timeout (in seconds) for socket connection (default is 300).
Network timeout: Timeout (in seconds) for network socket operations. 0 means no timeout.
Rows per batch: Number of rows to fetch one time.
Select Continue after entering the required connection details.
Name the connection so you can find it later should you need to modify any of the connection details.
Optionally, select Share with others, if you would like to share this connection with other users in your organization.