OpenLink Data Access Driver for  Microsoft SQL Server

Secure and High-Performance ODBC,
JDBC, ADO.NET, and OLE DB Drivers

Data Access drivers for Microsoft SQL Server

Our Data Access drivers for Microsoft SQL Server offer the following benefits:

 
featureID
feature
featureLabel
featureSynopsis
benefitID
benefitLabel
benefitSynopsis
Database mirroring compatibility
Provides developer with DBMS server topology flexibility
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
Multiple Active Result Sets (MARS)
Enables applications developers to work concurrently against multiple query result sets
Controlled Access to Data Assets
Controlled Access to Data Assets prevents unauthorised changes
SSL Support
Secure data transmission between applications and DBMS server
Controlled Access to Data Assets
Controlled Access to Data Assets prevents unauthorised changes
Single Sign On including Windows NTL Mv2
Single Sign-On (including Windows NTLMv2 authentication support). Reduces data costs for administrators, developers, and end-users
Cost Savings
Reducing costs of deployment
Snapshot transaction isolation level
Enabling additional transaction isolation granularity to application developers.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
XML and Native Large Value data types support
Provides developers with increased range of data types for developing new-generation applications.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
Zero Config based Auto-Discovery of instances
Zero Config based Auto-Discovery of SQL Server instances across local area networks Simplifies configuration and administration of database connections
Ease of Integration
Ease of integration speeds deployment and enhances utility
Wire Protocol Based Driver
The use of the TDS wire-protocol facilitates direct connectivity from Driver to Database Server. This alleviates the need to install any additional client side networking software as part of the driver installation and configuration process
Ease of Integration
Ease of integration speeds deployment and enhances utility
 

Driver Architectures

OpenLink Software providers drivers to connect to Microsoft SQL Server in the following architectures:

 

Application that includes in-built network connectivity [i.e., RDBMS independent client and server components] with regards to RDBMS connectivity.

Multi-Tier Architecture

format
featureID
featureLabel
featureSynopsis
benefitID
benefitLabel
benefitSynopsis
Connection Pooling
Enables efficient management of resources associated with database sessions
Controlled Access to Data Assets
Controlled Access to Data Assets prevents unauthorised changes
Database mirroring compatibility
Provides developer with DBMS server topology flexibility
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
Deferred Fetching of Blob Data
The SQLGetData() and SQLPutData() ODBC API implementations have been significantly enhanced to provide intelligent handling of BLOB data. This facilitates transferring parameter data in parts over the network between the Enterprise Edition (Multi-Tier) Generic Client and Database Agents. Once transferred, the fragmented column data is reassembled in its entirety within the Client and/or Agent parts of the Enterprise Edition (Multi-Tier) driver (depending on if this is an insert or retrieval). This feature applies to data types such as SQL_LONGVARCHAR, SQL_WLONGVARCHAR, SQL_LONGVARBINARY, BLOB, and CLOB.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
Multiple Active Result Sets (MARS)
Enables applications developers to work concurrently against multiple query result sets
Controlled Access to Data Assets
Controlled Access to Data Assets prevents unauthorised changes
Multithreading support
Enables development, deployment, and use of multithreaded client applications.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
Reference Cursors Support in Stored Procedures
Support for advanced DBMS Server functionality.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
SSL Support
Secure data transmission between applications and DBMS server
Controlled Access to Data Assets
Controlled Access to Data Assets prevents unauthorised changes
Snapshot transaction isolation level
Enabling additional transaction isolation granularity to application developers.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
Support for Serial Data Type
Provides application developers with access to last serial values for a given table.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
Transaction Isolation Levels configuration
User-level configuration of Transaction Isolation Levels. Transaction Isolation levels are optionally configurable as part of the DBMS connection configuration.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
Transaction Isolation mode discovery
Enables developers to determine if DBMS instance is transactional or non-transactional.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
XML and Native Large Value data types support
Provides developers with increased range of data types for developing new-generation applications.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
 

Client Application that depends on external networking services e.g., those provided by an RDBMS sever application in regards to database connectivity

Single-Tier Architecture

format
featureID
featureLabel
featureSynopsis
benefitID
benefitLabel
benefitSynopsis
Connection Pooling
Enables efficient management of resources associated with database sessions
Controlled Access to Data Assets
Controlled Access to Data Assets prevents unauthorised changes
Database mirroring compatibility
Provides developer with DBMS server topology flexibility
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
Deferred Fetching of Blob Data
The SQLGetData() and SQLPutData() ODBC API implementations have been significantly enhanced to provide intelligent handling of BLOB data. This facilitates transferring parameter data in parts over the network between the Enterprise Edition (Multi-Tier) Generic Client and Database Agents. Once transferred, the fragmented column data is reassembled in its entirety within the Client and/or Agent parts of the Enterprise Edition (Multi-Tier) driver (depending on if this is an insert or retrieval). This feature applies to data types such as SQL_LONGVARCHAR, SQL_WLONGVARCHAR, SQL_LONGVARBINARY, BLOB, and CLOB.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
Multiple Active Result Sets (MARS)
Enables applications developers to work concurrently against multiple query result sets
Controlled Access to Data Assets
Controlled Access to Data Assets prevents unauthorised changes
Multithreading support
Enables development, deployment, and use of multithreaded client applications.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
Reference Cursors Support in Stored Procedures
Support for advanced DBMS Server functionality.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
SSL Support
Secure data transmission between applications and DBMS server
Controlled Access to Data Assets
Controlled Access to Data Assets prevents unauthorised changes
Snapshot transaction isolation level
Enabling additional transaction isolation granularity to application developers.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
Support for Serial Data Type
Provides application developers with access to last serial values for a given table.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
Transaction Isolation Levels configuration
User-level configuration of Transaction Isolation Levels. Transaction Isolation levels are optionally configurable as part of the DBMS connection configuration.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
Transaction Isolation mode discovery
Enables developers to determine if DBMS instance is transactional or non-transactional.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality
XML and Native Large Value data types support
Provides developers with increased range of data types for developing new-generation applications.
Sophisticated Application Functionality
Supports data access, integration and management, from the simplest to the most sophisticated functionality