Windows Data Engine

Easily stage mainframe data

The Arbutus Data Engines have been designed to help organizations address some of their most challenging data delivery and analysis requirements. The Windows Data Engine resides natively on enterprise servers enabling fast, efficient data access and query processing support for solutions involving Arbutus Connect, Migrate, Query and Instant Warehouse.

The Windows Data Engine is used to support requirements for:

Staging data from multiple platforms

• Stage data from other platforms for the purposes of performance optimization or to increase analysis and reporting capabilities
• Allows for the transparent joining and comparing of data from disparate sources
• Staged data can be used just as if it were in a data warehouse
• Data marts can be created and updated as easily as just copying a file

Offloading CPU cycles from production environments

• A simple, low cost solution to stage and access mainframe data
• Unique in that it is fully compatible with all data set structures and data types encountered on your mainframe or AS/400
• Staging data is as simple as a file transfer, with no data transformation required
• Implement a data mart style solution, with full access for any type of query, analysis or reporting needs, in a matter of days

Usage and access solutions for historical data from decommission platforms

• Fully compatible with all data set structures and data types encountered on your mainframe, Unisys, HP or DEC platforms
• Staging historical data is as simple as a file transfer, with no data transformation required

Combining and processing data from any data file, database and data mart

• Process data from any database that can be accessed via any ODBC connection including DB2, SQL Server and Oracle
• Local data, staged mainframe data and even SQL databases can be combined and integrated in any way desired, into a single unified view
• Supports the combination of different databases. For example, Oracle tables can be dynamically combined with SQL Server tables

Key Capabilities of the Windows Data Engine

Accessing and integrating all data

• Specializes in reading both relational and non-relational data sources; including the most complex legacy file structures
• Enables each of these data sources to appear as a table in a single unified database
• Tables may be combined in any manner desired, irrespective of the original data source
• IT no longer needs to deploy a number of separate data interfaces to access the various sources
• With the installation of just one driver, users have access to virtually any data source

Moving data between platforms

• Data sources can be easily moved between server platforms or from the server to the desktop
• Data and databases can be easily brought together from multiple platforms for analysis and reporting purposes

Analyzing data

• Analysis can take place on the server, the desktop, or a combination of each
• Allows analysis to occur against ‘live’ data or staged data; providing complete analysis flexibility

Sharing of data

• Supports the easy sharing of data access and analysis among users
• Data access can be controlled by a central administrator, whether on-site or from a remote location

Optimal processing performance

• Optimized for strong performance in processing large data files allowing end users to experience faster response times to their queries

Technical Features>>

Download Arbutus Technology – Data Engine Brochure [PDF]