About connecting to Redshift using the JDBC Connector

Question

I would like to connect HULFT Square to Redshift using the JDBC Connector.
Please tell me what to check in order to connect.

Answer

First, please check the following items on the Redshift side to set up a JDBC connection.

-Connection URL
The URL to connect to the database.
In the case of Redshift, it is the "Cluster Database Properties-JDBC URL" displayed on the Redshift console screen.

-User name
Database user name.

-Password
Database password.

-(Only for PrivateLink connections) Specify the Redshift Cluster Endpoint in a target group of an NLB
For PrivateLink connections, please specify the Redshift Cluster Endpoint in a target group of an NLB on your side.

After checking the above items, please create a JDBC connection and check if it is possible to connect to Redshift.
The required settings for a JDBC connection on the HULFT Square side are as follows:

-Driver class name
The class name of the JDBC driver.
For Amazon Redshift JDBC driver, please specify "com.amazon.redshift.jdbc42.Driver".

-URL
The URL to connect to the database.
Please specify the "Cluster Database Properties-JDBC URL".

(Only for PrivateLink connections)
Please replace the cluster endpoint name in the JDBC URL with the DNS name of the VPC Endpoint created in HULFT Square, and specify the Redshift Cluster Endpoint in a target group of an NLB on your side.

Amazon Redshift > Getting the JDBC URL
https://docs.aws.amazon.com/redshift/latest/mgmt/jdbc20-obtain-url.html

-User Name
Database user name.

-Password
Database password.

How to set up a JDBC Connection is also described in the related FAQ below.
Please check the FAQ as well.

Related FAQs

JDBC Connector - How to set up connection resource and use connector