CONNX for SQL Server®
CONNX for SQL Server® 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.
Join SQL Server with multiple data sources
SQL & CONNX for SQL Server
CONNX supports the creation of views, which facilitate hiding table relationships from the end user. CONNX Views facilitate the creation of heterogeneous joins between multiple disparate databases.
CONNX supports more than 600 data types and performs bi-directional data conversions for data updates and retrieves.
Security preserved and extended
The CONNX Data Dictionary (CDD) is encrypted to secure sensitive information. It provides additional field and table-level security by group or user, ensuring information is protected. CONNX also supports row level security with CONNX Views.