Appendix: SparkSQL 1. Then, select Hive as the database type. All books are in clear copy here, and all files are secure so don't worry about it. Each machine that. HiveDriver ODBC Driver The Hive ODBC Driver allows applications that support the ODBC protocol to connect to Hive. In the list of downloads, locate and download the latest version of the Hortonworks ODBC Driver for Apache Hive appropriate for your environment (32-bit or 64-bit). This article is geared toward those who need to connect to an existing database using an ODBC driver. The Hortonworks Hive ODBC Driver with SQL Connector is used for direct SQL and. The SAS Drivers for ODBC connect from an ODBC-compliant application to SAS/SHARE servers, SAS Scalable Performance Data (SPD) Servers, or a local instance of a SAS ODBC server. Connect Excel to HDInsight with the Microsoft Hive ODBC Driver. Page7 WindowsDriver InstallingtheDriveronWindows On64-bitWindowsoperatingsystems,youcanexecuteboth32-and64-bitapplications. now we make a lot of money on it. The download page for the Hive ODBC driver provides a link to an article on how to configure the Hive ODBC driver to connect to HDInsight using Excel. The HIVE tables are on Hortonworks 2. Rajibdotnet05. catalog, schema, tableName, tableType NULL or character: whether these do anything depends on the ODBC driver. Starting the Spark Service and the Spark Thrift Server 5. Install ODBC driver: installer le pilote ODBC: On the server where SSIS will run, there must be the HIVE ODBC driver installed. Identify the S3 Access Policy Elements Step 2. Thrift bindings for Hive are available for C++, Java , PHP, Python and Ruby. These two releases works with Hadoop 1. Additionally, MySQL Connector/J 8. Select your operating system version. How to Communicate to Hadoop via Hive using. ODBC Drivers. Rajibdotnet05. The screenshots in the article are a bit out of date, but the procedure is essentially the same when using the driver from SSIS. JDBC Driver. Infographic: Business Intelligence (BI) on Hadoop. In the list of downloads, locate and download the latest version of the Hortonworks ODBC Driver for Apache Hive appropriate for your environment (32-bit or 64-bit). 31 Driver for Impala Release Notes and Installation Guide. You can connect to the Hortonworks Hive System by filling in the details as below. For this article, the driver is used for Office Excel. Microsoft® Hive ODBC Driver provides HiveQL access from ODBC based applications to HDInsight Apache Hadoop Hive. odbc-low-level 3 Arguments channel connection handle as returned by odbcConnect, of class "RODBC". 3? We used to have a link under AddOns on our website, however we only have SmartSense under AddOns at the moment. Alteryx Driver Download To help streamline your use of Alteryx Analytics, we have obtained permission to distribute the following ODBC drivers. Under ODBC and JDBC Drivers, select the ODBC driver download for your environment (Hive or Impala). The Apache Hive drivers are loaded dynamically so you must connect at least once to your distribution to see what version is listed in the JDBC Drivers dialog. Where can I find the latest Hive ODBC Driver for HDP 2. Download Hive ODBC driver. So I will add to the almighty Google and help it fill the void that I tragically found. The most used version is 2. Microsoft® Spark ODBC Driver provides Spark SQL access from ODBC based applications to HDInsight Apache Spark. Thrift Thrift Java Client. odbc-low-level 3 Arguments channel connection handle as returned by odbcConnect, of class "RODBC". 51: Yes: Yes: Yes: Connect to IBM i systems using this ODBC driver. Our Hive ODBC driver supports advanced security mechanisms including Kerberos, Sentry and Ranger for authentication and authorization across all your distributions. ODBC is one of the most established APIs for connecting to and working with databases. Finally, the chapter provides information about data types, ODBC conformance levels, isolation and lock levels supported, and other driver-specific information. Amazon EMR supports both JDBC and ODBC connectivity. 3? We used to have a link under AddOns on our website, however we only have SmartSense under AddOns at the moment. The Salesforce ODBC Driver is a powerful tool that allows you to easily connect to live Salesforce Force com data through any ODBC capable application or News Best Apps Download Information. I was able to connect Alteryx with my Hive tables. I could able to see the DSN Created in 64 bit ODBC Data source Administrator, in 32 bit also, but it shows Platform as 64-bit and can not remove or modify in 32-bit odbc administrator, as i have created in 64-bit. The setup package generally installs about 36 files and is usually about 8. More details can be found in the README attached to the tar. Open Tableau Desktop and connect to Hortonworks. 1002, with over 98% of all installations currently using this version. To access Hive data using ODBC, use the ODBC driver recommended for use with your Hadoop distribution. If they are on the mapr hive odbc node, run the command on only that one node. Click on About Aqua Data Studio > JDBC Drivers. I followed the below steps but it didn't worked. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance. x The problem we are facing is when attempting to interface with another service known as tableau, it does not accept anything from the latest driver. Operates only on a standalone server. Microsoft Hive ODBC Driver enables Business Intelligence, Analytics and Reporting on data in Apache Hive. Implementations of the ODBC interface standard that enable you to access, manipulate, and update SAS data sources from applications that are ODBC compliant. Download Microsoft Hive ODBC driver from here; Install the Microsoft Hive ODBC driver use either the x86 or the x64 ( take care of the version to use the same with R) Configure your DSN in the ODBC Data Sources; go to Control Panel > Administrative Tools > ODBC Data Sources (64-bit) open System DSN click add. If you download and install the latest driver the Hive plugin will actually go away. Optionally Copy an Existing S3 Access Policy as a Template Step 3. To start the installation, click Next on the Hortonworks Hive ODBC Driver Setup Wizard Welcome screen. 68 (15 votes) To begin, you need to download Microsoft® Hive ODBC Driver. The most common release is 1. Please add new entries here. Open Tableau Desktop and connect to Hortonworks. 0 respectively, plus a fix for a LDAP vulnerability issue. Because Hive driver has extra Maven dependencies (besides hive-jdbc). At the heart of the technology is the ODBC driver, which connects an application to the database. odbc-low-level 3 Arguments channel connection handle as returned by odbcConnect, of class "RODBC". 8 MB) | MD5. This article is geared toward those who need to connect to an existing database using an ODBC driver. Query pricing is the only pricing that applies when the driver is not configured to support large result sets. Both 32 and 64-bit editions are supported. 0 supports the new X DevAPI for development with MySQL Server 8. hive-odbc free download. 5, with over 98% of all installations currently using this version. Prerequisites 2. If you have one, you can download the driver as part of the software bundles from IBM FixCentral (search for "Netezza"). The screenshots in the article are a bit out of date, but the procedure is essentially the same when using the driver from SSIS. Opening a Spark SQL ODBC Connection 6. Azure HDInsight driver is not the correct driver for connecting to Data Bricks Hive tables. Using the DataStax ODBC driver for Hive, users can connect to a DataStax Enterprise cluster with their favorite BI tools (e. Hive May Fail on Long Queries With Multiple AND and OR Clauses Shows examples of conditions that could cause Hive data sources to fail. It is an established API for connecting to and working with databases. Download Now 20 Days Free Trial. The ODBC Data Source Administrator dialog appears. we want you to download driver files without any problems. Downloading the Hive JDBC Driver; Deploying the Hive JDBC Driver; Connecting to Hive. Note: The TIBCO Spotfire ODBC Driver for Salesforce. The Hortonworks Hive ODBC Driver efficiently transforms an application's SQL query into the equivalent form in HiveQL. If your Hive server uses the Cloudera or Hortonworks distribution of Hadoop, you have the option of connecting to the server using the Cloudera Hive ODBC driver or the Hortonworks Hive ODBC driver. 09 driver, I successfully tested the ODBC driver following the instructions at. Thrift C++ Client. A linked server allows a user to query Hive—without having to download/configure the Hive ODBC driver on their machine. Why we need Microsoft Hive ODBC Driver? We need this for connecting with Hive using ODBC. Then, select Hive as the database type. For instance, if the application running is 64-bit then you should install the 64-bit driver else go for 32-bit. Upload Data to. If you download and install the latest driver the Hive plugin will actually go away. I downloaded it locally and then moved the ZIP file into my SAP HXE instance:. Install the Hive ODBC Driver Prerequisites: Ensure that Excel 2010 64-bit is already installed before installing the HiveODBC Driver. Select Set up ODBC data sources. This download was checked by our antivirus and was rated as clean. There are several ODBC drivers available presently in the market that work on top of their own distribution of Hadoop. You can connect to the Hortonworks Hive System by filling in the details as below. Sur le serveur ou SSIS s'exécutera, il faut avoir le pilote ODBC pour HIVE installé. Many of these tools require Java Database Connectivity (JDBC) driver or an Open Database Connectivity (ODBC) driver. Queries run using the driver are charged based on how the driver is configured: Query pricing applies by default to all queries from the driver. Many of these tools require an ODBC (Open Database Connectivity) or JDBC (Java Database Connectivity) driver. Hi, On the Answers Community, most of the questions deal with popular Microsoft products such as Windows 10, Office, and such. Select Set up ODBC data sources. ODBC driver of the Denodo Platform 7. Then, select Hive as the database type. Additional drivers supported by Alteryx will need to be obtained independently. 11 through 3. Hive ODBC driver for Windows. Amazon EMR now provides ODBC and JDBC drivers for Hive, Impala, and HBase. If you are already using JDBC applications with an earlier Impala release, you should update your JDBC driver, because the Hive 0. Click on About Aqua Data Studio > JDBC Drivers. Then, select Hive as the database type. Using Excel 2010 and the Hive ODBC Driver to Visualize Hive Xls odbc driver download windows 10. Next, it explains how to configure a data source and how to connect to that data source. 64 Bit driver download link. This tool enables Business Intelligence, Analytics and Reporting on data in Apache Hive. Microsoft has deprecated the Hive plug-in for Excel (which is a little disappointing—it was never production ready, but it did offer some really nice functionality). Download Alteryx Analytics See List of Supported Data Sources Questions: [email protected] To access advanced options for a DSN-less connection, open Microsoft Hive ODBC Driver Configuration tool, and then click SSL Options. There are two drivers; one for 32-bit applications and other is for 64-bit applications. Download Microsoft Hive ODBC driver from here; Install the Microsoft Hive ODBC driver use either the x86 or the x64 ( take care of the version to use the same with R) Configure your DSN in the ODBC Data Sources; go to Control Panel > Administrative Tools > ODBC Data Sources (64-bit) open System DSN click add. The download version of Microsoft Hive ODBC Driver is 1. Many of these tools require Java Database Connectivity (JDBC) driver or an Open Database Connectivity (ODBC) driver. I could able to see the DSN Created in 64 bit ODBC Data source Administrator, in 32 bit also, but it shows Platform as 64-bit and can not remove or modify in 32-bit odbc administrator, as i have created in 64-bit. Hello, I am a sys-admin for my company and an employee is in need of an older Hive ODBC Driver for Windows 64-bit. I searched google and found numerous guides and examples like this: HiveServer2 clients. we made this website just for fun. This article is geared toward those who need to connect to an existing database using an ODBC driver. A command line tool and JDBC driver are provided to connect users to Hive. Opening a Spark SQL ODBC Connection 6. Download and install the drivers. The driver file that RazorSQL downloads is called the "Hive JDBC Uber Jar" and includes all the dependencies necessary for connecting to Hive. 11 through 3. HORTONWORKS HIVE ODBC DRIVER DOWNLOAD - User Authentication Variable Description principal A string that uniquely identifies a Kerberos user. Something. 63 MB (9,052,160 bytes). The software installer includes 22 files and is usually about 8. But this time nothing. Appendix: SparkSQL 1. Starting the Spark Service and the Spark Thrift Server 5. This is pretty simple, just download and install the Hive ODBC Drivers from Microsoft, and remember to follow the steps to "Create a Hive ODBC Data Source", which simply involves adding a new DSN (Data Source Name) on the server, this means you need to supply the Hive instance Host, Port number and other. Apache Thrift - a scalable cross-language software framework that enables the Hive ODBC driver (specifically the Hive client) to communicate with the Hive Server. ODBC Drivers ODBC driver for Windows. Hortonworks Hive ODBC Driver is a program developed by Hortonworks. ODBC Drivers. Hive Architecture basically build up on three core component structure. Driver Partner. The Apache Hive ™ data warehouse software facilitates reading, writing, and managing large datasets residing in distributed storage using SQL. 1 Patch Installation Steps 6A. The Apache Hive drivers are loaded dynamically so you must connect at least once to your distribution to see what version is listed in the JDBC Drivers dialog. Hortonworks Hive ODBC Driver is a program developed by Hortonworks. x has been tested against IBM BigInsights 3. 14 MB (8,531,968 bytes). The following steps show you how to create a Hive ODBC Data Source. Review the license agreement, then select the checkbox to accept the license terms. The Hortonworks Hive ODBC Driver efficiently transforms an application's SQL query into the equivalent form in HiveQL. now we make a lot of money on it. Once you have connected to Hive, you can import a variety of tables from the Hive API. Open Control Panel, search for ODBC and open ODBC Data Source Administrator, in System DSN tab click Add, configure the data source as below, click OK. The above are the common missing steps by Windows users when trying to connect to Hive or Impala via ODBC. HiveDriver ODBC Driver The Hive ODBC Driver allows applications that support the ODBC protocol to connect to Hive. Why we need Microsoft Hive ODBC Driver? We need this for connecting with Hive using ODBC. The ODBC Data Source Administrator dialog appears. Both 32 and 64-bit editions are supported. The Microsoft Visual C++ 2010 Redistributable Package. This is pretty simple, just download and install the Hive ODBC Drivers from Microsoft, and remember to follow the steps to "Create a Hive ODBC Data Source", which simply involves adding a new DSN (Data Source Name) on the server, this means you need to supply the Hive instance Host, Port number and other. This download is provided to you free of charge. A command line tool and JDBC driver are provided to connect users to Hive. Install Microsoft Hive ODBC driver. now we make a lot of money on it. Opening a Spark SQL ODBC Connection 6. Obrigado por baixar Microsoft Hive ODBC Driver da nossa base de dados de programas. Update your browser to view this website correctly. It can be installed from the HadoopOnAzure portal, by clicking the "Downloads" tile and choosing the right MSI:. x has been tested against IBM BigInsights 3. Specifically, we are in need of the driver from version 1. The first option has an "Auto Download" capability to download and install a Hive JDBC driver. MicroStrategy Hive ODBC Driver. I'm pleased to let you know that we're now providing free ODBC drivers for Hadoop/Hive as well as Cassandra. Alteryx Driver Download To help streamline your use of Alteryx Analytics, we have obtained permission to distribute the following ODBC drivers. The following steps show you how to create a Hive ODBC Data Source. Install Microsoft Hive ODBC driver Download and install the Microsoft Hive ODBC Driver version that matches the version of the application where you will be using the ODBC driver For this article the driver is used for Office Excel Create Apache Hive ODBC data source The following steps show you how to create a Hive ODBC Data Source. For community support, please visit the Connectivity Forum. Our ODBC driver can be easily used with all versions of SQL and across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX. There is no need for an ODBC or OLEDB driver to connect. Users of previous versions can download and use the ldap-fix. Cloud Workgroup users that need access to this driver can download it from the Spotfire Cloud site, on the Downloads page. Query pricing is the only pricing that applies when the driver is not configured to support large result sets. Install ODBC driver: installer le pilote ODBC: On the server where SSIS will run, there must be the HIVE ODBC driver installed. To review other options, such as using a database R package or JDBC, please refer to the Selecting a database interface page. The screenshots in the article are a bit out of date, but the procedure is essentially the same when using the driver from SSIS. Why not to use preconfigured Hive driver? Another way is to download Hive driver manually and add jars in your custom driver configuration (it may be better because Maven artifact is really huge). Many of these tools require Java Database Connectivity (JDBC) driver or an Open Database Connectivity (ODBC) driver. After I installed Simba Spark ODBC 1. Then, select Hive as the database type. To get the latest drivers, see Hortonworks Hadoop Hive on the Tableau Driver. Since IBM acquired Netezza, the ODBC drivers are only available to customers with active support contracts. The drivers on which this procedure is based are the standard Apache Hive JDBC drivers. Proceed as follows to download the latest Qubole ODBC driver package to a Microsoft Windows server: Note The Qubole driver is stored in publicly accessible Cloud storage, and works on all Cloud platforms supported in QDS. There is no need for an ODBC or OLEDB driver to connect. Download and install the drivers. 5x ODBC database driver. we made this website just for fun. A command line tool and JDBC driver are provided to connect users to Hive. MIT kerberos. MicroStrategy Hive ODBC Driver. Welcome to the Hortonworks Hive ODBC Driver with SQL Connector. Download ODBC / JDBC Drivers. Download presto-jdbc-. Opening a Spark SQL ODBC Connection 6. which includes : 1. Note: Make sure you use the latest available drivers. In this section, we will see how to use Excel against the data that is in our Data Lake using Hive. Connecting to Amazon EMR Hive To connect to Amazon EMR Hive, use the Connector for Hortonworks ( Files and data > Connect to > Hortonworks ). Dataedo reads following metadata from Apache Hive. We recommend that you choose the appropriate ODBC driver to make Secure Sockets Layer (SSL) connections to the server. Hive ODBC Driver on Ubuntu software library that implements the Open Database Connectivity adminmanual-installation. 13 JDBC driver. The Hive ODBC driver allows you to access Hive from a program that you write, or a Business Intelligence or similar application that uses ODBC to communicate with database products. You can connect to the Hortonworks Hive System by filling in the details as below. x has been tested against IBM BigInsights 3. Microsoft Hive ODBC Driver is a connector to Apache Hadoop Hive available as a part of HDInsight clusters. The Hortonworks Hive ODBC Driver with SQL Connector is used for direct SQL and. You can use popular business intelligence tools like Microsoft Excel, MicroStrategy, QlikView, and Tableau with Amazon EMR to explore and visualize your data. Click on About Aqua Data Studio > JDBC Drivers. OEMs, ISVs and VARs can purchase commercial licenses. Download it from Simba Technologies. The download version of Microsoft Hive ODBC Driver is 1. Microsoft Hive ODBC Driver enables Business Intelligence, Analytics and Reporting on data in Apache Hive. In this article we demonstrated how to use Cloudera Hive and Impala ODBC drivers to connect from Oracle using ODBC heterogeneous gateway. Any database that can be accessed with a JDBC driver can be used with DbVisualizer. For configuration purpose, follow the procedure mentioned below:. Download and install the Microsoft Hive ODBC Driver version that matches the version of the application where you will be using the ODBC driver. Hi, On the Answers Community, most of the questions deal with popular Microsoft products such as Windows 10, Office, and such. Read the Cloudera ODBC 2. The Apache Hive ™ data warehouse software facilitates reading, writing, and managing large datasets residing in distributed storage using SQL. Welcome to the Hortonworks Hive ODBC Driver with SQL Connector. Click Downloads tile on the Hadoop Services on Azure portal, and download and install either 32-bit/64-bit version of the Hive ODBC Driver installation file depending on the version of Excel 2010 you have on your computer. Cloud Workgroup users that need access to this driver can download it from the Spotfire Cloud site, on the Downloads page. Downloading and Installing the Hive ODBC Driver and Excel Add-In. In this book, we will focus on the Microsoft ODBC driver for Hive that bridges the gap between Hadoop and SQL Server along with its rich business intelligence and visualization tools. 7 introduces capabilities to integrate with Hadoop sources using the Hive ODBC interface. Download (8. Install Microsoft Hive ODBC driver Download and install the Microsoft Hive ODBC Driver version that matches the version of the application where you will be using the ODBC driver For this article the driver is used for Office Excel Create Apache Hive ODBC data source The following steps show you how to create a Hive ODBC Data Source. To access Hive data using ODBC, use the ODBC driver recommended for use with your Hadoop distribution. Installing the Driver on Windows (64-bit) Download the ODBC driver installer TreasureDataPrestoODBC. The most used version is 2. 5x ODBC database driver. Please add new entries here. ODBC is one of the most established APIs for connecting to and working with databases. Analysis using Excel and Microsoft Hive ODBC driver Excel is the most popular data analysis tool used by business analysts and now HDInsight makes it easy to integrate Excel with. This page describes how to download the Hive driver and deploy it, how to connect to Hive with a connection string, provides information about the Hive data model, and more. However, I could not find the JDBC driver itself (jar file) anywhere. Cloud Workgroup users that need access to this driver can download it from the Spotfire Cloud site, on the Downloads page. CData ODBC Driver. Under Hortonworks ODBC Driver for Apache Hive, download the driver for OS X. These drivers will help you: Explore your databases using RStudio Server Pro; Develop and deploy Shiny applications that depend on databases to Shiny Server Pro and RStudio Connect. Tahir Hussain "Bob" Babar from the SAP HANA Academy details how to install a HIVE ODBC driver on a SAP HANA One Linux server. The Microsoft Visual C++ 2010 Redistributable Package. In the list of downloads, locate and download the latest version of the Hortonworks ODBC Driver for Apache Hive appropriate for your environment (32-bit or 64-bit). Operates both in embedded mode and on standalone server. Click on About Aqua Data Studio > JDBC Drivers. It can be installed from the HadoopOnAzure portal, by clicking the "Downloads" tile and choosing the right MSI:. 0 and higher), which is available for download on the TIBCO eDelivery site. Download operating system-specific drivers for Windows and Linux that allow you to connect to a wide range of data sources. 63 MB (9,052,160 bytes). Any database that can be accessed with a JDBC driver can be used with DbVisualizer. Our ODBC driver can be easily used with all versions of SQL and across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX. Click Downloads tile on the Hadoop Services on Azure portal, and download and install either 32-bit/64-bit version of the Hive ODBC Driver installation file depending on the version of Excel 2010 you have on your computer. MapR Hive ODBC connector; Cloudera ODBC driver for Hive; Simba's Apache Hive ODBC driver; Note: Please note that while we make every effort to keep references to third-party content accurate, the information we provide here might change without notice. Download Alteryx Analytics See List of Supported Data Sources Questions: [email protected] Step 3 : Download and Install the Driver. Connecting to Amazon EMR Hive To connect to Amazon EMR Hive, use the Connector for Hortonworks ( Files and data > Connect to > Hortonworks ). we have got two million drivers and thousands of driver update software. Once you have connected to Hive, you can import a variety of tables from the Hive API. Hi, I want to establish connection between Hive an d Tableau via Microsoft Hive ODBC Driver But I am getting following error: manisha · Hi, Thanks for reply. Easily Build BI Applications with Open Source, Interactive SQL. Go to Settings and enter odbc. The Cloudera ODBC Driver for Hive enables your enterprise users to access Hadoop data through Business Intelligence (BI) applications with ODBC support. Click the System DSN to view the Drill data source. The latest version of Microsoft Hive ODBC Driver is 1. Select Set up ODBC data sources. In this section, we will see how to use Excel against the data that is in our Data Lake using Hive. ODBC is one of the most established APIs for connecting to and working with databases. html to download and install Apache Hive. A linked server allows a user to query Hive—without having to download/configure the Hive ODBC driver on their machine. we made this website just for fun. These drivers include an ODBC connector for Apache Hive. Connect to Apache Hive. Prerequisites 2. In order to use it with Visual Studio, you need 32-bit driver. Connecting Tableau to Spark SQL 5A. RStudio Professional Drivers are ODBC data connectors for the most popular databases. If you download and install the latest driver the Hive plugin will actually go away. If you use a Debian-based Linux distribution you should previously convert the downloaded package from. Moment the Driver is installed in your System the Sign in Button in Tableau gets enabled. CData ODBC Driver. Using the JDBC Driver; Using JDBC with SQuirreL on Windows; Installing the ODBC Driver; Installing the Driver on Linux; Installing the Driver on Mac OS X; Installing the Driver on Windows; Configuring ODBC; ODBC Configuration Reference; Logging and Tracing; Configuring ODBC on Linux; Configuring ODBC on Mac OS X; Configuring ODBC on Windows. ini file was updated with the correct driver locations. To access Hive data using ODBC, use the ODBC driver recommended for use with your Hadoop distribution. Below is an example screenshot of the default Hive drivers. 7 Oracle has introduced Oracle Apache Hadoop Hive ODBC Driver For OBIEE. Read the Cloudera ODBC 2. Keytab file for authentication and. Operates both in embedded mode and on standalone server. Read online Hive ODBC Driver - Hortonworks book pdf free download link book now. We strongly encourage using the specific Apache drivers from your Hadoop distro and version. Registration is needed for a 30-days trial. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance. JDBC Driver. Esse download é totalmente GRATUITO. If you use a Debian-based Linux distribution you should previously convert the downloaded package from. ODBC Drivers. Step 2: Under Hortonworks ODBC Driver for Apache Hive , Select the driver for your windows bit -version environment. I downloaded it locally and then moved the ZIP file into my SAP HXE instance:. Netezza ODBC driver. The default port is These jar files need to be obtained before attempting the connection: Click the appropriate link below to see information on connecting to Hive with either of these drivers. Operates only on a standalone server. In order to use it with Visual Studio, you need 32-bit driver. Databricks JDBC / ODBC Driver Download. You can use popular business intelligence tools like Microsoft Excel, MicroStrategy, QlikView, and Tableau with Amazon EMR to explore and visualize your data.