Powerful Apache Hadoop Hive JDBC Driver

Overview

Progress DataDirect’s JDBC Driver for Apache Hadoop Hive offers a high-performing, secure and reliable connectivity solution for JDBC applications to access Apache Hadoop Hive data. Our JDBC driver can be easily used with all versions of SQL and across both 32-bit and 64-bit platforms. Enjoy real-time analytics, reporting and business intelligence (BI) capabilities with your favorite tools such as SAS, Yellowfin, SAP, Sisense, Denodo, Cognos, Jaspersoft, Tableau, Tibco, OBIEE, and more.

• Get full support for any new version of Hive from day one
• Ensures availability with built-in failover and other high-value features
• Guaranteed reliability with comprehensive quality testing and true compliance to standards

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

Support for Advanced Security Features

Our Hive JDBC driver supports advanced security mechanisms including Kerberos, Knox, Sentry and Ranger for authentication and authorization across all your distributions.

Codeless Bulk Load / Export with BatchMechanism

Progress DataDirect JDBC drivers support bulk load through BatchMechanism. This means existing applications, such as Apache Sqoop, can get bulk insert performance without any code changes or external tools such as bcp for SQL Server or SQL*Loader for Oracle. Learn more from our documentation

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

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 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

Data Integration for Apache Spark

This video contains 3 short demos showcasing data connectivity options for the Spark environment via JDBC Apache SQOOP, ODBC SparkSQL and Salesforce Spark Dataframes.

Related Resources