Event Replicator for Adabas Replicating Data Across the Enterprise

1
Event Replicator for AdabasReplicating Data
Across the Enterprise

• Mark Braukhoff
• Senior Systems Engineer
• Software AG Denver
• Mark.Braukhoff_at_softwareagusa.com

2
Product Portfolio
Open Standard Access
Data Replication Distribution
Database Administration
Productivity and Performance Products
Event Replicator for Adabas
SQL Gateway
Adabas Manager
Delta Save
Adabas Vista
Adabas Online Systems
SOA Gateway
Cluster Services
Adabas Review
Parallel Services
Fastpath
Adabas Statistic Facility
Adabas Base Technology Adabas v8.1 - Mainframe
(z/OS, VSE, z/OS.e, VM, BS2000, MSP) Adabas v5.1
UNIX, Linux, OpenVMS and Windows
Mainframe platforms only
3
Event Replicator for Adabas Replication Scenarios

• Disaster Recovery
• Replication of Adabas data from place to place,
  in entirety
• Provides for Real-Time hot-standby environment
• Data Warehousing
• Supports business analysis needs with Real-Time
  Adabas data
• Supplying Adabas data to a single target, such as
  a Data Warehouse, which may be combined with data
  from other sources
• Resource Optimization
• Replication of a single Adabas source to one or
  more targets, making local copies of centralized
  data.
• Supports business users without impacting
  production
• Adabas SQL Gateway customers can utilize this
• Data Synchronization
• Support Operational Systems by supplying Adabas
  data to subscribing applications/data stores
• Delivering Adabas data Real-Time to Any Target in
  Any Format

4
What is Event Replicator for Adabas?
Event-Driven Information Distribution Platform
Disaster Recovery
Resource Optimization
Data Synchronization
Data Warehouse
Event Driven Architecture (EDA)
Event Replicator for Adabas
MAPPING
PUSH
FILTER
SUBSCRIBE
MQ/EntireX
SQL
Adabas
DB2
Oracle
Other
5
Event Replicator for AdabasArchitecture Overview
6
Event Replicator for AdabasArchitecture Overview
7
Event Replicator for AdabasArchitecture Overview
8
Event Replicator for AdabasArchitecture Overview
9
Event Replicator for AdabasArchitecture Overview
10
Event Replicator for AdabasArchitecture Overview
11
Event Replicator for AdabasArchitecture Overview
ODBC
12
Event Replicator for Adabas Unique Capabilities

• Data Capture Processing
• Immediate Access to COMMITTED Transactions (ET)
• Meta Data oriented for subscriber
• Deals with all transaction types (insert,
  update, delete)
• Fully recoverable
• User defined recovery process
• Asynchronous Processing
• Supports multi-update nucleus environments

13
Event Replicator for Adabas Unique Capabilities

• Special Transaction Handling
• Back out processing
• Transaction consolidation for efficiency
• Maintain transaction chronology
• File decompression
• User specified transformation filtering for
  the recipient system

14
Event Replicator for Adabas Unique Capabilities

• Fine-Grained Change Data Capture Processing
• User defined subscription based transaction
  replication
• Entire database or selected files
• User-definable to field level for target
• Initial State (Bi-directional)
• Replication Audit at Subscription level to
  ensure system health
• Replication transaction monitoring

15
Event Replicator for Adabas
16
Giving You a Competitive AdvantageWhat Event
Replicator for Adabas offers

• Real-time solution
• Supports business demands
• Minimizes system resource usage
• Subscription mapping is integrated with message
  queues (EntireX, MQ Series)
• Helps in persistence and recovery
• Plug into any applications without having to
  mess with application infrastructure
• Opens the data up to non-database targets (i.e.
  mobile, PDAs)
• Transform replicated data into XML format to
  support web services and SOA
• Integrated with Adabas Nucleus
• Smooth upgrades as new versions of Adabas come
  out
• Ability to only send selected data
• Only send committed data conserving resource
  usage
• Hide the complexity of replicated environment
• Use familiar Adabas functionality to remotely
  administer replicated environment
• Automate data models to a replicate to a
  different model target
• Supports most Adabas utilities
• ADALOD LOAD/UPDATE, ADADBS REFRESH/NEWFIELD, etc

17
Giving You a Competitive AdvantageWhat Event
Replicator for Adabas offers

• Lower System Costsbecause we only publish what
  you ask for
• Ability to publish discrete data elements and
  selected contents unlike CDC-based products which
  replicate at the table level and must process the
  entire Protection Log (PLOG) record
• Low volume of data published means lower system
  costs

18
Competitive Advantage What Event Replicator for
Adabas offers

• Seamless integrationbecause Software AG builds
  Adabas
• Event Replicator is designed in tandem with other
  SAG products which means that
• System upgrades will be seamless
• Administration is simpler
• The customer can have complete confidence in
  their Software AG environment, both now and in
  the future

19
Giving You a Competitive Advantage What Event
Replicator for Adabas offers

• Information when and where you need itNO delays
• Can send changes anywhere you need it
• Adabas, DB2, Oracle, Sybase, MS SQLServer, MySQL,
  etc
• Event Replicator for Adabas offers Real-Time
  replication unlike other solutions which are PLOG
  dependent and require additional filtering or
  data steps downstream before you get the
  information
• Real-time data means accurate information for
  business decision making and customer service
  the more business-critical the application the
  more important this capability

20
Competitive Advantage What Event Replicator for
Adabas offers

• High performance regardless of your Adabas
  workload
• Unlike other solutions, the Event Replicator
  works in very high-transaction environments
  because the Replication Server is a separate
  instance of Adabas
• This means performance demands will be met,
  ensuring business productivity

21
Adabas Big Picture - Proven Performance
Enterprise-wide Interoperability
Application
Java
.NET
3GL
Natural
Cross-platform
Tamino XML Server
Data Management
Administration
Data Access
Text Retrieval
SQL
Java
XML
SOA
Security
Cluster
External e.g. RACF

• Availability
• Load Balancing

Monitoring
Performance

• Partitioning
• Save/Restore

Data Organization
Statistics
Windows, Unix. Linux, Mainframe
Utilities

• Replication
• Transaction

Data Distribution
VSAM
DL/1
DB2
Apps
22
Software AG. Bright ideas, everywhere.