What is Mac equivalent of ADFSCredentialsProvider when connecting to Redshift from SQLWorkbench

Question

I am attempting to connect to Redshift from a Mac machine using SQLWorkbench.  I am able to make the connection from a Windows machine by providing  plugin_name as    
```
plugin_name 	com.amazon.redshift.plugin.AdfsCredentialsProvider
```

I need to make the connection from a Mac and the above doesn't work from Mac as it is meant for windows only.  I am using Amazon provided JDBC driver

Get this error on Mac

![Error on Mac - with ADFSCredentialsProvider](/media/postImages/original/IME22fu35JQfaMeIwNpEmtkA)

https://i.sstatic.net/lNMNTs9F.png

What credentials provider can be used on a Mac?

Thank you

Answer

Hello,

For Windows, if UID and password are not provided in properties file, then the driver attempts to obtain the user credentials of the user logged in to the Windows machine.

As per 'AdfsCredentialsProvider' class, if  “m_userName” & “m_password” are null, then it call return 'windowsIntegratedAuthentication()' method which works only for windows environments.

For non-windows system , we have to pass “m_userName” & “m_password” values in your properties file , and it will call 'formBasedAuthentication()' method for ADFS authentication.

Thus, could you please pass “m_userName” & “m_password”  values in your  properties file and re-test your connection.

Also, you can refer the below documentation for more details on Federate access to your Amazon Redshift cluster ADFS : 
[+] https://aws.amazon.com/blogs/big-data/federate-access-to-your-amazon-redshift-cluster-with-active-directory-federation-services-ad-fs-part-2/

That being said, if the above workaround doesn't work, I would request you to please raise a support case with AWS for further investigation with some more details. If a support case has already been created please be assured that we will get back to you and assist you in the best way possible.

Thank you for your interest in re:Post community.

What is Mac equivalent of ADFSCredentialsProvider when connecting to Redshift from SQLWorkbench

Relevant content