Keep your data fresh and up to date without impacting your data sources’ performance. With CONNX, you always provide a fluid flow of fresh data to keep your database, data warehouse, big data, and cloud systems current. It takes minimal effort and resources because you update only the records that have changed, eliminating the need for large, resource-intensive bulk data refreshes. Business today moves at incredible speed, so yours needs a fluid flow of fresh data to make meaningful, living connections. If you’re basing decisions on stale data, your business won’t have what it needs to see, decide, act, and thrive. There are two basic forms of data integration: real-time and near-real-time. Real-time data integration is just what it sounds like: it collects and aggregates data as soon as changes are made to the database. Real-time processing is for large volumes of data in constant motion where immediate integration is an imperative. Near real-time data integration occurs periodically. Data is collected immediately, but is not necessarily integrated instantly. Near real-time processing is when speed is important, but processing times of minutes are acceptable.
Key benefits
- Integrate data in real time or near real time
- Get up and running fast, within hours of connecting the source and target
- Capture changes from single or multiple data sources
- Reduce manual operation
- Preserve full control and flexibility using metadata management
- Provide security on multiple levels
- Quickly adapt to hybrid integration requirements
- One integrated platform that can be extended to data access, virtualization, and migration capabilities
CONNX will help you quickly synchronize and replicate data
Features
Real-time replication
Capture, transform, and replicate data from a selection of sources to multiple target data systems (such as databases, data warehouses, big data, cloud, and digital platforms). Keep your data up to date with a low-latency Change Data Capture (CDC) that incrementally updates only those records that have changed.
Near real-time synchronization
Scale your synchronization tasks based on demand—simply schedule updates for low-use periods, such as after normal business hours, or as frequently as every minute when your business requires more up-to-date information.
150+ data connectors
CONNX provides standard SQL connectivity to a wide spectrum of databases (legacy, relational, big data, and cloud) across platforms such as mainframe, OpenVMS, iSeries (AS/400), Linux®, Windows®, and desktop.
Advanced SQL Server® support
Simply add CONNX to Microsoft® SSIS to easily harvest changed data in the SQL Server database to perform efficient incremental updates.
Comprehensive transformation and ETL
Leverage SQL-based transformation with a graphical query builder that allows comprehensive mappings of tables and fields. In addition, a library of more than 100 transformation functions offers many ways to map a field’s value. This enables complex transformations, including filtering, sorting, joins, unions, and aggregations.
Metadata management
Through metadata management, you create a lexicon that combines all your data into a single, comprehensible structure without altering the source structures.
Secure access
CONNX Security is ideally suited to handle cross-platform security issues by managing multiple database logins and ensuring secure access to data across each system.
Get your data at work
CONNX will help you to synchronize and replicate your data wherever it is needed—in real time and in near real time. Whether you want to replicate to analytical systems (such as data warehouse, business intelligence, big data, or cloud) or to an application, CONNX is your platform of choice. And by integrating CONNX with a wide variety of Software AG solutions, your business can drive innovation from app to edge—faster than ever imagined. So go ahead and move trusted applications to the cloud. API-enable your apps. And ensure a fluid flow of data so your business can build lasting connections that matter.
Join the Software AG Tech Community
Collaborate with the CONNX community—and get tips and tricks, test code, and downloads—to help you extend your CONNX solutions into the future.
Browse our library of webinars
All of our webinars are available to watch on demand. Join mainframe modernization experts and analysts as they discuss, elaborate and demonstrate best practices.
CONNX Demo
Explore the capabilities of CONNX Demo for data access and integration. Transform your business with better data solutions.