|
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
The DataSync Transformation Server provides complete control of CDC processing from within SSIS. You can have either full CDC or just inserts and updates with no deletes.
The CONNX connection object is now a menu item within SSIS,
simplifying configuration.
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
|
|
|
CONNX for SQL Server Features:
|
|
Supported Versions of SQL Server
|
CONNX Supports SQL Server versions 2012, 2008 R2, 2008, 2005, 2000 and SQL Azure
|
|
Metadata information
|
Compatible with ANY
.NET, ODBC, OLE DB, or JDBC compliant Applications
|
|
Extensive Security
|
Protection to the field and record level. Encrypted metadata
secuirty.
|
|
Heterogeneous Views
|
Allows Heterogeneous Joins
|
|
Custom Data Type Conversion
|
Supports over 400 data type conversions, including BLOBs and CLOBs
|
|
Full SQL Support
|
Multithreaded Asynchronous Execution
|
|
Full Transaction Support
|
Perform inserts,
updates and deletes in a complete unit of work
|
|
Single sign-on reduces complexity
|
Provide transparent user access to multiple data sources
|
|
ANSI SQL Support
|
Compatible and
consistent queries to all databases
|
Java™ and WebSphereŽ support is native
|
Web integration
or enablement projects can quickly have direct access to SQL Server data.
|
|
Learn More
|
|
Data Sheet
|
Why You Need CONNX
|
|
CONNX Technology Paper
|
CONNX Scalability
|
|
Diagram
|
CONNX Product Architecture
|
|
Demonstration
|
Watch the CONNX Demo
|
|