Does the JDBC Connector support AWS Redshift?

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

We have a new requirement to perform access management a Redshift DB - does the JDBC connector work for this use case?
If anyone has implemented this, is there any specific guidance you leveraged or followed from AWS?

:bangbang: Please be sure you’ve read the docs and API specs before asking for help. Also, please be sure you’ve searched the forum for your answer before you create a new topic.

Please consider addressing the following when creating your topic:

  • What have you tried?
  • What errors did you face (share screenshots)?
  • Share the details of your efforts (code / search query, workflow json etc.)?
  • What is the result you are getting and what were you expecting?
2

Hi @wjohnson_merck

I didn’t find any reference to Redshift JDBC driver details or documentation on SailPoint’s sites. It would be best to start implementing it in your dev/test environment to conclude whether it supports what you are looking for. Alternatively, you can reach out to the SailPoint support team for any specific queries.

Let’s see if anyone from the community has any insights about this.

I have following information from: GitHub - aws/amazon-redshift-jdbc-driver: Redshift JDBC Driver. It supports JDBC 4.2 specification.

Which clearly mentions it supports the IAM features.

It builds redshift-jdbc42-{version}.jar and redshift-jdbc42-{version}.zip files under target directory. The jar file is the Redshift JDBC driver.The zip file contains the driver jar file and all required dependencies files to use AWS SDK for the IDP/IAM features.

other details:

Redshift JDBC Driver

The Amazon JDBC Driver for Redshift is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in the Java Platform, Enterprise Editions. The Driver provides access to Redshift from any Java application, application server, or Java-enabled applet.

The driver has many Redshift specific features such as,

  • IAM authentication
  • IDP authentication
  • Redshift specific datatypes support
  • External schema support as part of getTables() and getColumns() JDBC API

The driver supports JDBC 4.2 specification.

2 Likes