KnarrTek Logo

Industrial Decision Support Systems

Find Button

KnarrTek Tracking Software DEX Interface

DEX Interface

While the KnarrTek tracking software can be run stand-alone, there is often the need to exchange data with other systems or to produce custom reports.  The tracking database is not suitable for this purpose as it is structured to enable rapid transactional data capture from many geographically distributed sources. Also this database is often not locally accessible because the tracking software is being run in a remote data center.

DEX provides a simple and well documented interface to the tracking database, which uses a SQL Server DEX Database for intermediate storage, in a store-and-forward mechanism.

Data written into specific tables within the DEX database, such as for Items or Work Orders, are automatically  transferred to the tracking database. Similarly, data captured by tracking system transactions are automatically made available in specific tables within the DEX database. Also setup data, such as for work orders created in the tracking system, are automatically relayed to tables in the DEX database where they can be used as part of custom reports or data exchange with other systems.

Uses of the DEX interface include:

DEX, in its simplest form runs as a user program (DEX2) on a Windows Workstation computer in each manufacturing plant or warehouse. Through its user interface, users can control which data exchanges take place between the DEX database and the BellHawk web-services interface, and when. DEX is simple to install and can use the free Microsoft SQL Server Express database.

For long-running data exchange applications, where high reliability is required DEX can be installed as the MDEX Service on a Windows Server computer, where it can be remotely controlled and monitored through a web-browser interface.

For more information about the DEX Interface, please download a PDF data sheet about the KnarrTek DEX Interface

Please click here to learn more about The KnarrTek Technology

Technology Software & Prices Contact Us Services Tech Notes
Videos Applications Frequently Asked Questions White Papers Data Sheets
  Pilot Systems Copyright © KnarrTek Inc. 2021 About KnarrTek  
Contact Us
Software & Prices Technology Services
Videos Frequently Asked Questions Data Sheets
Applications About KnarrTek White Papers
Pilot Systems Copyright © KnarrTek Inc. 2021 Tech Notes