Connecting Integrity To Data Visualizations Tools Such as Tableau

Forum|Forum|12 years ago
December 17, 2013
2 replies
7033 views

Has anyone connected Integrity to a data visualization tool such as Tableau? Is there an ODBC driver that can be used?

I understand from reading other posts that certain fields are calculated on the fly so will likely not be available. Not sure if a 'live connection' can mitigate this.

Thanks in advance.

J

jgorsline

1-Visitor

Mike,

We have not been asked about a Tableau integration before. I just checked out their web page and it does look pretty cool though. You certainly know more about how it works than I do, but could exported data from Integrity be used to create a Tableau report? We export to Word and Excel formats, which are pretty common. Any idea if that might work?

P

ptc-5433395

Author

1-Visitor

Hi Jeremy,

Thanks for the reply. I have used Tableau and found the tool very helpful for data exploration and visualization. The tool can connect to many types of databases and file types such as MS SQL Server and Excel.

Currently we export data into Excel and load it into Tableau to do some analysis and reporting. A live connection database connection between Tableau and Integrity would be more ideal in cutting down manual efforts.

One of the biggest challenges in using a database connection is the values for several fields are not stored, but rather calculated on the fly, making them unavailable for Tableau. The normalization of tables presents another challenge.

J

jgorsline

1-Visitor

I agree. It would most likely be nessisary for a proper integration to be written to get Tableau to work up to its potential with Integrity. If you contact PTC Integrity Support we can enter an RFC to add this functionality, or possibly get you in touch with our Services department who might be able to author this integration for you.

M

MichaelChatel

5-Regular Member

For any other customers/folks that come across this discussion, wondering the same, reference the following PTC knowledge base article, to express interest in Integrity with Tableau usage:

CS158953: Integration of Integrity with Tableau Business Analytics/Visualization Software