- Количество слайдов: 32
About Insession Technologies • • Division of Transaction Systems Architects Sister company of ACI Worldwide International provider of mission critical solutions In business since 1975 More than 770 customers in 71 countries Primary offices in USA, UK, Singapore, Australia Exclusive sales/marketing for Golden. Gate since 1996 A Division of Transaction Systems Architects, Inc.
Quick Facts about Golden. Gate • Founded in 1995 • Headquarters located in Sausalito, California • More than 175 customers in industries including: Stock Trading, Banking, Manufacturing, Telecommunications, Media/Cable, Healthcare and Retail • More than 1, 400 licenses in 20 countries worldwide • Support centers in North America, Europe and Asia A Division of Transaction Systems Architects, Inc.
Golden. Gate User Examples … Bank Of America Sabre Bombay Stock Exchange Bank One “Major US Retailer” Pay. Point Data Synchronization = Business Optimization A Division of Transaction Systems Architects, Inc.
Golden. Gate Delivers … A Single Software Platform that enables sub-second capture and secure delivery of large volumes of changing data across diverse environments Data Synchronization = Business Optimization A Division of Transaction Systems Architects, Inc.
Golden. Gate Supported Environments Databas e • Enscribe OS • • HP-NSS Unix NT OS/390 AS/400 Linux Stratus • • • SQL/MP Oracle DB 2 MS SQL Teradata Times. Ten Informix Sybase My. SQL IMS/VSAM ODBC compliant Flexible Implementation and Use A Division of Transaction Systems Architects, Inc.
Golden. Gate Capabilities Moves – Application Integration – Data Marts – Data Warehouse Migrates – Application – Operating System – Application Management Transforms – Operational Data Stores – Business Intelligence – Analytics – Business Activity Monitoring Replicates – Disaster Recovery – Business Continuity – Business Assurance Delivering Data / Application Synchronization A Division of Transaction Systems Architects, Inc.
Capture / Delivery Components HP NS-Server Intercept Library/Logger Capture Manager Application Intercept Library Capture Manager Delivery Network Queue Logger • Uses Intercept Library • Captures writes / deletes • File renames / creates, etc Source D/B Log trail Target D/B • Bind library into application • TMF not required anywhere • Compress Updates A Division of Transaction Systems Architects, Inc.
Capture / Delivery Components Log Based Capture Source D/B (HP- NS Server, Oracle, DB 2, Sybase) Manager Capture Delivery Network Queue • • Transaction Log High performance Low system impact • Decoupled asynchronous processing • Real-time • Data filtering / modification • User exits Target D/B A Division of Transaction Systems Architects, Inc.
Golden. Gate Topologies One-to-One One-to-Many Source Target Transparent To Your Needs A Division of Transaction Systems Architects, Inc.
Golden. Gate Topologies Cascade Source Many-to-One Source Target Sub-Tier Targets Transparent To Your Needs A Division of Transaction Systems Architects, Inc.
Golden. Gate Technology Advantages • Capture only changes through logs or intercepts • Native database access • Processes Bulk, Control and DDL operations • Automatic filtering, transformation and mapping • Use queues for decoupling / flexibility • Parallel processing architecture • Optimize available network bandwidth • 128 -bit Data Encryption and SSL Authentication Technology Leader A Division of Transaction Systems Architects, Inc.
Syncfile Module • Monitor non-DB file modifications • Replicate files to target system based on parameters • Invoke macro to extend functionality • Complimentary product for DR Implementations • Define groups of files for different requirements of replication • Flexible scheduling A Division of Transaction Systems Architects, Inc.
Golden. Gate Topologies Bi-Directional Synchronization Peer-to-Peer Source / Target Transaction Log Capture Delivery LAN / WAN / Internet Queue Target / Source Queue Transparent To Your Needs A Division of Transaction Systems Architects, Inc.
Bank of America – BASE 24 ATM Network Base 24 Bi-Directional Base 24 Customer • 14, 000 ATM Network Hot Backup Site • Fraud Detection Base 24 Kansas City Data Center • Hot-site Back-up Data Center captures data from 4 HP NSK throughout North America • Synchronizing thousands of transactions per second, millions per day Customer Base 24 Customer 100% ATM Uptime A Division of Transaction Systems Architects, Inc.
Phased Deployment with Golden. Gate • Migration from the HP Non. Stop Himalaya K-Series to the new S-Series - accomplished without system degradation or downtime • Business Continuance / Disaster Recovery brought in-house using bi-direction synchronization from Golden. Gate • BASE 24 release 5. 3 to 6. 0 bi-directional replication • Mimic production conditions to test new applications prior to go-live • Future: • Synchronize data across multiple platforms to accommodate an increasingly heterogeneous computing environment • Provide integration capabilities that could handle increasing volumes on the bank's ATM/POS network A Division of Transaction Systems Architects, Inc.
Network Diversity NW • CAF • PUF • Scoring MF • ACHD SF PRO 9 Router Driven by SF Router Driven by LA Drive n by TX Driven by LA Drive n by VA Router VA PRO 1 Router SF MVS Sync VA MVS KC Interchange Networks Sync Interchange Networks: • American • • • Stores Host. Link Interlink Pay. Point Plus Star VISA Driven by SF Driven by LA LA PRO 7 Router LA PRO 7 • DPS • Pulse • Honor • Shazam • ITS • VISA • Plus Driven by VA Driven by TX Router LA MVS • CAF • PUF • Scoring MF • ACHD • CAF • PUF • Scoring MF Router Driven by SF Drive n by VA Drive n by TX TX MVS Router TX PRO 5 • CAF • PUF • Scoring MF A Division of Transaction Systems Architects, Inc.
BASE 24 Integration ACI’s recommended solution … • • 80+ BASE 24 Customers Worldwide 3 BASE 24 specific modules Transaction Warehouse for Payments Manager Bi-directional support for dual site processing • BASE 24 installed at GG in Sausalito • BASE 24 resources on staff at GG • Solutions in production world wide A Division of Transaction Systems Architects, Inc.
Golden. Gate BASE 24 Modules Golden. Gate for BASE 24 provides efficient, non-intrusive means for capturing thousands of database operations per second. Add-on Modules include: • M 24 – Zero Downtime Application Migrations: - ATM and POS operations continue uninterrupted while the 5. x to 6. 0 upgrade occurs - Original system functions as normal while Golden. Gate for BASE 24 captures, transforms and queues all transactions that occur during the migration • E 24 - Close the Batch Window: - BASE 24 Super Extract enhancement - Automatically captures and delivers BASE 24 transactions in real-time to settlement systems - Transforms data from HP/Enscribe to Oracle, SQL, Sybase & Others • N 24 - Eliminate Labor Intensive work: - Automates the processes for optimizing load sharing, implementing bi-directional replication and establishing BASE 24 backup sites - Emulates BASE 24 notification processing on the target system, allowing bi-directional refreshes to complete properly without manual intervention A Division of Transaction Systems Architects, Inc.
Case Study - SABRE 30+ Unix My. SQL Servers Golden. Gate 6 HP NSS Primary nodes RDF RDF 6 HP NSS Backup nodes • Application integration • Data encryption • Continuous availability • Network compression • Data transformation and selectivity • Broadcast transmissions A Division of Transaction Systems Architects, Inc.
Case Study – Bombay Stock Exchange • Purpose: Surveillance System Firewall Production System TCP/IP S 74016 Non. Stop SQL IBM Infinity Windows 2000 MS-SQL Server Data Mart System HP-Unix Sybase TCP/IP Backup System S 74016 Non. Stop SQL – Hot Site Backup – Data Mart for Decision Maker – Data Feeding for Broadcasting • TMF Application • No. of Transactions: – Normal: ~200 TPS – Peak: ~600 TPS • Data Volume: – Normal: 58 MB/hour – Peak: 180 MB/hour • Lag Time: – Production to Backup: <1 s – Production to Data Mart: 1~2 s – Production to Surveillance: 1~2 s • CPU Cost for ER in Production: – 3~15% of Overall Utilization A Division of Transaction Systems Architects, Inc.
Bank One – Migration/Dual Site Migration K 20, 000 Phase I Hot Site Backup S 72, 000 Removed Phase II Bi-direction replication (same database) A Division of Transaction Systems Architects, Inc.
Case Study – Major US Retailer S 72, 000 OLTP System POS/Teller machines from 300 Stores S 72, 000 ODS System Transformation Sun Oracle Warehouse System RS 6000 Planning • Application Integration • ZLE “lite” Windows 2000/Access Buyer System Reporting A Division of Transaction Systems Architects, Inc.
Case Study – Paypoint Eastern US devices Western US devices A Division of Transaction Systems Architects, Inc.
Processing Applications DB Audit Database Changes* AUDSERV Committed Changes Only Extract Files (on Tandem) Selected Audit Returned SQL Table Initial Data* (Selective Scan) Data to Distribute GGS Log Table EXTRACT Custom Transformations, Selectivity, etc. TCP/IP (blocked) Optionally formatted in Replicator, ASCII, BCP, SQL* Loader or other format Committed Changes Only Table, Row, Column Selection and Mapping Specs Parameters and Checkpoints User Exit Routines (optional) Extract Collector Extract Files (Tandem, IBM, NT or UNIX) *Per run, either Initial data or Changes are processed, not both. A Division of Transaction Systems Architects, Inc.
Processing Non-TMF Applications Enscribe Database Applications Programs Enscribe Changes GGSLIB Run-Time Library Enscribe Changes GGS LOGGER Third party applications, Load utilities, etc. Initial Synchronization Processing GGS EXTRACT Data Distribution NS SQL Enscribe Tandem, Oracle, SQL Server… Change Processing GGS LOG Trails GGS REPLICAT (Tandem, UNIX, Windows) Tandem-to-Tandem only TARGET DATABASE A Division of Transaction Systems Architects, Inc.
Replicator Processing Source Data Definitions NS SQL, Enscribe Tandem Replication: via dynamic SQL and Guardian operations Extract, Log Files REPLICAT Table, Row, Column Selections And Mapping Specs Oracle, Sybase, DB 2 Oracle and Sybase Replication on UNIX, NT Replicator for ODBC Database operations recreated, automatic data conversions ODBC Driver (third party) Checkpoints and Parameters SQL Server, etc. on NT Proprietary A Division of Transaction Systems Architects, Inc.
Golden. Gate Update - Version 7 Features… • Oracle blob support. • Mapping to stored procedures. • Conflict detection/resolution – This is an enhancement that will allow a comparison of the before and after image (selectable to columns or fields). • Wildcard for Oracle tables. • Integrated load process – Enhanced load processing that removes the need to stage the data in a flat file. • Propagation of Oracle DDL operations – Create and drop table. • Sybase log capture. • T 24 – Full support for all B 24 tokenized data. Coming Soon…. . • Configuration GUI. • Oracle RAC support. • IMS capture. A Division of Transaction Systems Architects, Inc.
Golden. Gate Activity Console § Graphical Dashboard of desired data activity § Event Based Management Approach § Browser-Based Interface § Configurable Watch lists A Division of Transaction Systems Architects, Inc.
Activity Console – Benefits • Consolidated View of System Health • Rapid Notification of Critical Events • Non-intrusive Polling Mechanism • Accessible • Customizable • Easy to Install and Easy to Use A Division of Transaction Systems Architects, Inc.
Activity Console – Cross Platform • Integrated editor • Syntax check • Online configuration • All platforms A Division of Transaction Systems Architects, Inc.
Question & Answer Session … Any questions regarding : Data Synchronization = Business Optimization A Division of Transaction Systems Architects, Inc.