The term ‘legacy’ is usually synonymous with ‘difficult to access’. This is because legacy systems aren’t built on modern standards, and therefore are hard to access with modern tools.
See How Arbutus Analyzer Changes All This!
Analyzer is a full featured Windows application that directly accesses legacy data, avoiding the costly staging of data that is typical of other end-user solutions. It is specifically designed to provide powerful query, reporting and analysis capabilities for a broad range of legacy data sources. Because Arbutus specializes in legacy data access, even the most complex files can be defined, and then accessed, as if they were already stored in a modern database.
Unlike traditional data manipulation tools such as Access or Excel, Analyzer’s user interface is specifically designed to address the realities of directly accessing legacy data. Analyzer utilizes a familiar spreadsheet interface to browse, analyze or report on the data, making it appear as though it were already in a data warehouse.
Features that differentiate Analyzer from other analysis tools include:
No requirement for the source data to support modern access technologies
Accesses legacy data sources directly, without ETL, data staging, or extra infrastructure
Unlimited file sizes
Your data is secure, as Analyzer provides strictly “read only” access
Any legacy file, regardless of complexity, may be accessed
No programming required
Graphical user interface , and familiar spreadsheet interface facilitate ease of use
Data Definition Wizard expert system guides you through metadata creation
Automated metadata conversion allows rapid data definition in most cases
DB2, IMS, VSAM, ISAM, sequential (QSAM) Flat files and AS/400 data may all be integrated into Windows applications
Virtual columns allow any computations to appear as a column, even when accessing legacy data
Powerful data analysis and manipulation commands support even the most advanced tasks
Complete semantic layer allows customization of the table and column names
Advanced Data Processing and definition capabilities extend the value that can be realized from the legacy data
sources
The Overview is a quick and easy way to manage your projects. It shows all the defined tables, procedures and other objects, and lets you select any object by clicking
The Command and Log window tracks all your actions. As well, the results of your analyses are presented for review and action.
A large variety of query, analysis, reporting and manipulation commands are readily available from the menus. Each of these has options to meet virtually any need.
The Administrator utilizes Analyzer’s built-in data definition expert system and automated metadata conversion to quickly and easily expose each legacy data source. Once defined, the data is immediately available for use by Analyzer and LegacyLink™ users.
