I installed a Tableau server in AWS EC2 using ubuntu 16.04 and tableau 2019.1.5. I have installed data drivers I need but I could not get data source connection.
if I login web server of tableau dashboard (the one with port 80), go to status (it showed server status), go to Traffic to data source, it showed error: Unable to connect to data source...
The drivers required to connect to the data source are not installed.
Unable to connect to the PostgreSQL server "ip-10-123-30-20". Check that the server is running and that you have access privileges to the requested database.
Note "ip-10-123-30-20" is the hostname of my AWS EC2. I already added it to private host zone so it can be resolved to ip.
I try to test connection from the tableau server to redshift and postgreSQL postgreSQL is in the same tableau server machine, redshift is in another cluster.
if I ssh the tableau server, I can access the redshift (using a python script) and the postgreSQL (command: psql -h ip-10-123-30-20 ....), ip-10-123-30-20 is the hostname of the tableau server. which means network connection is ok. no firewall block.
But if I access the tableau server from webpage (the one with port 80), goto Explore All Data Sources (on left of the page) , filter (on the right of the page) to Connection Type -> choose Redshift -> choose any workbook -> choose … (3 dots) -> edit connection->test connection fails. Same thing if I choose Connection Type as PostgreSQL it fails too
Besides, if I access the tableau server webpage (the one with port 80), goto status -> goto Traffic to Data Source -> it showed error like Unable to connect to the PostgreSQL server "ip-X-X-X-X".
in summary, the network connection between the tableau server and its data source redshift and postgreSQL is ok but tableau server cannot set up connection to them from web page.
