CONNX Data access and virtualization

Meet all of your data access and virtualization requirements whether you are seeking to plug into mainframe, legacy, mid-tier, big data or cloud systems. With the widest range of database connectors in the industry, we can help you integrate data sources in real time and create a single view across multiple distributed databases so you can make living connections. By simplifying data access, CONNX DB Adapters preserve and enhance database systems by providing heterogeneous, secure and real-time access to disparate databases through a single platform. This means that disparate data sources can be treated as one federated relational database to enable a fluid flow of data, and help give your business the power to see, decide, act—and thrive.  

Unlike Extract, Transform and Load (ETL) processes, your data remains in place while your user is given real-time access to the source data system. This reduces the risk of data errors and reduces the workload of moving data around that may never be used.

• Access all of your data sources with standard SQL, including legacy and non-relational systems
• Deliver your data integration projects in less time and with lower costs
• Ensure secure access to sensitive data
• Preserve full control and flexibility using metadata management
• Make better decisions by leveraging all of your data
• Respond faster with access to a fluid flow of real-time data
• Leverage one technology to connect to more than 150 data sources, such as data warehouses, business intelligence tools, big data, cloud, and digital platforms

150+ data connectors

CONNX provides standard SQL connectivity to a wide spectrum of databases (legacy, relational, big data and cloud) residing on platforms, such as mainframe, HP^® OpenVMS, iSeries (AS/400), UNIX^®, Linux^®, Windows^® and the desktop.

Standard support

CONNX DB Adapters provide read/write SQL data access supporting ODBC, OLE DB, JDBC^®, J2EE^® and .NET^® technologies.

Metadata management

Through metadata management, you create a lexicon that combines all your data into a single, comprehensible structure without altering the source structures.

SQL-based virtualization

Consume real-time data from multiple enterprise data sources in a single virtual view.

Secure access

CONNX Security is ideally suited to handle cross-platform security issues by managing multiple database logins and secure access to the data in each system.

Data movement and migration

Enhance the CONNX platform by adding data movement and migration capabilities that allow you to share and transform data among all connected data systems.

Data synchronization and replication

Add data synchronization and replication capabilities to replicate data in real time without the need to run SQL queries. Data will be replicated automatically whenever a change is detected in the source system.

• Adabas
• Amazon^® Redshift
• C-ISAM®
• DataFlex^®
• Hadoop®
• IBM DB2^®
• IMS™
• MariaDB
• Microsoft Azure^®
• MySQL^®
• Oracle^®
• SQL Server^®
• Sybase^®
• Teradata^®
• VSAM™
• PostgreSQL or EnterpriseDB
• Rdb
• IBM^® Informix^®
• RMS
• And more

CONNX will help you to access and virtualize your data wherever it is needed. Whether you want to access legacy data, relational databases or new data systems (such as big data or the cloud) CONNX is your platform of choice. The platform can easily be extended for data movement, migration, synchronization and replication. 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 that your business can make living connections that matter.