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 SSISThe 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:
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 AzureIn 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.
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.