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
versione della pagina: 0, ultima modifica: 27 Feb 2014 10:34