By using AWS re:Post, you agree to the Terms of Use

Private Redshift cluster connectivity from tableau web

0

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

asked 6 months ago92 views
2 Answers
0

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

answered 5 months ago
0

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

answered 5 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions