Ditch individual query scripts and RPG code and replace them with one secure product. RouteOne enables you and other ‘power users’ to quickly write new IBM i data exports without any coding to maintain.
Select data from a Spool File and/or database and then convert it to a format of your choice before distributing it by your preferred method.
‘Listen’ for specific file types such as orders via email or updates to a Bill of Material (BOM) on your manufacturing shop floor and then (depending upon the rule) extract the data from those files and directly upload them to your IBM i in a secure and reliable format.
Acting as a virtual terminal, iKeyer can be ‘taught’ input processes by recording an input session (or you can use its inbuilt scripts) to automatically pick up data from external sources and ‘key’ that data into your IBM i using a 5250 green screen session.
Replace costly, repetitive and error-prone manual processes with automated rule-based workflows triggered by changes to IBM i fields.
ProActive works 24/7, completing tasks in seconds that would take hours manually, and is fully integrated with both iKeyer and iRoute.
Accept multiple formats including TXT, CSV, XLS, XLSX, PDF, XML, HTML and more.
Accept multiple database formats including SQL / MySQL, Access, Oracle and DB2.
Accept multiple file locations, including FTP, sFTP, Network, Local, Cloud, Email, DTS / ADO.
Output data in multiple formats including XML, XLS, CSV, Access & SQL.
Send alerts by SMS text using RouteOne.
Export DB2 files to external database formats, including Oracle, SQL & Access.
Make your data meaningful with post-processing routines to add custom formatting.
Transfer data up to 5x faster than traditional ODBC technologies.
Extensive options include launching programs, Excel and Access macros, DTS packages, Stored procedures, batch files etc.
Data transfer using secure technologies to prevent unauthorised access.
Easily install and configure products so they can be used immediately with minimum setup.
Combine multiple products to supercharge your data integration and automation capabilities.
Watch a recorded demonstration of IBM i data workflow software from Utilties400. Learn how RouteOne, iKeyer, iRoute and ProActive offer you the complete data automation toolkit.
Using RouteOne, you can export in many popular data formats – fully formatted! These include, PDF, XLS & XLSX (with post processing), XLM, CSV, HTML, DOC & DOCX, SQL [with managed ETL], and more…
Using iRoute, you can accept, validate and import many popular data formats using many different methods. Data formats include include, PDF, XLS & XLSX, XLM, CSV, HTML, TXT, SQL, and more… from different sources including a file within the body of or as an attachment to an email, ADO/DTS, FTP/sFTP, Network Location and Cloud.
Yes, using iRoute you can capture, process and validate multiple data formats from multiple email accounts (or indeed FTP/sFTP locations). Then, using iKeyer, you can ‘key’ in the data via the green screen. This process can be fully automated and run 24/7.
No, you can run RouteOne, iRoute, iKeyer and ProActive without any programming knowledge.
Both iRoute and iKeyer provide validation opportunities. With iRoute, you have a validation rule engine that allows for existence checks, value ranges, etc. before data parse. iKeyer uses the greens screens built in validation for data entry.
ProActive triggers events depending upon values or changes in conditions. For example, only trigger events if the customer balance now exceeds the credit limit. Optimise automation per customer, activity and/or user – the choices are almost limitless.
Yes, you can purchase each application individually. And, while all products run separately, all can be seamlessly integrated with each other.
Yes, using the definition engine, you can write ETL (Extract, Transform and Load) procedures to create managed data warehouses that can be updated in real-time, on intervals or triggered on given events. Data warehouses can be created on most popular database formats including SQL, Oracle and Access.
Yes, you can use RouteOne to create fully formatted electronic business forms such as invoices, orders, reports and more. For printed media and PDFs, you can populate pre-created templates created in MS Word. For other electronic delivery, use the same data for the creation of HTML documents, export to XLS, XLM and more…
Yes, please contact our sales team for a free 30-day trial of the Utilities 400 applications.
