CONNX for SQL Server and Azure - ODBC OLE DB JDBC .NET access, replication and synchronization

CONNX for SQL Server and Azure

The CONNX for SQL Server and Azure modules provide secure, real-time, read/write access to SQL Server and Azure data sources using ODBC OLE DB JDBC and .NET In conjunction with other CONNX modules, you can perform seamless joins between supported disparate data sources, SQL Server and Azure. For organisations that need cloud to cloud movement, we offer the ability to replicate and synchronize data from Azure to Azure.

With CONNX a single metadata model can be created that spans all enterprise data sources and applications requiring data access. The result is an enterprise-wide view of data that provides a reusable standards-based framework for information access.

CONNX DataSync Transformation Server integration with SQL Server SSIS

The CONNX SSIS CDC Connector enables SQL Server SSIS Packages to incrementally process data instead of performing a full “extract and load” each time the package is run.

This incremental processing of data – from virtually any data source:

Saves time – Incremental updates are faster than full loads

Allows the target to stay “live” 24/7

Removes the limitation of SSIS packages only running during a batch window

Enhanced Audit capability – Ability to track changes compared to full dump and load

The CONNX DataSync Transformation Server provides complete control of CDC processing from within SSIS. Choose either full CDC or just inserts and updates with no deletes.

CONNX DataSync and Azure

In conjunction with CONNX DataSync, SQL Azure data can be synced with on-premise data, or vice versa. Additionally, CONNX DataSync facilitates replicating and synchronizing data between two different SQL Azure data sources.

CONNX SUPPORTS
Azure, RMS, Oracle Rdb, VSAM, IMS, C-ISAM, D-ISAM, Micro Focus, DB2, Oracle, Oracle DBMS, Dataflex, POWERflex, SQL server and any OLEDB or ODBC data source.

CONNX is used by more than 3000 organisations world-wide to enable web/application development, data warehousing, business intelligence, ETL, replication, data synchronization, enhanced reporting and data migration.

Click the CD to request an evaluation and realise how your organisation can benefit from using CONNX