7 Replies Latest reply on Aug 20, 2018 7:17 AM by mark.welsh

Tableau Server Postgre - does it store the name of the database object?

mark.welsh Aug 1, 2018 10:28 AM

We want to join up a list of our SQL Server objects e.g. Stored Procedures, Views, etc. to a list of reports published to Tableau Server that use the objects. Looking at the "datasources" table in the Tableau Server Postgre database I only see the name of the data source which doesn't necessarily match the name of the SQL Server object.

Does anyone know if the actual name of the database object is stored anywhere in the Tableau Server database?

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
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions
3. Re: Tableau Server Postgre - does it store the name of the database object?

Ritesh Bisht Aug 17, 2018 9:38 AM (in response to mark.welsh)

Hi Mark,

Do you mean this information Workgroups Database ?

Thanks,
Ritesh
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions
5. Re: Tableau Server Postgre - does it store the name of the database object?

Ritesh Bisht Aug 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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 1 Likes(1)

Actions