Skip to main content
Nov 8, 2019 5:59 PM UTC
Question

Bring your own BI/analytics

Kudos to the Servigistics team for looking into bringing advanced analytics into the Servigistics product, but as a large company, we have a defined strategy and end-state around our BI and analytics tools, so I'm curious if any others have a desire to see PTC pursue a "bring your own BI/analytics" approach to the Servigistics product strategy.

3 replies

Mar 25, 2020 7:39 PM UTC

This topic comes up frequently. It's difficult to design out of the box solutions since companies vary so greatly (even within the same industry). There are tools within the product, "Insight" (the dashboards tool) and "Intellicus" (the reporting tool. 

 

Intellicus also has dashboarding tools (and that's likely where things are headed in the future), as well. 

 

Both Insight and Intellicus are powerful and allow for the easy connection to the SPM (and/or SPP) database. However, having a good understanding of the database schema is important. 

 

For clients that are self-hosted (i.e., SPM exists on a server within their network), connecting a tool such as Power BI is easy to do. However, for clients that use PTC Cloud, there are security provisions in place to lock down the system for all but the absolutely necessary ports. As such, there is no way to directly query the database. 

 

What is possible for cloud clients is to either A) receive regular database backups, or B) receive regular "key table" or data outputs from the system. These files can be delivered/picked up from a SFTP dropbox or even emailed (depending on size). Intellicus directly supports this latter option, and it can be scheduled to run daily. 


When choosing this latter option, the suggestion would be to identify the key data points and have the system extract the data on a regular (e.g., daily, weekly, etc.) basis which then gets sent to a locally-hosted database (which could include Access, if desired). From there, a BI tool could more directly report the desired metrics. 

 

We can work with you on the details. Likewise, please feel free to contact me directly at bboatright@ptc.com.

 

Best regards,

J. Ben Boatright, MLSCM

Mar 30, 2020 12:34 PM UTC
Thanks Ben.
We'll be going down the PowerBI route and use the scheduling function in Intellicus to send reports to an ftp server. Not as elegant a solution, but given the data that we aggregate outside of SPM, this makes the most sense for us.
Hope you are doing well during these crazy times.
Jason
Mar 30, 2020 8:32 PM UTC
I think that PowerBI is a great tool, and it offers a lot of options (for a price of "free;" aside from needing to know the schema). The only thing that needs to be identified is the data to be pulled from the system.
PTC has been working on more advanced analytics; however, I think it worthy to get customer feedback on the self-access to the raw data.
Please let us know if you have any questions, or if we can answer any questions.
Ben