Specifications

About PlantScape ODBC Data Exchange
PlantScape Server and Client Configuration Guide 415
About PlantScape ODBC Data Exchange
The ODBC Data Exchange option enables you to configure the two-way
exchange of data between the PlantScape server database and an
ODBC-compliant local or network third-party database, using standard Structured
Query Language (SQL) commands.
When you configure the PlantScape ODBC Data Exchange option, the PlantScape
server acts as a client application. (Contrast this with the PlantScape ODBC Driver
option where the PlantScape server acts a server application.)
Data from a local PlantScape server database can be transferred to a third-party
database, and data from a third-party database can be transferred into the
PlantScape server database. The information that can be exchanged includes
point values, point history, and user file data.
The ODBC Data Exchange option transfers data to and from a third-party
database using the ODBC interface. An ODBC driver must be installed for the
third-party database. Databases that include ODBC drivers include Microsoft SQL
Server, Oracle 7, Microsoft Access, and Sybase 10.
The following diagram shows how the PlantScape ODBC Data Exchange option
interacts with ODBC drivers and third-party databases.
plscpcg.book Page 415 Monday, May 28, 2001 10:11 AM