2007 - User Conference - Monterey
OLEDB Goes Enterprise - The PI System Data Provider
PI OLEDB Data Provider is a key component of OSIsoft’s data access strategy. The OLEDB standard and SQL query of the PI Server allows integration with a wide range of relational database products and business intelligence applications. In this presentation we will use Microsoft SQL Server Integration Services to export PI data in XML format via e-mail. We will also demonstrate accessing PI data in a Java environment using a JDBC adapter with PI OLEDB. In the future, as the PI System evolves, we will provide SQL access to more than just PI data. In upcoming products we will expose data from AF 2.0 including time-series data, asset models, event frames, and external data sources. We will explain in this session how these challenges are addressed with our new PI Data Access Server and new PI System Data Provider.
Bodo Bachman is the Engineering Manager for OSI Software, GmbH. He joined OSIsoft in 1991 as an interface developer. He was also responsible for all of the engineering work associated with selling software. Today, he is still responsible for the engineering part as well as the GmbH Development Group. Bodo received his diploma in Physics from Carl Zeiss Jena. He started his career in a semiconductor factory before starting work for a division of Leica that manufactures semiconductor inspection systems.
Martin Freitag is a senior engineer at OSIsoft. Experienced with PI product installations since 1997. Specializing on communication with relational databases and writing PI interfaces in particular. Software developer in C++, VB and SQL. Product specialist for PI OLEDB and PI interfaces, above all, RDBMSPI and PI_UFL.