Using non-ITM data in the TEP

Page Two.

The TEP can be used to display non-ITM data using ODBC provders, this example will show a simple scenario where we will display such data.

First thing is to establish an ODBC entry from your TEP server to the database you want to query. Let's say we are going to query a MySQL database from the OpenESM toolset. This database table named "TRIGGERS" has the following schema:

HOSTNAME
TRIGGER
TIMESTAMP
STATUS
UID

Using the MySQL for Windows ODBC drivers, we create the entry - then we need to tell TEP about it.

The TEP only recognizes data sources that have been defined to it. This definition is in the "KFWENV" file. Add an entry for your data source like this one:

DSUSER1="DSN=ODBC-NAME;UID=USER-NAME;PASSWORD=PASSWORD"

After this is added, you must recycle your TEP server.

With this entry in place you can create new Queries in the Query Editor, create one called TEST. When creating a custom query like this, YOU have to specify the SQL. So in our case here, the SQL statement would like:

select * from TRIGGERS where STATUS=ON

This will return any record where the TRIGGER STATUS is ON. By default the query returns the daya into a TABLE view - this may be appropriate.

Want more??? Keep reading.