Oracle Replication Resource Page
Oracle Replication Resource Page
Jump to: Oracle to SQL Server Replication Demo / Oracle Replication FAQs / Oracle Replication Case Study
Oracle to Oracle Replication
Video: 10 Minute Oracle Replication Demo
You think you have to use command-line only tools to set up Oracle to Oracle replication? Think again – not so with HVR!
This recorded demonstration shows real-time replication from a very busy Oracle system on Linux as the source, to Oracle on Windows as the target. The source system uses ASM to store database files which is transparent to HVR. Likewise, an Oracle RAC database, or Exadata system for that matter, would be equally straightforward to support for HVR. HVR performs all steps in this demonstration including DDL generation for the target tables, initial load and ongoing synchronization. And as a bonus the demo includes maintenance tasks and statistics.
Oracle to SQL Server Replication
Video: 10 Minute Oracle to SQL Server Replication Demo
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 FAQs
Customer Story: Oracle Replication
39 Geographically Distributed Oracle Databases
Challenge: Nigeria’s tax administration system – Standard Integrated Government Tax Administration System (SIGTAS) – is an integrated information system that automates the administration of taxes and licenses. Built by CRC Sogema in Canada, this software is designed to meet the needs of developing countries that wish to increase their control over state revenues. It is critical that FIRS keep information about taxpayers up-to-date and synchronized across all of Nigeria. Normally, one central tax database would be sufficient. But Nigeria’s large geographical distances and limited WAN infrastructure mean distributed databases are required.
On top of that, FIRS must deal with frequent power outages and slow, sometimes inaccessible wide area networks (WANs) connecting the different tax districts. To address these demands, FIRS installed a local SIGTAS database in each tax district. However, it needed to reflect changes of information in one tax district to the other districts in real-time to ensure a consistent and reliable tax system.
Solution: Bi-Directional Oracle Replication
Nigeria’s SIGTAS infrastructure consists of 39 Oracle databases spread over 37 tax districts. HVR’s bi-directional real-time data integration with collision resolution allows tax information to be shared instantly among all of Nigeria’s tax districts.
HVR was also used to set up a hot-standby database as part of the tax administration’s High Availability strategy. Because HVR’s management console delivers a single point of control, it streamlines the dataflow across all of the databases and tax districts managed by the SIGTAS system.
Result: High Resilience. Efficient Data Transmission across Oracle Databases
HVR is very resilient to connectivity and database availability issues. When power outages occur or network connections are temporarily broken, HVR simply picks up replication where it left off as soon as service is restored and systems become accessible. In addition, HVR provides extremely efficient data transport over Nigeria’s restricted WAN. The built-in compression and limited use of network round-trips makes HVR an ideal solution for FIRS’ geographical replication needs. Nigeria takes advantage of HVR’s hub and
spoke architecture option to ensure that the environment is easy to manage and maintain.
Need to replicate to and from Oracle from Other Sources?
The following are platforms HVR supports. Oracle is supported as a source and a target.
Source and Target | Target Only | |||
---|---|---|---|---|
Relational Databases | Oracle | PostgreSQL | Teradata | Redshift |
SQL Server | Ingres | Greenplum | XtremeData | |
Azure SQL | HANA | Vector | Azure SQL DW | |
DB2 LUW | Azure SQL | Matrix | ||
DB2 iSeries | Amazon RDS | |||
File Systems | Local | SharePoint | ||
(s)ftp | HDFS | |||
Amazon S3 | ||||
Other | Salesforce | Kafka | HBase | |
Hive | Hadoop |
Additional Resources:
Blog: Selecting the right Data Replication Software for Your Business
Product: Overview
Whitepaper: HVR Technical Whitepaper