The CONNX for SQL Server module provides secure, real-time, read/write access to SQL Server. In conjunction with other CONNX modules, you can perform seamless joins between two or more supported, disparate databases. 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.

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

The incremental processing of data - from 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 Audition capability - Ability to track changes compared to full dump and load

With CONNX for SQL Server, 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 supports over 400 data types, including BLOBs and CLOBs, and performs bi-directional data conversions for data updates and retrieves.

CONNX for SQL Server supports the creation of views, which facilitates hiding table relationships from the end user. CONNX views facilitates the creation of heterogeneous joins between multiple disparate databases.

Sales Info

To receive further product information or to order CONNX software please contact a CONNX Solutions sales representative by phone, fax, or electronically at:

888-88-CONNX (U.S.A. only)
425-519-6600
425-519-6601 fax
Request more information or a free software evaluation