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

amand
demandé il y a 2 ans1271 vues
2 réponses
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
répondu il y a 2 ans
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
répondu il y a 2 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions