Learn about werum PAS-X batch data sources

There are two methods the interface can use to retrieve data from Oracle Server:

• querying a single view that contains data in the form of XML events

• querying a combination of tables from the PASX and WLTUSER name spaces.

  Note: Querying a combination of tables from the PASX and WLTUSER name spaces requires version 3.1.4 of the Werum PAS-X system.

The user that runs the interface requires read access to the IFMESTOPIBATCH_C table only. The IFMESTOPIBATCH_C table contains batch-associated data.

Data retrieval from the Oracle server is scan based. The interface uses the Oracle OLEDB driver (part of Oracle Provider for OLE DB package) to communicate with the Oracle server. After installing the Oracle Provider for OLE DB, verify that the ORACLE_BASE\ORACLE_HOME\bin directory contains the OraOLEDB.dll file.

To reduce the CPU load spike imposed by interface queries issued against the PAS-X database server, you can configure a delay between queries (/ibfd).