CONNX for SQL Server and AzureCONNX for SQL Server and Azure 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 real-time replication from SQL Server, we offer the ability to replicate and synchronize SQL Server and to supported databases on-premise and in the cloud.
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 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:
CONNX DataSync provides complete control of CDC processing from within SSIS. Choose either full CDC or just inserts and updates with no deletes.
In conjunction with CONNX InstantdbSync, SQL Server can be replicated and synchronized in real-time from SQL Server to SQL Server and to supported databases on-premise and in the cloud.
In conjunction with CONNX DataSync, SQL Azure data can be replicated and synchronized with on-premise data, or vice versa.
Additionally, CONNX DataSync facilitates replicating and synchronizing data between two different SQL Azure data sources.