1 / 48

ADABAS to RDBMS

koko
Download Presentation

ADABAS to RDBMS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


    2. Agenda The Problem and the Options Concepts of ADABAS-to-RDBMS Replication A Brief History of ADABAS-to-RDBMS Replication DPSync: How It Works Points of Distinction Customer Benefits Summary: Ask the Difficult Questions

    3. The Problem

    4. The Options

    5. The Replication Requirements Continuum

    8. Analysis and RDBMS Design Tools Extraction, Transformation, and Load (ETL) Facilities Real-Time Interception and Delivery of Changes Sophisticated and Complex Transformations (from ADABAS to RDBMS structures and data), Including Transforming PEs and MUs to Child and Grandchild Tables Application of the Updates, RDBMS Error Notification, and Recovery Special Functions (e.g., Synchronized Backups and Restores) Console Facilities for Statistics and Operations

    9. Robustness of features Ease of implementation, including no requirement for custom-developed software Ease of operation (i.e., procedures for running synchronized backups/restores, handling errors, etc.) Ease of maintenance (software and metadata) Performance, including any impact on the production ADABAS system and use of ADASAV and high-speed RDBMS loaders Reliability -- software maturity Data integrity, including guarantees that all the changes will be replicated, in their original sequence, without duplicates, and without any lost data Scalability and Deployment Options An End-to-End Solution

    10. A Brief History of ADABAS-to-RDBMS Replication Software

    11. History of ADABAS-to-RDBMS Replication Software A innovator in ADABAS replication software for over 12 years From 1995 to 2007 our products have been used in the analysis, design, implementation and maintenance of ADABAS-to-RDBMS replication processes We have listened to the needs of ADABAS customers, and for the last decade we have supplied software for ADABAS replication for data warehouses and other applications

    12. History of ADABAS-to-RDBMS Replication Software An understanding of the needs of real customers An awareness of the technical pitfalls Robust features, as a result of 6 incremental releases of the product Broad Array of Target Platforms: Oracle, DB2, Sybase, SQL Server, UNIX, z/OS, Windows A mature, stable and reliable software product

    14. DPSync How It Works

    15. DPSync – How It Works

    16. Analyze actual ADABAS data content Generate, view and modify system-recommended RDBMS schemata Select an RDBMS schema Modify the schema Define conversion processes Map ADABAS files/fields to RDBMS tables/columns Result generates the DPSync Metadata and RDBMS DDL statements Intuitive interactive user interfaces, including GUI DPSync – How It Works

    17. ADABAS File Analysis

    18. ADABAS File Analysis

    19. ADABAS File Analysis

    20. RDBMS Modeling and Mapping

    21. DPSync – How It Works

    22. DPSync – How It Works

    23. DPSync – How It Works

    24. DPSync – How It Works

    34. Two Ways to Load the Initial RDBMS

    35. Flawed Method For Loading the Initial RDBMS

    36. Flaws In “Live Data Extracts”

    38. Two Ways to Handle Lost Data

    39. Flawed Process for Handling Lost Data

    40. DPSync: Guarantee No Lost Data

    41. DPSync: Notification of and Recovery From RDBMS Errors

    42. DPSync: Ease of Implementation

    46. Customer Benefits A product, not a consulting engagement No impact on the production ADABAS system Cost-effective implementation Time-proven vendor commitment to ADABAS-to-RDBMS Replication Software Over of 11 years of product evolution, from a company with over 30 years of ADABAS experience

    47. ADABAS-to-RDBMS Replication

    48. Summary: Ask The Difficult Questions

More Related