Connect to PI Historian

[kerryellsworth]

Can you give me some tips on how to connect an elasticube to a PI Historian server?  Is there an add on for PI Historian that I need?  We want to combine data from an Oracle database with PI Historian data to show both in a dashboard.

[Ophir_Buchman]

Hi @kerryellsworth,

Sisense doesn't currently hold a data connector for PI Historian. However, while looking at OSIsft's website (Link) - Under the "PI Integrator for Business Analytics" section:

PI Integrators let you analyze operations data using familiar tools such as IBM Cognos, Oracle Analytics, Power BI, Qlik, SAP BI, Sisense, Tableau, TIBCO Spotfire, or any tool that accesses data using Open Database Connectivity (ODBC) or SQL standards.

I'd suggest contacting them directly to discuss the availability of a 3rd party data connector.

Thanks,
Ophir

[Ophir_Buchman]

Hi @kerryellsworth,

Were you able to resolve your concern?

Thanks,
Ophir

[kerryellsworth]

I have a request in to OSISoft, I have found some of their documentation online that mentions using an ODBC connection.  Hopefully we can make that work!

Thanks for asking!

--Kerry