-
1. Re: Tableau Server Postgre - does it store the name of the database object?
Patrick Van Der Hyde Aug 16, 2018 10:01 AM (in response to mark.welsh)Hello Mark,
The data connection information details are part of the recommendation schema i am told. Remember though that connecting to the db directly like this is not supported and changes in future versions may make reports/processes built using this break. We recommend not making this a long term plan for the data to exist in this way.
I hope that helps.
patrick
-
2. Re: Tableau Server Postgre - does it store the name of the database object?
mark.welsh Aug 17, 2018 9:21 AM (in response to Patrick Van Der Hyde)Thanks Patrick! Finding some good info in these tables. I'll keep this open a little bit longer in case anyone has something to add.
I sure hope they don't break the connection to the Server database! So many people use that for insights.
-
4. Re: Tableau Server Postgre - does it store the name of the database object?
mark.welsh Aug 17, 2018 11:31 AM (in response to Ritesh Bisht)Hi Ritesh,
Yes, this is the database I was referring to. Having the schema is very helpful - thank you for the link.
-
5. Re: Tableau Server Postgre - does it store the name of the database object?
Ritesh BishtAug 17, 2018 12:00 PM (in response to mark.welsh)
Hi Mark,
Glad that it helped you.
Please mark the answer as CORRECT & HELPFUL so that it can help others as well.
Thanks,
Ritesh
-
6. Re: Tableau Server Postgre - does it store the name of the database object?
Tony Chan Aug 17, 2018 1:59 PM (in response to Ritesh Bisht)Hi Mark,
Not all of the information I want is in the postgres workgroup database tables. Sometimes I convert the workbook to xml (unzip .twbx to get .twb then rename .twb to .xml) to get the information e.g. database table name, database field name.
Hope that helps, Tony
-
7. Re: Tableau Server Postgre - does it store the name of the database object?
mark.welsh Aug 20, 2018 7:17 AM (in response to Tony Chan)Hi Tony,
We've been toying with that as well. So far it looks like we can find everything via XML. We're using Andy Cotgreave's TWB Auditor to automate this for us. Super helpful.
Thanks