Tableau

Access to the postgres repository db

Source this guide http://onlinehelp.tableausoftware.com/v7.0/server/en-us/adminview_postgres_access.htm

cd "C:\Program Files (x86)\Tableau\Tableau Server\7.0\bin"
tabadmin dbpass super-secret-difficult-password
tabadmin configure

to connect to the db install pgadmin and use the following connection parameters

username: tableau
password: super-secret-difficult-password (insert upstairs)
port: 8060

in this way you have the access only to the views , tables that begin with

Access to all the tables

Source this http://community.tableausoftware.com/ideas/1470

C:\Program Files\Tableau\Tableau Server\7.0\pgsql\bin>psql -p8060 -Utblwgadmin workgroup
psql (9.1.4)
WARNING: Console code page (437) differs from Windows code page (1252)
         8-bit characters might not work correctly. See psql reference
         page "Notes for Windows users" for details.
Type "help" for help.

workgroup=# alter user tableau superuser;
ALTER ROLE

after that you have no more restriction for your tableau user in postgres pay attention

Salvo diversa indicazione, il contenuto di questa pagina è sotto licenza Creative Commons Attribution-ShareAlike 3.0 License