All,
I've been using Tableau desktop for a while, new to server. I installed server and uploaded a workbook that uses a live PostgreSQL pull. I made sure to install the driver on the Microsoft server as well. On my Mac or PC when I go to through the browser to open Tableau Server and click on the workbook I'm prompted for the password to the database housing the sql. It just loops through entering the password indefinitely. But, if I open Tableau Desktop and log on to the server from there everything works.
I don't understand, can someone point me in the right direction please?
Thanks!
Are you looking to report on usage stats? I believe you'll need to add the ip address from your desktop machine, or whoever is looking to hit the postgresql DB, to the pg_hba.conf.templ file. Something like this:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all 10.0.0.0/8 trust