Generix
telephone +44 (0) 1924 500 151
products
evaluation
faq
support
contact
news
solutions
home
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
    overview
    architecture
    details
    case studies
    info request
    e-Vantage
    KEA!
    nu/TPU
    TeVISTA
    C-ISAM
    D-ISAM
    DataFlex
    DataSync
    DB2
    Desktop Adapter
    OLEDB Adapter
    infonaut
    informix
    microfocus
    Oracle
    DBMS
    Rdb
    powerflex
    RMS
    SQL
    Sybase
    VSAM