Specifications

20 – Using PlantScape Data in Other Applications
392 R400
PlantScape ODBC Support
ODBC is a standard set of function calls for accessing data in a database. These
calls enable you to perform Structured Query Language (SQL) queries on the
database.
ODBC can be used in any client/server architecture, regardless of whether the
database and client application are resident on the same computer, separated by
a network, or even if they are on different computers using different operating
systems.
PlantScape ODBC support enables the transfer of data between the PlantScape
server database and other third-party databases. The supported databases are any
application that provides support for ODBC function calls (for example, Microsoft
Access) or has an ODBC driver.
ODBC support is provided through two separate PlantScape options:
• ODBC Driver, which enables retrieval of:
– Point data
– History data
– Event data
Note ODBC Driver is intended for ad hoc queries. For repetitive or
high-speed data retrieval you should consider Microsoft Excel Data
Exchange, Network API, or OPC Server.
• ODBC Data Exchange Report, which enables two-way transfer of:
– All server data
plscpcg.book Page 392 Monday, May 28, 2001 10:11 AM