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

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

Topics
Analytics
Tags
Amazon Redshift
Language
English
amand
asked 2 years ago1067 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

AWS
EXPERT
Nita_S
answered 2 years 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

amand
answered 2 years 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

Relevant content