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
preguntada hace 3 años1278 visualizaciones
2 Respuestas
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
EXPERTO
Nita_S
respondido hace 2 años
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
respondido hace 2 años

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas