Arbutus Query is an intuitive and comprehensive query tool with built-in data analysis capabilities. Simpler than traditional query tools, Arbutus Query makes it easy to issue ad hoc queries to a wide range of data sources without having to know the location or structure of the underlying data. That means users can get the business answers they need quickly, without having to wait for IT assistance.

Arbutus Query Provides Independence from the IT Department

While applications such as business intelligence tools, standard reports, spreadsheets and SQL query tools are all useful, many users find they fall short in three key areas:

• Application has problems accessing legacy systems and other non-warehoused data
• Application does not support the desired analytics or data volumes
• Significant IT resources and preparation are required to support new data queries

With Arbutus Query, you can easily analyze data from a wide variety of data sources and data types, and process commercial data volumes, with minimal involvement from IT personnel. This independence creates benefits for both IT and end-users.

Arbutus Query and Arbutus Analyzer

The face of Arbutus Query is Arbutus Analyzer, a proven, well established interface used by professionals all over the world. The Analyzer interface allows users to efficiently perform timely and important data analysis and reporting. It also enables IT staff to provide quick turnaround to requests for new data sources.

See the interface

.

For Users

• Users are not restricted to data warehouses and data marts
• New customized queries and reports can be added without the typical set-up time and costs
• The intuitive interface is specifically designed for analyzing data
• Log file of all queries and results creates permanent audit trail of work performed

For Data Analysis

• Easily compare or join disparate data sources
• Built-in data profiling, testing and verifying capabilities
• Data stores from different platforms and data types can be seamlessly queried
• Optional query language allows for customized and automated queries to be easily created and deployed

For Data Sources

• No file size limitations
• Data sources can be added and integrated quickly
• Read-only data access ensures data integrity

.

Choose Where the Query and Analysis Take Place

When mainframe and AS/400 resource constraints make direct access and analysis solutions impractical, Arbutus Query enables you to easily offload your critical processing to either the Arbutus Windows Server or the Arbutus Linux Server.

Unlike typical open server implementations, the Arbutus Windows Server and Arbutus Linux Server are fully compatible with all data set structures and data types encountered on your mainframe. This means that the process of staging data is as simple as a file transfer, with no data transformation required. The result is, you can implement a data mart-style solution, with full access for any type of query, analysis or reporting needs, in a matter of days.

Query: Learn More

Query: How it works

 Download: Arbutus Query Brochure (PDF)

.