What would be a valid use cases to use the PI Integrator for BI versus the TIBCO’s PI connectors? What are the advantages that the PI Integrator offers?
Which Tibco Product are you referring too ? Tibco Spotfire, Tibco Streambase, or Tibco ActiveMatrix ?. The reason I'm asking is that there is TIbco connector for all these products.
If you are referring to Tibco Spotfire, there is indeed two options:
Tibco provided adapter - This is better use, if you need access or need analyse or do signal Analysis on raw PI System data from tags as you will get that directly. You will need some knowledge of the source PI System naming convention an likely about how PI tags data get compressed to do good analysis. As you will likely need to use the power of Spotfire to do the data cleansing and transformation, the end user will nee to be very proficient in Spotfire. This is better suited for data scientist or single analysis.
OSIsoft Integrator for BA - The PI Integrator for BA allows the user to use a wizard to creations a PI System data views (Rows and column format). The views are access with the PI ODBC driver using the Tibco ODBC native adapter. Once in Spotfire, the date is ready to be use and analyses, so you do not need to have a lot of knowledge in the PI System to use that data in Spotfire. Furthermore, for many of the analyses, you do not have to do data transformation in Spotfire as the Integrator is already creating "analytics ready data". Finally, since the Integrator views will cache the data, you can create really large queries over a large number of tags or months, and data access will be really fast once the initial query is made. There is also an option to schedule views so that new data gets added to the cache. I would suggest using the integrator if you want to provide data for dashboarding, KPIs, summary analysis and also if you have a large number of Spotfire users.
We would be interested if you can share your user case so that we can guide you better.
A quick read here: OSIsoft PI Adapters . Only did a quick scan of the text.
It seems that the Tibco PI adapter reads PI Points and requires the knowledge how to work on Tibco.
The PI Connector is much more user friendly and allows to access data from PI-AF. So there is a big advantage to that!
I work with both, PI connector for BI and Tibco PI Connector. In the case of the first, is more user friendly for people that only have knowledge in PI and not in Tibco, You can create a view( metadata) to be used by Tibco or whatever BI tool. In the case of Tibco PI Connector, Spotfire app have a connector from PI where you can connect at your PI server and AF server and get the PI points,AF Element or attributes that you need for creating a metadata table for your analysis. Certainly, You must have a knowledge of Spotfire for doing your analysis but is not complicated to work with Spotfire for creating several views using different kind of filters, rollups, etc.
In my opinion, both applications does the same but with different point of view. The essence is the same is creating a metadata table or view that later on will be used for analysing.
Thanks for sharing your experiences Jose!
Thanks for sharing Stephane. My thinking is aligned with yours and everyone's input. I have used the Tibco adapters (Spotfire) and specific knowledge of the PI System is required. I haven't used the PI integrator yet. The question was more to figure out what the secrete sauce is of the Integrator when compared to the Tibco adapters .
Retrieving data ...