connx Generix
telephone +44 (0) 1924 500 151
products

evaluation

faq

support

contact

news

home

CONNX for SQL Server and Azure

CONNX 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 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

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

    CONNX InstantdbSync and SQL Server

    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.

    CONNX DataSync and Azure

    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.

  • overview

    architecture

    details

    case studies

    info request
    C-ISAM

    D-ISAM

    DataFlex

    DataSync

    DB2

    Desktop Adapter

    infonaut

    informix

    microfocus

    OLEDB Adapter

    Oracle

    DBMS

    Rdb

    powerflex

    RMS

    SQL

    Sybase

    VSAM