Oracle Replication

Welcome to our Oracle Replication Resources

We have compiled our Oracle Replication related resources so that you can easily find more information about how to integrate data to or from an Oracle Database to wide range of sources and targets. Have questions?


One this page you will find:

  • Data Sheet
    • HVR’s Oracle Database Support
  • Customer Stories
    • United States Coast Guard
    • Atos
    • Royal Dutch PostNL
    • Mobicom
    • Epsilon Marketing
    • Nigerian Federal Inland Revenue Services

  • Videos
    • Demo: Real-Time Data Delivery from an Oracle Database
    • Demo: Real-Time Business Intelligence – Oracle to Teradata and Greenplum
    • Demo: Oracle Replication to SQL Server
  • Oracle Replication Blog Posts
    • Oracle Data Replication
    • Data Replication Between MSSQL and Oracle
    • Cloud Data Migration
  • Have questions? Join our Live Demo to Learn More!


    Data Sheet: HVR’s Oracle Database Support

    HVR’s support for the Oracle Database as a source for change data capture, and as a target for data delivery.

    The Oracle Database is one of the most commonly used databases, running some of the world’s most demanding and mission-critical workloads. The Oracle Database is a common data source for analytical environments and data lakes. This data sheet describes HVR’s support for the Oracle Database as a source for change data capture, and as a target for data delivery.


    Datasheet_Oracle_Database_Support

    Customer Stories

    Case Study: United States Coast Guard

    continuous real-time data integration

    How the USCG used HVR to offload reporting and reduce latency

    About: The United States Coast Guard (USCG) is one of the country’s five armed services. In times of peace, USCG operates as part of the Department of Homeland Security, serving as the nation’s front-line agency for enforcing laws at sea, protecting the coastline and ports, and saving lives. When the nation is at war or on direction of the President, USCG serves under the Navy Department. USCG uses HVR to replicate data in real-time from the production system it uses to maintain its fleet of aircraft to a second database for use in reporting.

    Challenge:

    • While enabling real-time analytics, minimize impact of reports running against the production system
    • Needed a real-time replication technology to keep reporting and production systems in-sync

    Databases: 

    • Oracle
    • Ingres

    Use Case:

    • Database Replication
    • Real-time Analytics
    • High Availability

    Case Study: Atos – Hot Standby and Data Warehouse

    About: Atos runs a highly successful business, managing outsourced IT services—everything from data centers, server farms and network communication systems to local PCs, software applications and printers. In addition to performing functions such as managing software licenses and delivering help desk support, Atos also helps large companies roll out new software or software upgrades to thousands of employees worldwide.

    Challenge:

    • Minimize possible downtime of the business critical IT service systems.
    • Implement a data warehouse for real-time data reporting.

    Databases:

    • Oracle
    • Ingres

    Use Case:

    • Hot Standby
    • Data Warehouse


    continuous real-time data integration

    Case Study: Royal Dutch PostNL

    continuous real-time data integration

    How HVR enables a 100% Cloud Organization

    About: PostNL offers mail, parcel and e-commerce products and services in the Netherlands, United Kingdom, Germany, and Italy.

    Challenge: 

    • Reduce costs to create a competitive advantage by replacing on-premises data centers with cloud infrastructure.
    • Migrate applications, data and IT infrastructure to the cloud.
    • Enable on-going intercloud integration

    Databases/ Systems: Oracle, SQL Server, Azure, Amazon EC2

    Use Cases:

    • Data Migration to the Cloud
    • Ongoing Intercloud Cloud Data Integration

    Case Study: Mobicom – Offload Data from Oracle to SQL Server

    How a Growing Telecom Company leveraged HVR to Manage a Growing Customer Network

    About: MobiCom Corporation (Mongolian: Мобиком Корпораци) is the largest mobile phone operator in Mongolia. Established in 1996, MobiCom pioneered mobile technology in Mongolia where it today has 33 percent of the mobile service market. MobiCom has been pivotal in transforming Mongolia’s economy by providing essential telecommunication services including long distance and local telephone services, facsimile services, TV and public card payphones, internet services, and prepaid card services.

    Challenge:

    • Handling data loads as network coverage increased
    • Providing BI solutions group real-time information

    Databases:

    • Oracle
    • SQL Server

    Use Case:

    • Database Replication
    • Real-time reporting


    real-time data integration

    Case Study: Epsilon Marketing – High Volume Data Movement from Oracle to SQL Server


    real-time data replication

    About: Epsilon Marketing is a U.S.-based marketing services company that uses engagement and direct response marketing to lead its clients’ customers through the purchase funnel. Epsilon’s goal is to help its clients deliver the right message at the right time to the right prospect. It has succeeded in this approach by analyzing up-to-date and accurate customer data to gain customer intelligence.

    Challenge: Real-Time Data Replication Between Oracle Production Databases and Microsoft SQL Server-Based Data Warehouse

    Databases: Oracle and MS SQL Server

    Use Case: Real-Time Data Replication

    Case Study: Nigerian Federal Inland Revenue Service

    About: Real-time replication: Founded in 1943, the Nigerian Federal Inland Revenue Service (FIRS) is responsible for assessing, collecting and accounting for the various taxes owed to the Nigerian government. With its population of 162 million people, Nigeria is divided into 37 separate tax districts, spread over almost one million square kilometers and has around 800,000 registered taxpayers. For a Revenue Collection agency like FIRS, quality service delivery and accurate tax information is critical to success

    Challenge: Real-time data replication across 37 distributed tax regions

    Database: Oracle

    Use Case: Distributed replication



    real-time data replication

    Videos

    Real-Time Data Delivery from an Oracle Database

    This 2014 video shows HVR delivering data real-time from an Oracle database into ActianVector, to speed up reporting with Tableau. Without loosing the real-time aspect, reporting is sped up by several orders of magnitude. Setup is quick and easy

    Video: Real-Time Business Intelligence – Oracle to Teradata and Greenplum

    This video shows data loading from an Oracle source into Greenplum AND Teradata simultaneously using HVR. HVR loads data in real-time at high speed into both environments without causing load on the Oracle source. HVR supports both Change Data Capture and initial data load.

    Video: Oracle Replication to SQL Server

    This recorded demonstration shows HVR Software’s data integration solution. The demo starts with software download and all the way through installation to getting a first working real-time replication scenario setup between an Oracle source database and a SQL Server destination.

     

     

    Oracle Replication Blog Posts

    Oracle Replication Data

    Oracle Data Replication

    The Oracle Database is one of the most commonly used databases, running some of the world’s most demanding and mission-critical workloads. The Oracle Database is a common data source for analytical environments and data lakes.

    This post describes HVR’s support for the Oracle Database as a source for change data capture, and as a target for data delivery.

    Oracle Data Replication in Real TIme

    Data Replication Between MSSQL and Oracle

    We thought that, instead of writing about some deeply technical issue in this blog, we would answer a couple of the first questions that we get asked by prospective new customers. Those questions are “What are your most common use-cases?” and “Why wouldn’t we just use Microsoft’s or Oracle’s solutions…

    Cloud Data Oracle Replication

    Cloud Data Migration

    Organizations large and small are adopting the cloud. With security in the cloud having come a long way, and as data center servers are up for renewal, organizations choose the cloud to host their applications, databases, and file system. Recently large organization including AT&T[1], GE and CapitalOne[2] have publicly come out with their intentions to shift very…

    © 2018 HVR

    Live Demo Contact Us