Agenda About us GoldenGate Customer use cases: Business Benefits - PowerPoint PPT Presentation

Agenda About us GoldenGate Customer use cases: Business Benefits

About us 7 years on the market, over 20 clients Oracle Gold Partner, high level of specialization ( GoldenGate, ODI, IaaS ) First certification (and currently one of several) in Oracle GoldenGate in the world; 1 of 5 partners in the Oracle Cloud Solution Program 2017-2018 Oracle Consulting Partner in Poland Main areas of competence: Migration | Integration | Data replication GO Monitor - Oracle GoldenGate monitoring Data processing and reporting | DWH Data Automation of business processes (BPM) Consulting and training

Our Clients

Oracle GoldenGate

Oracle GoldenGate Online data transformations • High-performance, low- Oracle GoldenGate Cloud impact real-time data Log-based Change Data Capture integration and and Delivery replication Apps Active-Active Replication • Timely data for improved Heterogeneous Source and Targets business insight Database • Continuous availability Reliability and Transaction Integrity for 24/7 operation Big Data Java Integration, Real-time Events Transformations on-the-fly

Real-Time Replication – use cases Upgrade/ Zerodowntime migration HA Online test environments Test ENV High Availability / Disaster Cloud Recovery Reporting Query & reportoffloading databsae Realtime T ransformation Replication Data Realtime BI,Operational Warehouse reporting Databases Cloud Data Synchronization withinthe Enterprise / Cloud BigData Flat files / JMS JMS Event Driven Architecture,SOA

GoldenGate for Cloud Exadata Cloud Service Virtual Machine Database Cloud Service Autonomous DB Bare Metal Database Cloud OCI Object Storage OCI Streaming Service

Oracle GoldenGate Use Cases

Insurance company Real-time replication for DataWarehouse InsuranceData CENTRAL real-time E-Bussiness Suite DA T A Replication Applications T ransformation WAREHOUSE Vindication Consistency

Insurance company Real-time replication for DataWarehouse Delivery of two Oracle Exadata Database Machine X7-2 and Oracle ZFS ZS5-2 database platforms plus initial configuration of systems Delivery of Oracle software (including Oracle GoldenGate) Comprehensive deployment of online replication to the Central Data Warehouse using Oracle GoldenGate Benefits of implementing Oracle GoldenGate replication Loading to the Central Data Warehouse takes place in real time Transformations - tables are modified during replication to fit reporting model Audit mode – tracking of every DML activity on source systems Consolidation of various databases, schemas, tables in one place Offloading of operational databases The ability to launch new services accessing online data

Real-time ODS Implementation forBank CENTRAL BANKING SYSTEM CREDITCARDS OPERATIONS real-time ODS replication transformation CRM

Real-time ODS Implementation forBank Project goal was to build single, central ODS database with data delivered in real-time from all banking systems. All workload for providing operational reports are moved to new ODS database. New bank e-services are being build on top of ODS database. Every operation that takes place in source transactional systems is immediately replicated and transformed to new structure of ODS database. Benefits of implementing Oracle GoldenGatereplication Creation of the new cross platform ODS layer with real time data used for online reporting and the new online banking system ODS provides complete and valid data consolidated from all source systems – Oracle and MSSQL Data are delivered and transformed to new data structure New data model in ODS fits the needs for new application layer Report are updated on the fly as data appears

Data Grid Implementation for Bank Consolidation of bank databases in in-memory solution real-time Replication

Data Grid Implementation for Bank Consolidation of bank databases in in-memory solution The project goal was to build new data layer for the CRM system which needs to access cross platform data with lowest possible delay. Databases are too slow to deliver data instantly, so data layer was build on a farm of servers that created so-called Memory DataGrid (Oracle Coherence) Such architecture requires technology to deliver data in real-time from all heterogonous transactional systems to Oracle Coherence DataGrid – Oracle GoldenGate is able to do that. Benefits of implementing Oracle GoldenGate replication and Oracle Coherence DataGrid Significant simplification of processes obtaining client data. Information is always available in one central repository – data refreshed in 2 sec Consolidation of several dozen different Oracle databases, MS SQL Server, IBM DB2, Informix (various versions, operating systems, hardware platforms) The CRM application cache is build on top of Oracle Coherence – all data is kept in the memory, no database access DataGrid cache provides object replication on its own (distributed hashing) The average response time for query is 1sec, minimal query time is 0,2 sec!!!

No-downtime Upgrade databases from Oracle v11 to v12 for leader on the fuel market in Central Europe real-time replication real-time consistencycheck

No-downtime Upgrade databases from Oracle v11 to v12 leader on the fuel market in Central Europe Migration bunch of SAP Oracle DB environments to a new hardware platform and upgrading the database version. Zero downtime migration as critical succes criteria Benefits of implementing Oracle GoldenGatereplication Database migration (largest one was 30 TB) from the old platform to the new one without any database downtime During migration process, the source databases were normally and heavily loaded (transactions within the head office and data from all gas stations). GoldenGate did not generate additional overhead The Oracle Veridata tool used for consistency check to be sure everything is in place With help of monitoring for replication processes – application migration done when replication lag was minimal

International online payment operator - architecture RealTime replication power up the Big Data Tune Replication LAG environment in Germany from 8 sec to ~ 1.2 sec The source real-time replication databases are in Bulgaria

Real-Time Fraud Detection International online payment operator GoldenGate is used to replicate data in real time to big data cluster (via JMS) Data flows from Bulgaria (data from credit cards payments) to Germany (Hadoop cluster) Fraud detection and online reporting takes place on the Big Data environment – implemented as streaming analytics. Consolidation of dozens of databases in one place Benefits of implementing Oracle GoldenGate replication Replication lag from Bulgaria to Germany is approximately 1.2 seconds!!! Replication from transactional database to Hadoop / JMS (Kafka) / HDFS

Real-Time Business Benefits real-time data replications for: sales data analysis, online estimation of the amount of necessary bank reserves to submit/declare to e.g. NBP online analysis of cross-sale for marketing campaigns, a customer applies for a loan having 100k$ funds, then the bank can offer better conditions real-time analysis of frauds for creating anti-frauds architecture delivering data for of online reporting systems, providing updated reports, eliminating or reducing ETL night processing, giving free resources and reduces the risk of failure

Real-Time Business Benefits creating test environments with online data anonymization, simplifies the management of test environments and their refreshment building "mirrors" that offloads of production environments zero down-time DBA operations on databases upgrades, migrations which ensure the continuity of business operations real-time data replication between data centers, providing the Active-Active model real-time data replication for creating DRC architecture

THANK YOU! www.goldenore.pl

CONTACT US Tomasz Dac COO E-mail: tomasz.dac@goldenore.pl mobile: +48 502281379 Łukasz Słoma Account Manager E-mail: lukasz.sloma@goldenore.pl mobile: +48 513 089 662 GOLDENORE Sp. z o.o. Sp. K. Aleje Jerozolimskie 154, 02-326 Warszawa, Poland www.goldenore.pl