Utilities 400
Utilities 400 Ltd
Churchgate House
Churchgate
Bolton
BL1 1HS
United Kingdom
Telephone
01204 388883
Utilities 400 Inc
10 South Riverside Plaza
Suite 1800
Chicago
IL 60606
USA
Telephone
(312) 474 5758
Fax
(312) 474 6099
Email
iRoute

iRoute selectively extracts and transfers data from various PC formats. The data source may be located anywhere on the network or an FTP site and transferred to:
  • The iSeries to create, append, replace or update file(s)
  • Other PC formats
  • FTP sites and network locations
All aspects of the data extraction process, from pre processing through to post processing, are configurable through the creation or modification of an iRoute Script.

The technical architecture of the product provides for automated, reliable data extraction combined with rapid data transfer.

To extract and transfer data, the user simply defines the data to be extracted from the PC format and provides the details of where the data is to be sent, what output format is required and any additional processing options required such as email. Once created the request can be saved for later execution. The request can be run on ad hoc basis, scheduled or triggered by an event such as the arrival of an email or the detection of files placed in folders.

Output formats
  • iSeries Physical Files
  • CSV
  • Text
  • Excel
  • Access Database
  • SQL
  • XML
  • Oracle
  • HTML
Input formats
  • CSV
  • Text
  • Excel
  • Access Database
  • SQL
  • Oracle
  • HTML
  • Lotus 1-2-3
Further information
Product overview Download