Are you looking for the best performance for your Hive ODBC queries? Our new release offers fast ODBC connectivity for big data analytics.
Advanced analytics, along with data scientists and analysts, are driving the need for speed around Hadoop Hive for both batch and interactive workloads. And we heard loud and clear from 1,200+ survey respondents that Hive remains the most popular big data interface to access data from our annual survey (2017 results to be published soon—stay tuned).
That’s why we’re pleased to announce critical performance enhancements in the new version of our Apache Hive ODBC driver. Our Hive connectors provide the fast, superior connectivity needed for data management applications and BI and analytics tools such as Power BI or Qlik.
Our ODBC connector for Hadoop Hive supports all Hive distributions out-of-the-box and includes the Progress Security Vulnerability Response Policy, as well as “Day One” support. You get full support for any new version of Hive from day one for the business platform of your choice, across AIX, Linux, Solaris*, HPUX* and Windows (*supported with 7.1).
In addition to SQL access, you can leverage our hybrid technology to produce a standard REST API (OData) to operationalize Hadoop and instantly connect popular OData consumers such as Salesforce, Oracle Service Cloud and Tableau.
Native Hive ODBC drivers are provided with each Hadoop distribution to support basic tasks on a workstation, such as pulling data into Microsoft Excel from that specific Hadoop Hive distribution and version. In contrast, Progress DataDirect drivers are engineered for applications, and include enterprise support and features across all versions and distributions of Hadoop Hive.
MicroStrategy distributes DataDirect Hive ODBC drivers with its analytics platform for faster access via SQL to Hadoop data. The company’s customers need to conduct analysis and perform highly complex queries against Hive. MicroStrategy helps them get to the data and insights faster.
IBM Campaign recommends DataDirect Hive ODBC drivers to query customer data for targeted marketing campaigns. Rather than certify multiple versions within each of the seven distributions of Hadoop Hive, IBM can certify one driver to support all its customers’ big data platforms.
The new Apache Hadoop Hive ODBC driver offers major performance enhancements for querying and processing truly high volume, complex data sets:
32- and 64-bit drivers are available for all supported databases and platforms unless otherwise noted.
Compatible with ODBC 3.8 applications
Supports Apache Hive version 1.0 and higher against the following distributions:
Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.
Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.Learn More
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You can also ask us not to share your Personal Information to third parties here: Do Not Sell or Share My Info
We see that you have already chosen to receive marketing materials from us. If you wish to change this at any time you may do so by clicking here.
Thank you for your continued interest in Progress. Based on either your previous activity on our websites or our ongoing relationship, we will keep you updated on our products, solutions, services, company news and events. If you decide that you want to be removed from our mailing lists at any time, you can change your contact preferences by clicking here.