E N D
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 HistoryofADABAS-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. DPSyncHow 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