Specifications

Configuring ODBC Data Exchange Reports
PlantScape Server and Client Configuration Guide 417
Configuring ODBC Data Exchange Reports
The following procedures assume that you have already completed the
PlantScape ODBC Data Exchange installation as described in the installation
guide. Specifically, the procedures assume that:
• Your PlantScape Server license includes ODBC Data Exchange
• You have installed the third-party ODBC driver on the PlantScape server for
the database that you will be transferring data to and from. (For information
on installing and configuring the ODBC driver, consult the documentation
supplied with the third-party database.)
The configuration procedures depend to a certain extent upon the third-party
databases you intend to use in conjunction with the PlantScape ODBC Data
Exchange option. In general, however, the procedures are as follows:
1 Configure a data source on the PlantScape server, as described in
“Configuring the ODBC Data Source” on page 417).
2 Configure the ODBC Data Exchange Report, as described in “Configuring
the ODBC Data Exchange Report” on page 418.
3 Create the Input Reference file as described in “Specifying the Report
Definition File Details” on page 418.
4 Run the report you configured in Step 2.
Configuring the ODBC Data Source
The procedures for configuring the ODBC data source vary according to the
third-party database software you will be using. The following procedures show
you how to configure the data source for Microsoft SQL Server 7.0. The set up for
each driver will differ slightly.
To configure the data source:
1 Select Start
⇒
Settings
⇒
Control Panel
⇒
Administrative Tools
⇒
Data Sources (ODBC). The ODBC Data Source Administrator dialog box
opens.
2 Click the System DSN tab to display the available data sources.
3 Click Add to display the Create New Data Source wizard.
4 Select SQL Server from the list of installed ODBC drivers and click Finish to
open the ODBC driver setup dialog box.
5 In the ODBC driver setup dialog box:
a) Enter the data source name, description and Server name and click
Next.
plscpcg.book Page 417 Monday, May 28, 2001 10:11 AM