On this page, you find information about downloading and installing the drivers you need to be able connect to data sources with the connector for Hortonworks in Spotfire.
*Cloudera Odbc Driver Download
*Cloudera Hive Odbc 64
*Hortonworks Hive Odbc Driver Download
*Hortonworks Hive Odbc Driver Mac Download Windows 10
Preparations
Before downloading and installing any driver software for use with this connector, read the system requirements for the connector for your version of Spotfire. Make sure that your database version and driver version is supported in your version of Spotfire.
Remember that additional requirements and third party dependencies might apply for using the drivers. Refer to the official documentation from the driver vendor for more information.
Supported data sources
You can use the Spotfire Connector for Hortonworks to connect to the following data source types:
To use the Hortonworks connector, you must install the Hortonworks ODBC Driver for Apache Hive on your computer.
Downloading the Hortonworks ODBC Driver for Apache Hive
Database Drivers. The Cloudera ODBC and JDBC Drivers for Hive and Impala enable your enterprise users to access Hadoop data through Business Intelligence (BI) applications with ODBC/JDBC support. Hive ODBC Driver Downloads Hive JDBC Driver Downloads Impala ODBC Driver Downloads Impala JDBC Driver Downloads. Oracle Instant Client.
*
In a web browser, go to the Hortonworks Data Platform downloads web page.
*
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).
Note: When you obtain third-party software or services, it is your responsibility to ensure you understand the license terms associated with such third-party software or services and comply with such terms.
To connect to Amazon EMR Hive, use the Connector for Hortonworks (Files and data > Connect to > Hortonworks).
To connect to Amazon EMR Hive, install the Hortonworks ODBC Driver for Apache Hive. See the instructions above for Downloading the Hortonworks ODBC Driver for Apache Hive.
To connect to Apache Hive, use the Connector for Hortonworks (Files and data > Connect to > Hortonworks).
To connect to Apache Hive, install the Hortonworks ODBC Driver for Apache Hive. See the instructions above for Downloading the Hortonworks ODBC Driver for Apache Hive.
To connect to IBM BigInsights Hive in Spotfire, use the Connector for Hortonworks (Files and data > Connect to > Hortonworks).
To connect to IBM BigInsights Hive, install the Hortonworks ODBC Driver for Apache Hive. See the instructions above for Downloading the Hortonworks ODBC Driver for Apache Hive.
To connect to MapR Hive in Spotfire, use the Connector for Hortonworks (Files and data > Connect to > Hortonworks).
To connect to MapR Hive, install the Hortonworks ODBC Driver for Apache Hive. See the instructions above for Downloading the Hortonworks ODBC Driver for Apache Hive.
To connect to Microsoft Azure HDInsights Hive in Spotfire, you use the Connector for Hortonworks (Files and data > Connect to > Hortonworks).
When you connect to Microsoft Azure HDInsights Hive, you must have installed the Microsoft® Hive ODBC Driver on your computer. The driver is available for download from Microsoft.
Downloading the Microsoft Hive ODBC Driver
*
In a web browser, go to the Microsoft downloads page.
*
Click Download, and, in the list of driver versions, select the version of the driver appropriate for your environment (32-bit or 64-bit). Then click Next to start the download.
Note: When you obtain third-party software or services, it is your responsibility to ensure you understand the license terms associated with such third-party software or services and comply with such terms.
So, I'm all set up... What do I do now?
If you want to learn more about how to use this connector, see the User's Guide for TIBCO Spotfire® Analyst. There you'll find everything from basic instructions to detailed information about how you can load and analyze data in Spotfire.
How it is useful: This is useful to connect hortonworks stream data from HCatalog to bring to MS excel to visualize
Step1: Get hold on ip address of the VM box
Step2: Locate Hortonworks hive ODBC drive to download (HortonworksHiveODBC64.msi) it will end with 32 bit system if you are working on a 32 bit operating system
Step3: Configure the ODBC Drive:
Hit Windows + F: Will open a search dialogue on right side of screen
Type Administrative there, the relevant tool option will appear. Hit on that: Keep category Everywhere than FilesCloudera Odbc Driver Download
Hit Configure ( Refer next pic)
Then add details related to VM :
Then Hit test : To test the connectivity details:
Hit ok on all the windows to close the dialogue boxesCloudera Hive Odbc 64
After this it goes same as Horton works original document on sentiment analysis on windows 7Hortonworks Hive Odbc Driver Download
I have just tried to taken care of stuff where it gets different from Windows 7 to Windows 8:Hortonworks Hive Odbc Driver Mac Download Windows 10
Please follow the detailed steps on how to connect and visualize from here
