Product/Service

PI-ODBC (Integration)

Source: OSI Software, Inc.

PI-ODBC extends the reach of the Plant Information (PI) System, enabling a PI System to interoperate with all major, established database systems.
OSI Software, Inc.onnectivity with Relational Databases
PI-ODBC extends the reach of the Plant Information (PI) System, enabling a PI System to interoperate with all major, established database systems. This connectivity enables users to gain maximum business advantage from the data and information distributed throughout their corporations.

Get Data from Non-PI Sources
The PI clients can access data from relational and non-relational databases using standard relational query methods; specifically, ODBC and SQL. This enables PI clients, such as PI-ProcessBook, to query and display information from both PI data servers and other data servers, such as ORACLE, SYBASE, Microsoft SQL, and Informix. Use with another PI client, PI-DataLink, enables a spreadsheet to query and display information from both PI servers and non-PI servers.

Supply Data to Non-PI Clients
With PI-ODBC, non-PI clients can access data in PI data servers. This means popular application builder tools, such as PowerBuilder, SQLWindows, ORACLE Developer, and Visual Basic can be used to build applications that need access to data in PI servers.

Exchange Data between PI Servers and non-PI Servers
The RDBMS-to-PI interface enables bi-directional data transfer between the PI data server and other ODBC-compliant data servers, such as ORACLE. This interface can be used, for example, to continually update production level and status information in an Enterprise Resource Planning (ERP) system.

Exchange Data Between PI clients and non-PI clients
PI-ProcessBook can share data with non-PI client products that host the cross-product programming language Visual Basic for Applications (VBA). A large number of software products including Microsoft Office and many specialized business and industrial applications are now enhanced with VBA. With VBA technology, it is now possible to leverage the value of PI data into almost any environment.

<%=company%>, 777 Davis St., Suite 250, San Leandro, CA 94577. Tel: 510-297-5800 Ext. 836. Fax: 510-357-8136.