OLE DB is an open specification designed to build on the success of ODBC by providing an open standard for universal data access. PI OLEDB being part of the PI Data Access Pack implements this standard and allows a connection between PI and a wide range of relational database products. The presentation will give demos of plug and play integration with MS SQL Server and Oracle, e.g. how to automatically synchronize PI Batch from RDBMS batch tables. Finally a preview of the next major update will show the steps to develop a Web Service for PI OLEDB (using VS.NET and ADO.NET).
Bodo Bachmann, a physicist by training, worked in the semi-conductor industry and then joined OSIsoft in 1991. He started as an interface developer, especially to work on European systems. He has been leading the development and product support group in Europe for several years. His favorite projects are the RDBMSPI Interface and the PI OLEDB data provider.