Overview
- 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
What's Included
- Microsoft SQL Server
- Microsoft Analytics Platform System
- Microsoft Azure Synapse Analytics
- Big Data Clusters
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.
Secure Active Directory Authentication Support
Progress DataDirect SQL Server JDBC driver provides Secure way of authentication using Azure Active Directory. User can authenticate with Active Directory authentication using three different ways mentioned below:
- Using Azure AD UserID/Password
- Using an AccessToken
- Authenticating a Service Principal AD user using Service PrincipalID and Service PrincipalSecret
Encryption SSL 3.0, TLS 1.0, 1.1, 1.2 Compliant
We keep our SSL version up to 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.
Cross-platform Support
Use one ODBC driver for all versions of SQL that works across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX .
Advanced Connection Pooling
Connection pooling allows you to reuse connections rather than creating a new one every time the driver needs to establish a connection to the underlying database. The DataDirect Connect Series for ODBC drivers enable connection pooling without requiring changes to your client application.
Technical Specifications
Progress DataDirect Connect for JDBC SQL Server Driver
Version 6.0.0
Database Support
- Microsoft Windows Azure SQL Database Version 12.0 and higher
- Microsoft Windows Azure SQL Database Version 11.0 and higher
- Microsoft Azure Synapse Analytics (formerly Microsoft Azure SQL Data Warehouse), version 12 and higher
Platform Support
Software Requirements
- Java Virtual Machine (JVM): Java SE 8 or higher (LTS version), including Oracle JDK, OpenJDK, and IBM SDK (Java) distributions.
Documentation
Progress DataDirect for JDBC for SQL Server Driver
Version 6.0.0