1 / 30

The Mainframe Data Access & Replication Conundrum In Today's Heterogeneous IT Environment

The Mainframe Data Access & Replication Conundrum In Today's Heterogeneous IT Environment. Mainframe Integration without Compromise. Agenda. Introduction to Treehouse Software Today ’ s Situation IT Objective tcACCESS Data Integration tcACCESS SQL Engine tcACCESS Demo tcVISION

cais
Download Presentation

The Mainframe Data Access & Replication Conundrum In Today's Heterogeneous IT Environment

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

  1. The Mainframe Data Access & Replication Conundrum In Today's Heterogeneous IT Environment

  2. Mainframe Integration without Compromise

  3. Agenda • Introduction to Treehouse Software • Today’s Situation • IT Objective • tcACCESS • Data Integration • tcACCESS SQL Engine • tcACCESS Demo • tcVISION • Data Replication • CDC Methods • Processing Stages • tcVISION Demo • Summary

  4. Introduction to Treehouse Software Established in 1982 Mainframe system tools vendor Leading ISV for Software AG 70% penetration in North American market Consultants with20+ years experience More than 300 man years of experience Supporting all mainframe operating systems Focus for the past 15+ years on data migration, replication, and integration Over 700 customers worldwide 20 products 30 employees

  5. Treehouse Customers

  6. Today’s Situation • Heterogeneous IT environments • Legacy applications • High-availability information systems • Data silos • Increasing data volumes • Exploding costs

  7. IT Objective Enterprise-wide Data Management through: • Intelligentdata integration • Efficient data synchronization • Cost effectivesolution

  8. Enterprise Data Integration tcACCESS Concepts • Bi-directional data-exchange across heterogeneous systems • Direct data access across heterogeneous systems • Data transformation for data analysis and exchange

  9. Enterprise Data Integration tcACCESS Concepts • Relational access to legacy data and applications • Data federation – heterogeneous data views • Integration of mainframe files and DBMS structures • Data federation between mainframe and Windows/Open Systems data

  10. tcACCESS SQL Engine Host/PC & Host & Web Integration

  11. tcACCESS SQL Engine • More than 90 SQL functions supported • Operators (+, -, *, /, ||) • Conditional Operators (>, <, =, BETWEEN, LIKE) • Logic Operators (AND, OR) • INNER and OUTER JOINS • GROUP BY, ORDER BY • Security may be applied (RACF, ACF/2, Top Secret) • Stored Procedure Support

  12. tcACCESS SQL Engine • Different data sources can be JOINed:SELECT IMS.NR, IMS.NAME, VSAM.ADDRESS FROM IMS, VSAM WHERE IMS.NR = VSAM.ID • VIEWS can be created • Control Options available (MAXIO, MAXROW, NOORDERBY, etc) • Global SQL Exit available • Field Level Exits available

  13. tcACCESS Architecture

  14. Demo

  15. Different data formats Different data models Large data volumes Limited batch window Requirement for up-to-date information Moving/replicating data... as much as needed as little... as transparent... as flexible... as secure... ...AS POSSIBLE CDC Replication The Problem: TheSolution: ...with

  16. Data Latency Change Data Capture

  17. Change Data Capture Data volume

  18. Mainframe Change Data Capture Change Data Capture • Efficient transfer of entire databases • Analysis for data consistancy • Best for Initial Load prior to log processing • Best for periodic mass data transfer • One step data transfer

  19. Mainframe Change Data Capture Change Data Capture • Comparison of data snapshots • Efficient transfer of changed data since last processing • IMS/DB, DL/I, VSAM, DB/2, ADABAS, CA-IDMS, DATACOM, sequential files • Flexible processing options (SORT etc.) • Automatic creation of deltas by tcVISION

  20. Mainframe Change Data Capture Change Data Capture • Usage of the DBMS logging capabilities • IMS/DB, VSAM, DB/2, DL/I, ADABAS, IDMS, DATACOM • Transfer of changed data in scheduled time frame • Best for batch window • Best for processing right after logfile creation

  21. Mainframe Change Data Capture Change Data Capture • Realtime capture of changed data • Changes directly obtained from DBMS • CA-IDMS, IMS/DB, VSAM, DB/2, DATACOM, ADABAS • Secure data storage even across DBMS restart • Flexible propagation methods

  22. Staged Processing Stage 3: Data in DML or Loader format Stage 2:Data normalized with structure definition Stage 1:Data in tcVISION format (before and after images) Stage 0:Data in internal raw format

  23. Staged Processing Stage 3: Data in DML or Loader format Exit pointsavailable at every stage Stage 2:Data normalized with structure definition Stage 1:Data in tcVISION format (before and after images) Stage 0:Data in internal raw format

  24. Demo

  25. Summary tcACCESS • Relational access to legacydata and applications • Data Federation – heterogeneous data views • Change Data Processing • Bi-Directional real time replication tcACCESS tcVISION tcVISION

  26. Summary tcVISION Architecture

  27. Summary Bi-directional data-integration and data-synchronization

  28. E-mail: sales@treehouse.com

More Related