Can anyone please help with the java code for connecting to a redshift database with IAM Authentication

Question

I need a java code to connect to an AWS Redshift cluster programmatically with IAM Authentication rather than specifying the password and username for connecting.

Answer 1

Hi,

You can connect your Redshift database using Java connector or driver. Amazon has its own document to do this connection. I have attached the line below. You can go through once.

https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-in-code.html

Comments

Hey, Thanks for that. But this document details, on how to connect to DB via credentials i.e user name and password, but I wanted to connected to Database via IAM Authentication.

---

Hi,

According to my knowledge, IAM authentication we generally use for AWS CLI to run any command. Here you are using Java code. So you can use aws cli command to your code. Like in Python code we use the boto module to connect with AWS.

---

Hey, Can you please share an example on how to use aws cli command in the code for that on how to do so?

Thanks in advance.

---

Hi,

You can go through the below link. It will help you to configure AWS SDK for Java. I hope it will solve your requirement.

https://docs.aws.amazon.com/sdk-for-java/v1/developer-guide/java-dg-samples.html