DataDirect Connectors Powerful SQL Server JDBC Driver

Microsoft_SQL_server
  • Bulk data movement increases performance without increasing costs
  • Significantly reduces the cost and time of deploying and maintaining applications
  • Single JAR for JDBC creates scalability and ease of deployments

Select your platform

Table of Contents:

    Features

    SQL Up Leveling/ Full ANSI SQL Support

    SQL up-leveling provides the capability to write a SQL statement that can be executed across multiple databases, regardless of the databases’ SQL implementation. For example, a SQL statement written against Oracle will also be interoperable with DB2.

    Encryption SSL 3.0, TLS 1.0, 1.1, 1.2 Compliant

    We keep our SSL version upto date. Upon identification of any security vulnerability, Progress will exercise commercially reasonable efforts to address the vulnerability in accordance with the following policy

    Performance Tuning

    Progress DataDirect management of packet-based network communication provides unsurpassed packet transport, network round trips and data buffering optimization. (socket management). Includes performance methodology for throughput and resource utillization (CPU/memory)

    TSANet Multi-Vendor Support Channel

    We live for your next big customer. Make sure your customers are successful with 24/7 partner support and access to expertise from our engineering teams, partnerships and leading technology companies such as Microsoft, Oracle, and IBM through our TSANet multi vendor support channel.

    Day 1 Support for any new versions

    Day One Support for disruptive technologies with frequent release cycles. With this strategy - the first of its kind for any data connectivity provider - Progress DataDirect on-premises ODBC and JDBC drivers will support any new versions of supported data sources.

    High-performing Type 5 JDBC Driver

    Type 5 JDBC drivers offer the same client-side, single-tier, 100% Java architecture of Type 4 JDBC drivers, but address the limitations of many of the Type 4 JDBC drivers. Unlike a type 4 JDBC driver, our type 5 JDBC driver maximizes data throughput while using minimal amount of CPU and memory resources. You can learn more over here


    Technical Specifications

    Progress DataDirect Connect for JDBC SQL Server Driver
    Version 5.1.4

    Database Support

    • Microsoft SQL Server 2000 and higher
    • Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
    • Microsoft SQL Server 7.0

    Platform Support

    • 32- and 64-bit platforms

    Software Requirements

    • Java SE 5 or higher

    Documentation


    Security Vulnerability Response Policy

    Upon identification of any security vulnerability, Progress will exercise commercially reasonable efforts to address the vulnerability in accordance with the following policy

    Priority* Time Guideline Version(s)
    High Risk
    (CVSS 8+ or industry equivalent)
    30 days Active (i.e. latest shipping version) and all Supported versions
    Medium Risk
    (CVSS 5-to-8 or industry equivalent)
    180 days Active (i.e. latest shipping version)
    Low Risk
    (CVSS 0-to-5 or industry equivalent)
    Next major release or best effort Active (i.e. latest shipping version)

    * Priority is established based on the current version of the Common Vulnerability Scoring System (CVSS), an open industry standard for assessing the severity of computer system security vulnerabilities. For additional information on this scoring system, refer to https://en.wikipedia.org/wiki/CVSS.


    Videos

    Learn How to Install and Configure SQL Server JDBC Driver

    In this video videos Gordon Creshaw explains how to install a Spark SQL JDBC Driver. Using similar steps you can also install the SQL Server JDBC driver for both 32 and 64 bit platforms. A single JAR file is all you need for a powerful connectivity to your SQL Server


    Tutorials

    SQL Server Integration with WebSphere using JDBC Driver

    Integrate WebSphere 7.0 and SQL Server using JDBC Driver

    WebSphere users are accustomed to using embedded Websphere JDBC drivers from DataDirect. You can now get the latest SQL Server JDBC drivers directly from Progress DataDirect that IBM continues to recommend in their data source configurations.

    Read the Tutorial



    Related Resources

    SQL_Server_Solutions

    Solution Page

    Learn What DataDirect can do for your SQL Server Shops

    Progress DataDirect is the trusted name in data connectivity for Microsoft SQL Server Ecosystems. Learn how to securely bind your sql server to SaaS, Relational, NoSQL and Big Data Sources using our certified ODBC, JDBC and ADO.NET Drivers and the OData API.

    SQL Server Solutions


    WebSphere Offers SQL Server JDBC Driver

    Article

    IBM Recommends DataDirect JDBC Driver to Connect to SQL Server

    IBM WebSphere allows users to download our SQL Server JDBC Driver and SequeLink JDBC Drivers so that they can connect their WebSphere application server to Microsoft SQL Server.

    Read the Article
    SQL Server JDBC Driver Case Study - Yamaha

    Case Study

    Yamaha Achieved 20X Performance Increase Using SQL Server JDBC Driver

    Yamaha turned to Progress DataDirect after its operationally-critical website suffered performance issues. We replaced the default Microsoft SQL Server drivers with our SQL Server JDBC drivers to improve the page load time by 10 times.

    Yamaha Case Study
    bg-air-dci-revamp
    Microsoft SQL Server Connectors are Part of Progress Data Connectivity & Integration Solutions
    icon-info-b

    DataDirect Connectors

    Connect any data source to any application

    icon-contact-us-b

    Contact Us

    A product specialist will be glad to get in touch with you