CONNX Data access and virtualization
Integrate enterprise data everywhere on the ground and in the cloud—and use it in real time
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.
Key benefits
- 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
Features
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.
Simplified SQL data access to more than 150 data sources:
- 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