Technology Solutions

Stelo + IBM Informix

Stelo helps you connect data from Informix

Stelo’s vendor-agnostic data replication and migration technology is a responsive, agile solution that supports IBM Informix, a log-based reader. Informix can handle vast amounts of data, but extracting that data for downstream processing can burden already highly loaded production systems.

Stelo is the most resilient, robust, and efficient solution for offloading source data into other applications and can keep up with the high-volume online transaction processing (OLTP) requirements. Easily replicate millions of transactions per hour and transfer data sets over 1TB.

We can bridge all source and destination types for every user, so you can move data from Informix to anywhere. Stelo is a cost-efficient, low-impact, real-time data replication software for connecting data systems. Experience enterprise power without the enterprise cost.

Related Resources

TECHNICAL DATA SHEET →

QUICK START GUIDE →

GETTING INFORMIX READY FOR DELTA LAKES →

SCHEDULE A DEMO

Connects To

Stelo Star Icon_Centered_Green Expertise

IBM Replication Experts

Stelo is supported by experts who know your system, not generalists who may not understand data replication.

IBM-specific features include:

  • Remote Journal support
  • Multi-member support
  • Support for Minimize Entry Data (MINENTDTA) and (*AFTER)

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.

 Time and Labor Icon_Noun 4636078_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.

Stelo Creates Real-Time Data Reporting and Inventory Management for E-Commerce

Top Notch Distributors offers over half a million residential and commercial electronic access control products, parts, and accessories from more than 60 manufacturers. The company has an SQL-based website with sales, inventory and business data residing on an IBM iSeries with ERP software. However, Top Notch needed real-time data to power the e-commerce store without using iSeries resources and adding extra system load. Stelo now seamlessly moves data into SQL reporting tools that populate a dynamic e-store with up-to-the-second inventory and provides all departments with access to the information they most need.

Stelo delivered the following results:

  • Site traffic doubled and e-commerce sales from their online store increased dramatically
  • The IT team reduced time spent on reporting and data issues by 10-20%
  • Employees gained instantaneous data access to save time on checking inventory levels to process orders
READ THE CASE STUDY

FAQ

Do you support my replication pairing?

The short answer is yes.

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 over thirty 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 in to any specific database platforms.

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

IBM Db2 databases can generate large datasets, but Stelo can handle large-scale data 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. 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 software coexist with high availability products? If so, which ones?

Yes, Stelo uses only standard IBM i commands and APIs to interact with the journal receiver and will not interfere with other applications. We have numerous customers using Stelo’s software with high availability (HA) products such as Vision Solutions MIMIX, IBM DataMirror, IBM Infosphere CDC, Trader's QUICK-EDD, and MaxAVA HA. The main issue customers have is deciding if they want to use *AFTER only imaging; this decision forces Stelo’s software to be exposed to reorganization.

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

Futureproofing Your Data Management Strategy with NoSQL and Data Streaming
Futureproofing Your Data Management Strategy with NoSQL and Data Streaming

Futureproofing Your Data Management Strategy with NoSQL and Data Streaming

Oct 31, 2024 12:12:35 PM 2 min read
How Stelo V6.3 Helps You Master Data Integration
How Stelo V6.3 Helps You Master Data Integration

How Stelo V6.3 Helps You Master Data Integration

Nov 28, 2023 7:45:00 AM 2 min read
Sunsetting: What to Do When Your Data Replication Tool is No Longer Supported
Sunsetting: What to Do When Your Data Replication Tool is No Longer Supported

Sunsetting: What to Do When Your Data Replication Tool is No Longer Supported

Aug 29, 2023 8:46:34 AM 3 min read
Unboxing Stelo V6.1: MERGE Support
MERGE Support

Unboxing Stelo V6.1: MERGE Support

Apr 25, 2023 10:03:00 AM 4 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

Try Stelo

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