Data Mirroring

Data mirroring involves copying data from one database to another to ensure consistency and availability across different locations. This process is typically used for data warehousing, business operations and to off-load reporting. Data streaming, on the other hand, is the continuous transfer of data from a source to a destination in real-time. It is commonly used for real-time analytics, monitoring, and feeding data into Artificial Intelligence applications.

Stelo takes full advantage of open standards such as DRDA, SQL, ODBC, and JDBC to maximize compatibility and interoperability within an enterprise network. We are an active member of The Open Group software industry consortium, which was responsible for the adoption of DRDA as an industry standard for database interoperability.          

Currently, Stelo supports more than 30 ODBC databases and our Kafka interface can also be used to communicate with cloud-based streaming services such as Azure Event Hubs for Kafka, the Oracle Cloud Infrastructure Streaming service, Amazon Managed Streaming for Apache Kafka, and IBM Event Streams. Stelo can also populate Azure Data Lake Storage Gen2 (ADLSg2) and similar NoSQL data repositories.

Stelo continues to use our open standards approach to ensure that we meet emerging replication requirements. We are continually adding support for new technologies while supporting legacy systems. Stelo is designed to grow with your organization rather than lock you into any specific database platforms.

Stelo gives you greater control by allowing you to choose replication of the data you want with both vertical and selected horizontal partitioning. Replace existing tables or merge on a row-by-row basis. Stelo also supports derived destination columns and data transformations, including automatic and customized conversion and selection of dates, views, indexes, and constraints. While flexible, Stelo fully enforces the enterprise security mechanisms by integrating with both SQL Server/Windows security and the native security of your Db2 system.

Unlike other replication software, there is no need to re-baseline in the event of a connectivity failure. In either a disaster scenario or planned downtime, all unaffected sources and destinations continue to be processed by Stelo. For the affected server or servers, Stelo checkpoints replication and will automatically restore replication as soon as connectivity is restored. This process is automated and requires no user intervention.

The key advantages of these two technologies include:

• Real-Time Processing: Data streaming allows for immediate processing and analysis of data as it arrives, enabling real-time insights and actions.
• Scalability: Streaming systems can handle large volumes of data in real-time, making them suitable for high-throughput applications.
• Flexibility: Data streaming supports a variety of data sources and destinations, allowing for more flexible integration with different systems and applications.
• Lower Latency: Since streaming processes data continuously, it reduces the latency between data generation and data processing, which is critical for time-sensitive applications.