I simply do not know what I should enter after trying different details based on the information I knew about Sandbox.Īlso, I looked at the MapR Hadoop Hive data connector in Tableau, and it looks for the same basic information, but simply unsure as to what I should enter. Now, in Tableau, I chose the Hortonworks Hadoop Hive data connector, and this is where the confusion set in. Here's a screen shot of the driver files:

I downloaded and installed these two database drivers, because of uncertainty. Here is a screen shot of the Hosts screen and the IP address info at the top of Ambari: I followed the tutorial, so no changes were made to the installation. Its customers include leading independent software vendors and global enterprises like Alteryx®, Altiscale®, Cloudera®, Couchbase®, Databricks®, Datastax®, Google®, Hortonworks®, MapR®, Microsoft®, Oracle®, Qubole®, SAP®, Splunk®, Tableau®, and Teradata®.I have successfully installed Sandbox and loaded and queried data via Ambari and Hive 2. Simba’s data connectivity products support multiple interfaces, including ODBC, JDBC, OLE DB, OLE DB for OLAP (ODBO), XML for Analysis (XMLA), ADO, ADO.NET, ADOMD and ADOMD.NET. Simba provides data connectivity solutions to many of the world’s leading companies on various platforms, including Windows, Mac, UNIX, Linux and many mobile device platforms. Simba Technologies ( is the recognized world leader in standards-based data access and analytics products and solutions for both relational and multi-dimensional data sources. Only direct, universal ODBC 3.52 data access solution for Apache HiveĮmail: Twitter: Simba Technologies Inc.Supports data types: TinyInt, SmallInt, Int, BigInt, Float, Double, Boolean, String, Decimal and TimeStamp.Supports all major on-premise and cloud Hadoop / Hive distributions: Apache, Cloudera, DataStax, Hortonworks, MapR and others.The followings are highlights of some enhancements and new features: They efficiently map SQL to HiveQL delivering full SQL application functionality and real-time analytic and reporting capabilities to users. Simba’s ODBC and JDBC standardized solutions enable standard SQL-92 access directly to Apache Hive distributions. Hive is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc queries, and the analysis of large datasets stored in Hadoop-compatible file systems. Market leaders such as Alteryx®, DataStax®, Hortonworks®, MapR® are powered by Simba standards-based ODBC and JDBC to enable Business Intelligence (BI), analytics and reporting on Hive-based data. Queries, including joins, are translated from SQL to HiveQL. The Cloudera ODBC Driver for Impala enables your enterprise users to access Hadoop data through Business Intelligence (BI). The Hive Query Language, a subset of SQL-92, allows Simba’s solutions to interrogate Hive to obtain schema information to present to a SQL-based application. Simba’s Apache Hive Drivers efficiently transform an application’s SQL query into the equivalent form in HiveQL.

Odbc driver cloudera for tableau mac