Private Redshift cluster connectivity from tableau web

Question

We have a EC2 server with tableau installed on it. We use that server as tableau web to publish our dashboards. 
We use few of the source database engines such as PostgreSQL RDS & Amazon Redshift hosted on a private subnet to create the dashboards through tableau.

We are facing issues while we connect to one of our private redshift cluster through the tableau server (EC2). Although, we have installed the redshift drivers by referring the below reference link, still we are getting error as Redshift driver not found while connecting through tableau Web UI.

https://docs.aws.amazon.com/redshift/latest/mgmt/configure-odbc-connection.html#install-odbc-driver-linux

Nita_S · Answer

Please see if following information helps to resolve Tableau connection issues to Redshift.
https://help.tableau.com/current/pro/desktop/en-us/examples_amazonredshift.htm
You may also want to make sure Redshift security groups allow connection from ec2 where Tableau is installed.
https://docs.aws.amazon.com/redshift/latest/mgmt/working-with-security-groups.html

amand · Answer

It got resolved by installing unix odbc. If still it doesn't work, then downgrade redshift driver version to https://s3.amazonaws.com/redshift-downloads/drivers/odbc/1.4.20.1001/AmazonRedshiftODBC-64-bit-1.4.20.1001-1.x86_64.deb

Private Redshift cluster connectivity from tableau web

Relevanter Inhalt