When Oracle Streams came out in Oracle 9i, it seemed that the Oracle world was about to change. Oracle had replication products beforehand. There was Oracle Replication in Oracle 8 and Advanced Replication since Oracle 7.3.4. DBAs had longed for easy ways to replicate data from one database to another. Setting up database links and using materialized views (“snapshots” at the time) was cumbersome and had many limitations. They wanted data in another database but didn’t want to wait for daily or even weekly batch jobs. Oracle Streams was their answer.
Originally Streams was only in the Enterprise Edition of Oracle, but in later years it was supported in Standard Edition, although there were a few minor caveats. Oracle Streams allowed users to set up replication to another database without waiting for a batch window. In many ways, it was a game-changer. The fact that Oracle Streams did not come with an additional fee was also a welcome feature.
Oracle Streams was enhanced as the years went by. There was even an option to allow users to set up an Oracle Gateway to replicate data to non-Oracle databases. Not many people did this because it was difficult to set up and there were many limitations. But it seemed to be a direction that Oracle was moving to, allowing heterogeneous database replication.
Oracle customers were looking forward to future releases of Oracle Streams when Oracle Corporation shocked the computing world and purchased GoldenGate Corporation. GoldenGate was rapidly becoming the leader in heterogeneous database replication. What would Oracle do with two replication products? Oracle released a document stating that Oracle Streams “will continue to be supported, but will not be actively enhanced.”
When Oracle released the Oracle 12c database it announced the deprecation of Oracle Streams.
When Oracle 19c was released, Streams was de-supported and customers were encouraged to start using Oracle GoldenGate.
What are Oracle Streams customers to do? Naturally, Oracle preferred that Streams users move to Oracle GoldenGate. But the world has evolved. Not all replication is Oracle to Oracle. More and more enterprise companies need a solution that provides heterogeneous database replication from on-premise platforms to the cloud (and back) and non-database targets such as Kafka, Hadoop, and file replication.
HVR, with its unique distributed architecture, is a perfect solution for Oracle Streams customers looking for a modern replication solution. As an all-in-one solution, HVR supports Oracle to Oracle in addition to heterogeneous replication between a variety of on-premise and cloud-based platforms.
With HVR, you set-up once and deploy often. This means that once DBA teams are comfortable with HVR running their Oracle replication, they can turn to HVR to move data from their other databases. As a result, customers can standardize data sources within one tool rather than many disparate replication technologies.
Since HVR is built for the cloud, it is the perfect solution for those looking for an Oracle replication tool now that Oracle Streams is no longer supported. If you’re interested in seeing it action, we invite you to Test Drive HVR.