NatQuery

The NATURAL Data Extraction Answer for ADABAS

With today's demand for data, organizations need to be able to respond quickly to data extraction requests, and this data may need to be placed in several different formats/targets.

In examining ways to handle extraction requests for data that resides in ADABAS, it is impossible to overlook the fact that Software AG developed NATURAL specifically to provide for ADABAS data reporting. As a result, it is virtually a given that your organization has historically solved the issue of extracting data from ADABAS by utilizing NATURAL programs.However, using NATURAL to provide for data extraction from ADABAS requires expertise and time, especially when the required NATURAL processes are hand-written. Once created, more expertise and time will be required in order to handle any needed maintenance or enhancements.The answer to this problem is simple: a full GUI tool that has NATURAL data extraction intelligence built in, and the automatic ability to quickly “learn” the nuances of your ADABAS source files. The combination of intelligence and file-specific knowledge then provides the expertise needed to allow a user to intelligently generate and execute data extraction processes without any need for programmer or IT intervention.NatQuery is the NATURAL answer to ADABAS data extraction and replication that leverages the inherent power of what NATURAL was designed to do, while at the same time removing the need for any in-depth training and/or knowledge of NATURAL, ADABAS or any of the other intricacies of the operating system on which NATURAL and ADABAS reside.You already know how well NATURAL works with ADABAS. NatQuery simply allows your organization to use NATURAL even more effectively than you do today.

NatQuery: A NATURAL evolution in delivering data stored in ADABAS.

General List of Features

Graphical generation of ready-to-execute NATURAL data extraction programs and processes that support both end-user and data warehouse extraction needs
Extracts data directly from ADABAS or from ADABAS backup tapes
NO server installation required
NO middleware beyond basic FTP
Supports both Summary and Detail Extraction
Supports extraction from multiple source files
Supports automated and direct integration with numerous targets such as: Microsoft Excel, Microsoft Access, XML, popular relational DBMSs and ETL tools such as Ascential Software’s DataStage Suite
Supports extraction from DB2 and VSAM data sources in NATURAL for DB2 and NATURAL for VSAM environments
Supports ADABAS-to-ADABAS replication

Supported Platforms

OS/390, z/OS, VSE, UNIX and Windows

Supported Versions of ADABAS

OS/390, z/OS, VSE - Version 6 or Higher
UNIX, Windows - Version 3.1 or Higher

Supported Versions of NATURAL

OS/390, z/OS, VSE - Version 3 or Higher
UNIX, Windows - Version 5 or Higher

NatQuery Literature Available On-line:

NatQuery FactSheet (English)
NatQuery FactSheet (German)

NatQuery and NatCDC Overview Presentation

Building a Data Warehouse Presentation

Building An End-User Extraction Presentation

Building a Dynamic Variable PowerPoint Presentation

Contact Treehouse Software Today!

To receive more information about NatQuery, or to request a free trial, contact Treehouse Software.

TREEHOUSE SOFTWARE, INC.
409 Broad Street, Suite 140
Sewickley, PA 15143

Phone: (412) 741-1677
Fax: (412) 741-7245
Email: sales@treehouse.com