Open topic with navigation
Scenario 2: Linking to an ODBC database
Scenario description
To demonstrate how you extract data from an ODBC database, we will work
on an example in the .
We will connect to the IGSS ODBC Driver and show online data from the
configuration.
The example is a diagram showing a production process (see below). It
shows the following:
- A
tank - where we measure the temperature and the amount (quantity
produced).
- Status
of batch – is the batch started or stopped ?
- Control
batch - The operator starts the production batch by clicking the
Start button and stops it by clicking
the Stop button.
- Database
grid – Here we will give the operator the option of showing the
following:
- The
list of active alarms (the ALM_ONLINE database table)
- The
online batch values (an SQL query that extracts the temperature, amount
and status of batch from the ATOM_ONLINE table)
An event has been defined for the database grid which will update the
contents when the production batch is stopped.
To go through the scenario, click the Start
Scenario button. If you have already completed the MS Access scenario,
you can skip steps 1 and 2 in the scenario.
Open topic with navigation