PRODUCTS

ABOUT US

SUPPORT

CONTACT US

Home

What's New?

About Us

Products
Data Migration / Replication / Integration / Products for the Mainframe
    tcACCESS
    tcVISION
    tRelational
    DPS
    DPSync
    DPS X-Link
    NatQuery
    NatCDC
    DataMirror Products
Mainframe Emulators
    SEDIT
    S/REXX
    S/REXX Debugger
ADABAS/NATURAL
    ADAMAGIC
    ADAREORG
    ADASTRIP
    AUDITRE
    CHART
    ESPCONTROL
    N2O - N2O/3GL
    PROFILER
    SECURITRE
    TRIM

Customers

Services

Support

Partners

Management

Newsletter

Links

International

Evaluator Kits

Employment

Site Map

Contact Us

tRelational

ADABAS-to-RDBMS Data Modeling and Mapping


	Download tRelational Literature and Presentations below!

tRelational and Data Propagation System (DPS) are robust products that provide modeling and data transfer of legacy ADABAS data into modern RDBMS-based platform for Internet/Intranet/Business Intelligence applications. Treehouse Software designed these products to meet the demands of large, complex environments requiring product maturity, productivity, feature-richness, efficiency and high performance.

Map it, Pump It, and Sync It

tRelational optionally auto-generates complete RDBMS schema from existing ADABAS files, and alternately allows easy mapping of ADABAS fields to already existing data warehouse or ERP schema. After tRelational does the mapping, DPS can then materialize (initially load) and propagate (subsequently keep synchronized) the ADABAS data into the RDBMS without requiring direct access to ADABAS.

"I would strongly recommend the use of the tRelational and DPS products for any other State agencies that are currently utilizing ADABAS, especially if they need to do any migration to another platform for data warehouses."

     -Nancy Kane
      Systems & Programming DBA Manager
      Arizona DES

Capabilities

tRelational offers the following features:

RDBMS data modeling and mapping of ADABAS structures to RDBMS structures
Optional auto-generation of complete RDBMS schema (Tables, Columns, Primary Keys, and Foreign Keys) based upon existing ADABAS file structures. Periodic Groups and Multiple Value Fields in an ADABAS file become child tables in the generated RDBMS data model.
Generation of DDL statements to create RDBMS structures in the target relational database.
Analysis tools for (1) determining which alphanumeric ADABAS fields should be mapped to “VARCHAR” RDBMS columns, (2) analyzing which ADABAS descriptors are candidates for an RDBMS primary key or alternate index, and (3) analyzing the physical characteristics of ADABAS PE and MU fields to determine the kind of RDBMS structures to which they should be mapped.
tRelationalPC GUI interface for modeling and mapping.

Support for Treehouse Software’s Data Propagation System (DPS)

tRelational produces all parameters required by DPS to perform materialization (initial loading) and propagation (ongoing synchronization) of data from ADABAS to the RDBMS.

No Need to Type Existing RDBMS Schema Elements by Hand!

The new "ODBC Import" function makes it even easier for a site to import existing RDBMS schema into tRelationalPC (no need to type in those Tables, Columns, and Constraints by hand). A simple drag and drop procedure is then all that is required for the creation of ADABAS-to-RDBMS mappings.

Compatibility

tRelational is available for mainframe ADABAS / NATURAL sites, including users of MVS, VM, VSE, and BS2000. Supported target RDBMSs include Microsoft SQL Server, ORACLE, Sybase, IBM's DB2. and NCR Teradata. Future support for other RDBMS products will be based on customer needs.

"tRelational and DPS are the tools that allowed us to reach our goals in a pragmatic and non-invasive way."

     -Roberto Licandro
      IT Architectures
      B-Source SA

tRelationalPC GUI Interface

Sample tRelationalPC Screen - tRelationalPC is the gui interface for tRelational, and ADABAS relational modeling, mapping, and analysis tool

The data modeling and mapping functions in tRelational are also provided in a user-friendly environment (GUI). This remote Windows-based client offers an instantly familiar, ERD-like layout for creation and maintenance of RDBMS data models and mappings of ADABAS fields to RDBMS columns.

DPS and tRelational Interactive Web Site

Visit the tRelational /DPS section of the Treehouse Software Web site devoted to our ADABAS-to-RDBMS solution. You can view Flash demonstrations of ADABAS File Implementation, ADABAS Data Analysis, Auto Generation of Normalized Tables for an ADABAS File, Output Generation, Data Propagation System (DPS) - Materialization, Data Propagation System (DPS) - Propagation, and much more.

tRelational and DPS Literature Available On-line:

DPS FactSheet (English) DPS FactSheet (German) tRelational FactSheet (English) tRelational FactSheet (German) tRelational/DPS Product Overview tRelational/DPS Getting Started Guide	tRelational/DPS Presentation

Contact Treehouse Today!

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

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

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