GUIDE+ Data Express

Guide+ Data Express is a streamlined tool for collecting any type of specified data elements from a wide variety of diverse sources such as relational databases, flat files typically produced by legacy systems, data warehouses and data marts, spreadsheets and reports, even external websites. With DataExpress you can easily get to the exact data you need regardless of where it may physically reside, because DataExpress can harvest data both via your own network and over the Internet.

Guide+ Data Express is deceptively easy to use for a tool with such powerful capabilities. Not only does Data Express gather the information you require at the touch of a button, but it also assembles the gathered data automatically into efficiently organized repositories of readily accessible information. Because raw data from different systems is most often stored in different formats, Data Express also automatically rationalizes the collected data, reformatting and synthesizing it for consistent syntax and representation.

This makes Data Express invaluable in implementing and supporting Enterprise Information Portals and Business Performance Management applications.

Data Express solves many of the most common headaches found in today's complex computing environments, such as:

Incompatible Systems - Companies often have financial, payroll, customer and operational data in different, unlinked and usually incompatible systems. Data Express pulls data from all of these sources together to produce a single, well-organized file.

Data Collection - Required data is often scattered in various different databases, text files, spreadsheets, legacy system flat files, or reports with a wide variety of file types, field types and data encoding formats. In addition, data may be in diverse locations such as production system files, data marts or warehouses, departmental systems, even out on the web. Data Express will bring together data from all of these sources to create a consolidated information repository with consistent data representation for easy and rapid access.

Data Cleansing - Data Express will "clean up" files in old systems that have missing, erroneous or inconsistent data.

Accounting Consolidations - Companies may have different subsidiaries, each with its own chart of accounts. Data Express automatically converts data from different charts of accounts to create a consolidated file for corporate reporting.

Automatic Allocations - With Data Express, you can specify that imported amounts be automatically allocated, or apportioned, into any number of different "buckets". For example, you may want to spread an annual figure across twelve months, or divide a monthly expense among various cost centers, or a quarterly production cost among different product lines. Data Express helps you address whatever your allocation needs may be.

Return to top of page



Copyright © 2004, Cornus Corporation, Inc. - http://www.cornus.com
4100 Payne Road, Medford, Oregon 97504 - Phone: 541 535-7800 - Fax: 541 535-7600
info@cornus.com

 

Joy Design Group