Technology Solutions

Stelo + Oracle

Stelo helps you connect data from Oracle

Oracle’s relational database products can process vast amounts of data but extracting that data for downstream processing can burden already highly loaded production systems. Stelo is a cost-efficient, low-impact, and real-time data replication software for Oracle data environments.

Over the last 30+ years, Stelo has evolved alongside databases like Oracle, allowing us to create the most resilient, robust, and efficient solution for offloading heterogeneous source data out of your Oracle database. Stelo’s vendor-agnostic data replication and migration technology is a responsive, agile solution that supports Oracle databases as both sources and destinations.

Stelo can connect all source and destination types for every database, so you can move data from Oracle to anywhere. Stelo also works seamlessly with Data Guard. Easily replicate millions of transactions per hour and transfer data sets over 1TB—without necessitating any production downtime to accommodate. Stelo also makes it easier to handle large JDE data sets.

Related Resources

TECHNICAL DATA SHEET →

QUICK START GUIDE →

HOW TO PERFORM ORACLE DATABASE REPLICATION →

SCHEDULE A DEMO

 

Connects To

Stelo Star Icon_Centered_Green Expertise

Oracle Replication Experts

The Stelo Strategy for Oracle Source Data Replication/CDC: Oracle versions up to 19c are supportable via LogMiner technology, for Oracle version 21c onwards, the XStream technology is recommended for CDC. We are authorized to bundle XStream’s high performance capabilities with Stelo. Other replication solutions have tried to copy or reverse engineer the Oracle log file formats, introducing more problems than it solves.

Flexible Deployment Icon_Noun 4351350_Green Customizable

Anywhere-to-Anywhere

Avoid vendor lock-in. Stelo uses heterogeneous replication for bi-directional support across all source and destination types. Our open-standards approach allows us to remain vendor-agnostic while providing highly flexible deployment models.

Rapid Deployment Icon_Noun 3967969_Green Quick Setup

Rapid Deployment

Streamline your deployment plan without costly delays. Stelo typically deploys in less than a day and cuts production time down from months to only weeks.

 Rapid Deployment Icon_Noun 3967969_Green Easy-to-Use

Set it and forget it

Simple installation with GUI interface, configuration wizard, and advanced tools makes product setup and operation straightforward, with no programming needed. Once running, Stelo reliably operates in the background without requiring dedicated engineering support to maintain and manage. Alter, add, and drop schema changes are replicated automatically.

Near-Zero Footprint Icon_Noun 1465960_Green Low Impact

Near-Zero Footprint

Our process provides ultra-low CPU load (less than 1% typical) to minimize production impact and avoid operational disruption. No source or destination software installation required. Only transfer data you need thanks to Dataset Partitioning.

Data Scalability Icon_Noun 1304652_Green Cost-Efficient

Unlimited Connections

A single instance can support multiple sources and destinations without additional licensing. The Stelo license model is independent of the number of cores to either the source or destination, so you only pay for the capacity required to support the transaction volume. Your data ecosystem can change over time without additional costs.

Automatic Restoration Icon_Noun 4647448_Green Reliable

Automatic Recovery

If a connection is broken, no data is lost. Stelo will automatically resume replication without needing to re-baseline in the event of a connectivity failure.

The Stelo Strategy for Oracle Source Data Replication and CDC

Oracle versions up to 19c are supportable via LogMiner technology, but for Oracle version 21c and onwards, the XStream technology is recommended for change data capture (CDC). This paper explains those changes, why they are happening, and what you should do about them.

Other replication solutions have tried to copy or reverse engineer the Oracle log file formats, introducing more problems than they solved. However, Stelo is delighted to partner with Oracle as an ISV and to distribute licenses for XStream use with Stelo, which enables:

  • Upwards of 50% increased performance throughput
  • Improved data security
  • Potential cost savings, especially for deployments with multiple destinations
DOWNLOAD THE WHITE PAPER

FAQ

How long does Stelo take to deploy?

Stelo is designed to make all deployment steps easy and straight forward with many automatic and automated procedures. You can choose which tables, rows, and columns you want to replicate, ensuring that data is replicated efficiently from one datatype to another without complex programing. A typical deployment has you up-and-running in hours, not days.

This is a key area where you can separate the wheat from the chaff. The best replication solutions deploy in under 24 hours. The worst require a week or more of configuration. Deployment time is also a good way to assess reliability. If the initial configuration is complex and time-consuming, you can expect stability and performance problems to arise in the future.

Baseline copies of data should not require more than 24 hours to create unless you are replicating an unusually large amount of data. If initial customizations take a lot of time upfront, you can expect similar lags when customizing in the future as well. High-performance software does not require much tweaking, and you should be wary of the reliability and accuracy of solutions that require extensive reprogramming.

Can Stelo handle high-volume requirements without breaking my bank?

Stelo can handle large-scale data transfers replication with sub-second latency. A single instance can support multiple sources and destinations without additional licensing. The Stelo model is independent of the number of cores of either the source or destination—so you only pay for the capacity required to support the transaction volume. connections. This cost-efficient method merges source data flows into one stream, and then it is applied to any number of subscribing destinations. Stelo delivers enterprise-level performance without enterprise-level cost.

Does Stelo use source resources?

Unlike trigger-based replication software that can consume quite a bit of production resources, Stelo is built to have a near-zero impact on production databases. It’s deployed on an intermediate server between the source and destination databases, resulting in virtually no resource drain on production infrastructure.

What is your Strategy for Oracle CDC in 19c and beyond?

Stelo’s longtime expertise with Oracle CDC continues to evolve. Our strategic use of the LogMiner API to achieve Oracle DB CDC for more than 20 years cut costs for Oracle/Stelo customers while delivering the best-in-class Data Replication solution, but when continuous mining was dropped from the LogMiner API in Oracle Version 19c, we needed to adapt.

Oracle versions up to 19c are supportable via LogMiner technology, for Oracle version 21c onwards, the XStream technology is recommended for CDC.

We are delighted to partner with Oracle as an independent software vendor (ISV) and to distribute licenses for XStream use with Stelo. Three key benefits include upwards of 50% increased performance throughput, improved data security, and potential cost savings, especially for deployments with multiple destinations. Other replication solutions have tried to copy or reverse engineer the Oracle log file formats, introducing more problems than it solves.

Support Features

Solutions Icon_Green

Accessible Support

Quick support is available for training, troubleshooting, version updates, and data replication architecture. 24/7 Urgent Incident Support is included in annual subscriptions.

Solutions Icon_Green

Highly Experienced Team

Stelo’s technologists have more than 30 years' experience developing reliable data software. Whether you need basic support or have a tricky technical challenge, we can work with you to solve any problem.

Solutions Icon_Green

End-to-End Proficiency

Our team has detailed knowledge of every data platform we support and can troubleshoot end-to-end replication pairing in heterogeneous environments to ensure the pairings are working properly.

Solutions Icon_Green

Constant Evolution

Unlike some other solutions, Stelo won't go out of date. New source and target types are continuously added through active updates to stay compatible with emerging market requirements.

The Latest from Our Blog

Understanding the Future of Data Ingestion by Exploring the Past
Understanding the Future of Data Ingestion by Exploring the Past

Understanding the Future of Data Ingestion by Exploring the Past

Nov 30, 2022 9:47:24 AM 3 min read
Strategies for Futureproofing Data Management

Strategies for Futureproofing Data Management

Nov 10, 2022 2:10:47 PM 1 min read
StarQuest Rebrands as Stelo: New Name, Same Stellar Solutions and Support
StarQuest Rebrands as Stelo: New Name, Same Stellar Solutions and Support

StarQuest Rebrands as Stelo: New Name, Same Stellar Solutions and Support

Oct 6, 2022 8:04:00 AM 1 min read
Evolving Your Data Management Strategy Beyond Data Warehousing

Evolving Your Data Management Strategy Beyond Data Warehousing

Aug 2, 2022 7:35:39 AM 2 min read

Get Started

These three steps will help you ensure Stelo works for your needs, then seamlessly deploy your solution.

1

Schedule a Demo

Our expert consultants will guide you through the functionality of Stelo, using your intended data stores.

2

Get a Free Trial

Test the full capability of the software in your own environment for 15 days. No obligations.

3

Go Live

When you're ready, we can deploy your Stelo instance in under 24 hours with no disruptions to your operations.

SCHEDULE A DEMO