Treehouse Products and Services

tcACCESS - Powerful integration platform (Mainframe Software, Workstation software, Middleware) for users of IBM mainframes.

tcVISION - Data replication product that focuses on changed data when transferring information between mainframe and workstations or open systems.

tRelational - An ADABAS modeling, mapping, and data analysis tool that analyzes ADABAS file structures, data, and usage to aid in improving design and performance of ADABAS databases. tRelational also assists with modeling and mapping of ADABAS data into a relational format for use with a relational database management system (RDBMS). tRelational supports the Treehouse Software Data Propagation System (DPS) by generating all necessary parameters and mappings required for propagating ADABAS data and produces DDLs for generation of RDBMS schema. Includes:

• tRelationalPC - Windows-based graphical interface to make the tasks of modeling and mapping even simpler (free with tRelational).
• *Treehouse Remote Access (TRA) - Middleware that allows tRelationalPC to communicate with tRelational on the mainframe (free with tRelational).

DPS - (Data Propagation System) extracts and transforms ADABAS data for transfer to many popular RDBMS systems (including Microsoft SQL Server, ORACLE, Sybase, DB2, and Informix). Its highly efficient engine requires no direct ADABAS access, instead it uses ADASAV files to initially populate RDBMS tables and PLOG files to keep the RDBMS tables synchronized with their related ADABAS files.

DPSync - DPSync delivers critical information stored in ADABAS to an RDBMS in real-time. DPSync provides immediate access to ADABAS data updates without impacting ADABAS performance.

DPS X-Link - An instant XML Gateway for ADABAS that provides read/write access to ADABAS. Incorporating ADABAS access into your SOA / Web Services is now easier than ever.

NatQuery - GUI-based tool that intelligently generates NATURAL code to handle all of the complexities of data extraction from ADABAS.

NatCDC - Add-on to NatQuery designed to create immediately-usable data out of the ADABAS PLOG.

Remote and Onsite DBA Services/Consulting Services

Treehouse Software Consulting Services deliver the expertise that maintains your investment in legacy ADABAS/NATURAL systems

ADAMAGIC is a data extraction utility that easily converts mainframe ADABAS files into ADABAS for UNIX/Linux/Windows, flat file, or comma-delimited formats. ADAMAGIC reads ADASAV (mainframe) or ADABCK (UNIX) backup tape(s) to extract data for one or more selected files.

ADAREORG - A utility for reorganizing and restructuring ADABAS files. ADAREORG allows DBAs to respond to changing requirements by inserting and deleting fields, normalizing PEs and MUs, etc. It assists in tuning efforts by helping reorganize files. For example, by moving the most frequently accessed fields to the start of the physical record, ADABAS field decompression overhead is minimized.

ADASTRIP - A utility for fast, efficient extraction of ADABAS data from backups and directly from databases. ADASTRIP is suitable for recovering historical data from old backup tapes, creating test data, extracting subsets of data for deferred processing, removing historical data from the database, exporting data to another database, and more. It can reduce the ADABAS load by allowing processing to be performed on extracted data, eliminating the overhead associated with accessing ADABAS. By extracting a copy of the data from a backup, effectively "freezing" the image of the database at a point in time, ADASTRIP facilitates analysis that requires static data.

AUDITRE - A generalized auditing facility that uses the ADABAS Protection Log to identify changes to ADABAS data. Extensive reporting and selection criteria are provided.

CHART - A powerful and accurate tool for application analysis and documentation. CHART draws program calling structures, using the source code of your applications, on-line, in seconds, across all your libraries. In batch, CHART can completely document all the objects actually used in your system, with no mistakes.

ESPCONTROL - A Change Control System for NATURAL on Open Systems.

N₂O and N₂O/3GL - A change management system for NATURAL, which migrates NATURAL programs, PREDICT objects, and SYSERR error messages across local and remote nodes. N₂O offers on-line and batch migrations, multiple levels of authorization, audit trails, reporting, target compilation, XREF integration, automatic archiving, program compare, and check-out/check-in of source code. N₂O includes a Project Tracking Subsystem and full NATURAL application documentation tools. N₂O/3GL is a separately priced N₂O feature, which supports the migration of 3GL members, such as COBOL, JCL, etc., stored in PANVALET, LIBRARIAN, ENDEVOR, or MVS Partitioned Data Sets (PDSs).

PROFILER for NATURAL - A powerful quality assurance and testing tool for NATURAL applications, helping a site to identify untested programs, unexecuted statements, weaknesses in test data and procedures, inefficient code, poor application structure or design, and inefficient database access methods.

SECURITRE - An Interface between ADABAS/NATURAL and a System Security Facility (SSF), such as ACF2, Top Secret, or RACF. SECURITRE secures ADABAS at the database, file and field levels. ADABAS Utilities, NATURAL, and NATURAL Utilities are also secured.

TRIM - A performance monitor for ADABAS and NATURAL. TRIM provides on-line statistics on ADABAS and NATURAL use and performance. The batch facility provides total resource utilization statistics from summary or detail log data.

Return to top

SEDIT - An editor that emulates the mainframe XEDIT and PDF editors, providing users with a familiar editing environment under UNIX and Windows. SEDIT provides both character-based and GUI-based editing modes. SEDIT also provides many features not found in XEDIT/PDF, such as cut/copy/paste, unlimited undo, copy/move of rectangular blocks of text, search and replace of FORTRAN or C variables, interaction with compilers, and much more. SEDIT also includes an FLIST-like utility, which simplifies the browsing of UNIX directories.

S/REXX - A macro language that emulates the IBM mainframe REXX language on UNIX and Windows systems. S/REXX can be used to create macros for SEDIT, perform system administration functions, and develop applications. S/REXX supports programs of virtually unlimited size, continuing any number of nested parentheses, variables, etc. S/REXX supports Motif or OpenLook dialog boxes, including those with buttons, toggles, and input zones. S/REXX also interacts with C programs and UNIX system commands.

S/REXX Debugger - A GUI-based debugging environment for the S/REXX macro language. The S/REXX Debugger allows the user to step through the execution of S/REXX programs, locating and fixing bugs.

Return to top

Data Migration/Replication/Integration Products for Open Systems

TSI is a DataMirror DataWorld partner, and is authorized to market the full line of DataMirror products

Integration Suite™ - Combines all of DataMirror’s real-time integration software and global services.
Transformation Server™ - Real-time multi-platform data integration and transformation with zero-programming required.
Transformation Server/ES - Detects events as they occur in mission-critical production applications and creates useful business information to feed into the message queues of leading EAI, BPM, and SOA environments.
LiveAudit™ - Capture all data that is inserted, updated, or deleted to create real-time audit trails.
iReflect™ - Mirror ORACLE database transactions in real-time from the primary system to the recovery system.
iCluster™ - Manage clustered iSeries environments.
PointBase™ - Java relational database, mobility and synchronization products.
DB/XML Transform™ - Powerful Java-based, XML-driven engine for bi-directional data transformation between XML, EDI, database and text formats.
Constellar® Hub - Powerful ORACLE-based EAI tool.

Return to top

To receive more information about TSI products, or to request a free 30-day trial, contact Treehouse Software or your Treehouse affiliate.

View the TSI Product Compatibility Matrix, which shows the current version, operating system compatibility, etc.

View the TSI on-line evaluator kits, which have been developed to assist with the evaluation and justification of software purchases.

Other products are currently under consideration. Watch the TSI web site for details as they become available.