Welcome to our Oracle Replication Resources Page
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:
- 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!
Datasheet: 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.
Case Study: Teach for America — Database Migration
How Teach for America used HVR for Database Migration with Minimal Downtime
About: Teach for America is a not-for-profit organization dedicated to ensuring that all children have access to an excellent education. It puts high-achieving young people into under-resourced, struggling schools with the aim of changing students’ lives for the better and producing civically minded leaders. Today, the organization has more than 55,000 corps members and alumni and has reached millions of students across 53 regions of the United States. Teach for America relies heavily on its website to recruit prospective teachers. Prospective teachers use the site as a portal to obtain information about the program and apply to it. So, when the time came to migrate the Oracle database that supported the website to Microsoft SQL Server, the organization needed to minimize downtime. The IT team relied on HVR to simplify and speed this database migration process.
- Migrate production database from Oracle to SQL Server with minimal downtime
- SQL Server
- Database Migration
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.
- Minimize possible downtime of the business critical IT service systems.
- Implement a data warehouse for real-time data reporting.
- Hot Standby
- Data Warehouse
Case Study: United States Coast Guard
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.
- 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
- Database Replication
- Real-time Analytics
- High Availability
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.
- Handling data loads as network coverage increased
- Providing BI solutions group real-time information
- SQL Server
- Database Replication
- Real-time reporting
Case Study: Epsilon Marketing – High Volume Data Movement from Oracle to SQL Server
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
Use Case: Distributed replication
Case Study: Royal Dutch PostNL
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.
- 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
- Data Migration to the Cloud
- Ongoing Intercloud Cloud Data Integration
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 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.
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 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, GE and CapitalOne have publicly come out with their intentions to shift very…
- What versions of Oracle Database does HVR support?
- Oracle Database 9.2 and above are supported by HVR.
- What edition of the Oracle Database does HVR support?
- HVR supports all editions of the Oracle Database, i.e. Express Edition, Standard Edition, Standard Edition One, and Enterprise Edition.
- Does HVR support Oracle RAC (Real Application Clusters) and ASM (Automatic Storage Manager)?
- Yes, HVR supports all combinations of versions and editions, clustered and non-clustered, with the many options to store database files.
- Does HVR support Oracle Exadata as a source and target?
- Yes, from HVR’s perspective Oracle Exadata is an Oracle RAC on Linux environment.
- What operating systems does HVR support for Oracle Capture and integration?
- Linux, Windows, Solaris, AIX and HP-UX, both on physical and virtual environments.
- How does HVR connect to the Oracle Database?
- HVR relies on Oracle Client libraries to connect to the Oracle Database, and to ASM if it is used. To establish the connection HVR requires access to Oracle Client libraries. With that HVR supports connections to a local database and remote connections using Oracle’s TNS. For a RAC environment a connection can be made through the SCAN listener.
- Can HVR be set up to be highly available in an Oracle RAC environment?
- Yes, HVR services can be enrolled in Oracle Clusterware in order to be highly available in a RAC environment.
- Does HVR support pluggable databases?
- Yes, HVR can be used for log-based change data capture from and delivery into pluggable databases, as well as of course traditional non-pluggable database.
- How does HVR perform transactional data capture from the Oracle Database?
- HVR directly accesses the Oracle Database transaction logs on the file system, including when the data resides in ASM. In rare cases HVR may (transparently) retrieve data from the database using an SQL statement.
- Does HVR support Oracle Transparent Data Encryption?
- Yes, HVR integrates with the Oracle Wallet and supports all flavors of Transparent Data Encryption in Oracle.
- Do I have to install HVR on the Oracle Database server(s)?
- For optimum performance, HVR recommends a local installation on the Oracle Database server. However, depending on the setup, there are options for remote capture on a different server running the same operating system using remote TNS connects, or file sharing e.g. using NFS. HVR also supports a so-called archive log only mode to run capture on a different server that does not run any database processing.
- What are the minimum requirements to run HVR on an Oracle Database?
- At the database level the DBA must enable minimal supplemental logging using an alter database statement. In addition, HVR will create supplemental log groups on all tables that will be replicated in order to capture at least the primary key columns for updates. The HVR solution connects to the database using a database user account with elevated privileges.
- Can HVR run change data capture on a standby database?
- Yes, HVR can run directly on a data guard physical standby database. The physical standby can be an active standby database but doesn’t have to be. Note that for the initial load (so-called refresh in HVR) HVR will have to run against the primary database if the standby is not open for read-only. Also, supplemental logging has to be enabled on the primary database.
- Does HVR provide an archive log only capture mode?
- Yes, HVR can be run on a separate server (or virtual machine) in an archive log only mode with archives copied to the server or made accessible through a file share. Note the operating system on the capture machine must match the database operating system, and supplemental logging has to be enabled through a connection to the actual source database. Also, the initial load has to be performed directly from the source database.
- How does HVR ensure that no changes are lost when capturing from an Oracle Database?
- On the capture side HVR will position a capture process, per thread, to a position in the transaction log based on the initialization time. From the starting point forward HVR will capture any changes against the tables that are part of the setup. Following the initial positioning the capture process keeps track of the log sequence number of the oldest open transaction it was tracking, and the relative byte address within that. If the capture is restarted for whatever reason then HVR simply goes back to the point in the logs where it left off when it last checkpointed. This type of recovery is fundamental to HVR. On the integration side, HVR uses a state table to ensure recoverability. As part of every transaction HVR applies to the target database it will process an update to the state table. In case of any interruptions, HVR will rely on the state table in the destination database, and the fact that Oracle performs transactional processing, to ensure not change are lost and changes are not applied more than once.
- Does HVR support active/active replication between multiple Oracle Databases?
- Yes, by default HVR will not capture changes applied by HVR, and with that setting up active/active replication is straightforward. A quick video on how to setup active/active replication on Oracle is here: https://www.hvr-software.com/resource/setup-multi-active-active-environment/
- What Oracle data types does HVR support?
- HVR supports almost all scalar data types through log-based change data capture, including large objects (CLOB, NCLOB and BLOB). Data types that are not natively supported (including XML data types, Spatial and user-defined data types) can typically be included in the replication using a capture expression to retrieve the data through a SQL expression.
- Does HVR support DDL replication out of an Oracle Database?
- Yes, HVR supports DDL replication but only DDL against tables, and changes to the primary key. Other DDL like secondary indexes, triggers, and DDL related to the creation of other database objects like PL/SQL stored objects, data types, users, tablespaces etc. is ignored. With the changes captured HVR supports delivery of the DDL changes in a heterogeneous environment i.e. against any of the supported targets, even if there are transformations in the setup.
- What database objects does HVR replicate?
- At present HVR only supports tables and their primary keys, and database sequences. Any other database objects are ignored during replication.
- Can HVR capture changes from a view?
- No, changes to the view are recorded against the underlying tables that make up the view definition. In order to capture changes against a view you should replicate the underlying tables, and re-create the view on the target database. HVR does support replication of changes against a materialized view given the materialized view is implemented using its own table.
- Why would I use HVR instead of Oracle Data Guard?
- Oracle Data Guard is included with the Enterprise Edition Database, providing a disaster recovery solution for the Oracle Database. With that an Oracle Data Guard standby database – in physical standby mode which is the most commonly used mode – has to be the same version of the source database. Also, the entire database is replicated and there is no flexibility for any transformations, or to replicate only one schema or a subset of the tables from the database. However all database objects are duplicated. The Data Guard destination database is however closed for DML and unless the extra-paid option for Active Data Guard is in place there is not even read-only access on the destination database. HVR on the other hand provides logical database replication with the ability to filter tables, columns and even rows, as well as the ability to deliver changes in a heterogeneous environment. The target database for data replication is always open for DML and DDL, so for example any requirement to implement a custom indexing strategy can be implemented on the HVR target database. Also, HVR is not restricted to the Enterprise Edition database but also supports all other Oracle Database editions.
- Why would I use HVR instead of Oracle GoldenGate?
- Oracle GoldenGate is Oracle’s data replication technology. It is a very powerful data replication solution similar to HVR’s that comes at a significant cost. Recent versions of Oracle GoldenGate use integrated components in the database which means that bug fixes or enhancements often require a database patch. With similar Change Data Capture capabilities and richer support for heterogeneous environments, HVR is generally more cost-effective than Oracle GoldenGate. In addition, the HVR solution provides powerful capabilities to perform table creation (in a heterogeneous environment), initial data load (again heterogeneously), compare/repair, as well as a graphical user interface an automatic monitoring, all in a single user-interface. Oracle provides products for data integration and management, but they are all different, not necessarily integrated but separately priced, tools and options (Data Integrator for heterogeneous initial loads, Veridata for compare/repair, Enterprise Manager plugin for graphical monitoring, and GoldenGate Studio for a GUI on top of Oracle GoldenGate).
- Can I filter tables when replicating from the Oracle Database?
- Yes, HVR can be set up to replicate a subset of the tables from the Oracle Database. Even better, per table a subset of the columns can be replicated, and even a subset of the rows can be replicated. In addition, extra columns can be defined with values populated during the replication.