You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by ts...@apache.org on 2015/05/12 07:57:06 UTC
[24/25] drill git commit: Tableau Server doc
Tableau Server doc
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/4f410f97
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/4f410f97
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/4f410f97
Branch: refs/heads/gh-pages
Commit: 4f410f975e99e446d76b4c6678cff026c46cd47f
Parents: 1cec6cc
Author: Bob Rumsby <br...@mapr.com>
Authored: Mon May 11 18:16:40 2015 -0700
Committer: Bob Rumsby <br...@mapr.com>
Committed: Mon May 11 18:16:40 2015 -0700
----------------------------------------------------------------------
_data/docs.json | 142 +++++++++----------
_docs/img/tableau-server-authentication.png | Bin 0 -> 42451 bytes
_docs/img/tableau-server-publish-datasource.png | Bin 0 -> 79417 bytes
.../img/tableau-server-publish-datasource2.png | Bin 0 -> 38100 bytes
.../img/tableau-server-publish-datasource3.png | Bin 0 -> 42950 bytes
_docs/img/tableau-server-publish1.png | Bin 0 -> 20646 bytes
_docs/img/tableau-server-publish2.png | Bin 0 -> 51834 bytes
_docs/img/tableau-server-signin1.png | Bin 0 -> 21257 bytes
_docs/img/tableau-server-signin2.png | Bin 0 -> 19833 bytes
...-using-apache-drill-with-tableau-9-server.md | 76 ++++++++++
10 files changed, 147 insertions(+), 71 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill/blob/4f410f97/_data/docs.json
----------------------------------------------------------------------
diff --git a/_data/docs.json b/_data/docs.json
index 08bfcd8..28fb349 100644
--- a/_data/docs.json
+++ b/_data/docs.json
@@ -185,8 +185,8 @@
}
],
"children": [],
- "next_title": "Analyzing Social Media with MicroStrategy",
- "next_url": "/docs/analyzing-social-media-with-microstrategy/",
+ "next_title": "Install Drill",
+ "next_url": "/docs/install-drill/",
"parent": "Tutorials",
"previous_title": "Summary",
"previous_url": "/docs/summary/",
@@ -194,23 +194,6 @@
"title": "Analyzing Highly Dynamic Datasets",
"url": "/docs/analyzing-highly-dynamic-datasets/"
},
- "Analyzing Social Media with MicroStrategy": {
- "breadcrumbs": [
- {
- "title": "Tutorials",
- "url": "/docs/tutorials/"
- }
- ],
- "children": [],
- "next_title": "Install Drill",
- "next_url": "/docs/install-drill/",
- "parent": "Tutorials",
- "previous_title": "Analyzing Highly Dynamic Datasets",
- "previous_url": "/docs/analyzing-highly-dynamic-datasets/",
- "relative_path": "_docs/tutorials/060-analyzing-social-media-with-microstrategy.md",
- "title": "Analyzing Social Media with MicroStrategy",
- "url": "/docs/analyzing-social-media-with-microstrategy/"
- },
"Analyzing the Yelp Academic Dataset": {
"breadcrumbs": [
{
@@ -3313,8 +3296,8 @@
"next_title": "Install Drill Introduction",
"next_url": "/docs/install-drill-introduction/",
"parent": "",
- "previous_title": "Analyzing Social Media with MicroStrategy",
- "previous_url": "/docs/analyzing-social-media-with-microstrategy/",
+ "previous_title": "Analyzing Highly Dynamic Datasets",
+ "previous_url": "/docs/analyzing-highly-dynamic-datasets/",
"relative_path": "_docs/040-install-drill.md",
"title": "Install Drill",
"url": "/docs/install-drill/"
@@ -4612,14 +4595,31 @@
}
],
"children": [],
- "next_title": "Query Data",
- "next_url": "/docs/query-data/",
+ "next_title": "Using Apache Drill with Tableau 9 Server",
+ "next_url": "/docs/using-apache-drill-with-tableau-9-server/",
"parent": "ODBC/JDBC Interfaces",
"previous_title": "Using Tibco Spotfire with Drill",
"previous_url": "/docs/using-tibco-spotfire-with-drill/",
"relative_path": "_docs/odbc-jdbc-interfaces/070-using-apache-drill-with-tableau-9-desktop.md",
"title": "Using Apache Drill with Tableau 9 Desktop",
"url": "/docs/using-apache-drill-with-tableau-9-desktop/"
+ },
+ {
+ "breadcrumbs": [
+ {
+ "title": "ODBC/JDBC Interfaces",
+ "url": "/docs/odbc-jdbc-interfaces/"
+ }
+ ],
+ "children": [],
+ "next_title": "Query Data",
+ "next_url": "/docs/query-data/",
+ "parent": "ODBC/JDBC Interfaces",
+ "previous_title": "Using Apache Drill with Tableau 9 Desktop",
+ "previous_url": "/docs/using-apache-drill-with-tableau-9-desktop/",
+ "relative_path": "_docs/odbc-jdbc-interfaces/080-using-apache-drill-with-tableau-9-server.md",
+ "title": "Using Apache Drill with Tableau 9 Server",
+ "url": "/docs/using-apache-drill-with-tableau-9-server/"
}
],
"next_title": "Interfaces Introduction",
@@ -5201,8 +5201,8 @@
"next_title": "Query Data Introduction",
"next_url": "/docs/query-data-introduction/",
"parent": "",
- "previous_title": "Using Apache Drill with Tableau 9 Desktop",
- "previous_url": "/docs/using-apache-drill-with-tableau-9-desktop/",
+ "previous_title": "Using Apache Drill with Tableau 9 Server",
+ "previous_url": "/docs/using-apache-drill-with-tableau-9-server/",
"relative_path": "_docs/070-query-data.md",
"title": "Query Data",
"url": "/docs/query-data/"
@@ -8083,31 +8083,14 @@
}
],
"children": [],
- "next_title": "Analyzing Social Media with MicroStrategy",
- "next_url": "/docs/analyzing-social-media-with-microstrategy/",
+ "next_title": "Install Drill",
+ "next_url": "/docs/install-drill/",
"parent": "Tutorials",
"previous_title": "Summary",
"previous_url": "/docs/summary/",
"relative_path": "_docs/tutorials/050-analyzing-highly-dynamic-datasets.md",
"title": "Analyzing Highly Dynamic Datasets",
"url": "/docs/analyzing-highly-dynamic-datasets/"
- },
- {
- "breadcrumbs": [
- {
- "title": "Tutorials",
- "url": "/docs/tutorials/"
- }
- ],
- "children": [],
- "next_title": "Install Drill",
- "next_url": "/docs/install-drill/",
- "parent": "Tutorials",
- "previous_title": "Analyzing Highly Dynamic Datasets",
- "previous_url": "/docs/analyzing-highly-dynamic-datasets/",
- "relative_path": "_docs/tutorials/060-analyzing-social-media-with-microstrategy.md",
- "title": "Analyzing Social Media with MicroStrategy",
- "url": "/docs/analyzing-social-media-with-microstrategy/"
}
],
"next_title": "Tutorials Introduction",
@@ -8186,8 +8169,8 @@
}
],
"children": [],
- "next_title": "Query Data",
- "next_url": "/docs/query-data/",
+ "next_title": "Using Apache Drill with Tableau 9 Server",
+ "next_url": "/docs/using-apache-drill-with-tableau-9-server/",
"parent": "ODBC/JDBC Interfaces",
"previous_title": "Using Tibco Spotfire with Drill",
"previous_url": "/docs/using-tibco-spotfire-with-drill/",
@@ -8195,6 +8178,23 @@
"title": "Using Apache Drill with Tableau 9 Desktop",
"url": "/docs/using-apache-drill-with-tableau-9-desktop/"
},
+ "Using Apache Drill with Tableau 9 Server": {
+ "breadcrumbs": [
+ {
+ "title": "ODBC/JDBC Interfaces",
+ "url": "/docs/odbc-jdbc-interfaces/"
+ }
+ ],
+ "children": [],
+ "next_title": "Query Data",
+ "next_url": "/docs/query-data/",
+ "parent": "ODBC/JDBC Interfaces",
+ "previous_title": "Using Apache Drill with Tableau 9 Desktop",
+ "previous_url": "/docs/using-apache-drill-with-tableau-9-desktop/",
+ "relative_path": "_docs/odbc-jdbc-interfaces/080-using-apache-drill-with-tableau-9-server.md",
+ "title": "Using Apache Drill with Tableau 9 Server",
+ "url": "/docs/using-apache-drill-with-tableau-9-server/"
+ },
"Using Custom Functions in Queries": {
"breadcrumbs": [
{
@@ -9111,31 +9111,14 @@
}
],
"children": [],
- "next_title": "Analyzing Social Media with MicroStrategy",
- "next_url": "/docs/analyzing-social-media-with-microstrategy/",
+ "next_title": "Install Drill",
+ "next_url": "/docs/install-drill/",
"parent": "Tutorials",
"previous_title": "Summary",
"previous_url": "/docs/summary/",
"relative_path": "_docs/tutorials/050-analyzing-highly-dynamic-datasets.md",
"title": "Analyzing Highly Dynamic Datasets",
"url": "/docs/analyzing-highly-dynamic-datasets/"
- },
- {
- "breadcrumbs": [
- {
- "title": "Tutorials",
- "url": "/docs/tutorials/"
- }
- ],
- "children": [],
- "next_title": "Install Drill",
- "next_url": "/docs/install-drill/",
- "parent": "Tutorials",
- "previous_title": "Analyzing Highly Dynamic Datasets",
- "previous_url": "/docs/analyzing-highly-dynamic-datasets/",
- "relative_path": "_docs/tutorials/060-analyzing-social-media-with-microstrategy.md",
- "title": "Analyzing Social Media with MicroStrategy",
- "url": "/docs/analyzing-social-media-with-microstrategy/"
}
],
"next_title": "Tutorials Introduction",
@@ -9375,8 +9358,8 @@
"next_title": "Install Drill Introduction",
"next_url": "/docs/install-drill-introduction/",
"parent": "",
- "previous_title": "Analyzing Social Media with MicroStrategy",
- "previous_url": "/docs/analyzing-social-media-with-microstrategy/",
+ "previous_title": "Analyzing Highly Dynamic Datasets",
+ "previous_url": "/docs/analyzing-highly-dynamic-datasets/",
"relative_path": "_docs/040-install-drill.md",
"title": "Install Drill",
"url": "/docs/install-drill/"
@@ -10292,14 +10275,31 @@
}
],
"children": [],
- "next_title": "Query Data",
- "next_url": "/docs/query-data/",
+ "next_title": "Using Apache Drill with Tableau 9 Server",
+ "next_url": "/docs/using-apache-drill-with-tableau-9-server/",
"parent": "ODBC/JDBC Interfaces",
"previous_title": "Using Tibco Spotfire with Drill",
"previous_url": "/docs/using-tibco-spotfire-with-drill/",
"relative_path": "_docs/odbc-jdbc-interfaces/070-using-apache-drill-with-tableau-9-desktop.md",
"title": "Using Apache Drill with Tableau 9 Desktop",
"url": "/docs/using-apache-drill-with-tableau-9-desktop/"
+ },
+ {
+ "breadcrumbs": [
+ {
+ "title": "ODBC/JDBC Interfaces",
+ "url": "/docs/odbc-jdbc-interfaces/"
+ }
+ ],
+ "children": [],
+ "next_title": "Query Data",
+ "next_url": "/docs/query-data/",
+ "parent": "ODBC/JDBC Interfaces",
+ "previous_title": "Using Apache Drill with Tableau 9 Desktop",
+ "previous_url": "/docs/using-apache-drill-with-tableau-9-desktop/",
+ "relative_path": "_docs/odbc-jdbc-interfaces/080-using-apache-drill-with-tableau-9-server.md",
+ "title": "Using Apache Drill with Tableau 9 Server",
+ "url": "/docs/using-apache-drill-with-tableau-9-server/"
}
],
"next_title": "Interfaces Introduction",
@@ -10687,8 +10687,8 @@
"next_title": "Query Data Introduction",
"next_url": "/docs/query-data-introduction/",
"parent": "",
- "previous_title": "Using Apache Drill with Tableau 9 Desktop",
- "previous_url": "/docs/using-apache-drill-with-tableau-9-desktop/",
+ "previous_title": "Using Apache Drill with Tableau 9 Server",
+ "previous_url": "/docs/using-apache-drill-with-tableau-9-server/",
"relative_path": "_docs/070-query-data.md",
"title": "Query Data",
"url": "/docs/query-data/"
http://git-wip-us.apache.org/repos/asf/drill/blob/4f410f97/_docs/img/tableau-server-authentication.png
----------------------------------------------------------------------
diff --git a/_docs/img/tableau-server-authentication.png b/_docs/img/tableau-server-authentication.png
new file mode 100644
index 0000000..c15ec7d
Binary files /dev/null and b/_docs/img/tableau-server-authentication.png differ
http://git-wip-us.apache.org/repos/asf/drill/blob/4f410f97/_docs/img/tableau-server-publish-datasource.png
----------------------------------------------------------------------
diff --git a/_docs/img/tableau-server-publish-datasource.png b/_docs/img/tableau-server-publish-datasource.png
new file mode 100644
index 0000000..f55796b
Binary files /dev/null and b/_docs/img/tableau-server-publish-datasource.png differ
http://git-wip-us.apache.org/repos/asf/drill/blob/4f410f97/_docs/img/tableau-server-publish-datasource2.png
----------------------------------------------------------------------
diff --git a/_docs/img/tableau-server-publish-datasource2.png b/_docs/img/tableau-server-publish-datasource2.png
new file mode 100644
index 0000000..8cb00ca
Binary files /dev/null and b/_docs/img/tableau-server-publish-datasource2.png differ
http://git-wip-us.apache.org/repos/asf/drill/blob/4f410f97/_docs/img/tableau-server-publish-datasource3.png
----------------------------------------------------------------------
diff --git a/_docs/img/tableau-server-publish-datasource3.png b/_docs/img/tableau-server-publish-datasource3.png
new file mode 100644
index 0000000..324a309
Binary files /dev/null and b/_docs/img/tableau-server-publish-datasource3.png differ
http://git-wip-us.apache.org/repos/asf/drill/blob/4f410f97/_docs/img/tableau-server-publish1.png
----------------------------------------------------------------------
diff --git a/_docs/img/tableau-server-publish1.png b/_docs/img/tableau-server-publish1.png
new file mode 100644
index 0000000..86d4ff9
Binary files /dev/null and b/_docs/img/tableau-server-publish1.png differ
http://git-wip-us.apache.org/repos/asf/drill/blob/4f410f97/_docs/img/tableau-server-publish2.png
----------------------------------------------------------------------
diff --git a/_docs/img/tableau-server-publish2.png b/_docs/img/tableau-server-publish2.png
new file mode 100644
index 0000000..1a3297b
Binary files /dev/null and b/_docs/img/tableau-server-publish2.png differ
http://git-wip-us.apache.org/repos/asf/drill/blob/4f410f97/_docs/img/tableau-server-signin1.png
----------------------------------------------------------------------
diff --git a/_docs/img/tableau-server-signin1.png b/_docs/img/tableau-server-signin1.png
new file mode 100644
index 0000000..6157e07
Binary files /dev/null and b/_docs/img/tableau-server-signin1.png differ
http://git-wip-us.apache.org/repos/asf/drill/blob/4f410f97/_docs/img/tableau-server-signin2.png
----------------------------------------------------------------------
diff --git a/_docs/img/tableau-server-signin2.png b/_docs/img/tableau-server-signin2.png
new file mode 100644
index 0000000..ecd332e
Binary files /dev/null and b/_docs/img/tableau-server-signin2.png differ
http://git-wip-us.apache.org/repos/asf/drill/blob/4f410f97/_docs/odbc-jdbc-interfaces/080-using-apache-drill-with-tableau-9-server.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/080-using-apache-drill-with-tableau-9-server.md b/_docs/odbc-jdbc-interfaces/080-using-apache-drill-with-tableau-9-server.md
new file mode 100644
index 0000000..92e4dc2
--- /dev/null
+++ b/_docs/odbc-jdbc-interfaces/080-using-apache-drill-with-tableau-9-server.md
@@ -0,0 +1,76 @@
+---
+title: "Using Apache Drill with Tableau 9 Server"
+parent: "ODBC/JDBC Interfaces"
+---
+
+This document describes how to connect Tableau 9 Server to Apache Drill and explore multiple data formats instantly on Hadoop, as well as share all the Tableau visualizations in a collaborative environment. Use the combined power of these tools to get direct access to semi-structured data, without having to rely on IT teams for schema creation and data manipulation.
+
+To use Apache Drill with Tableau 9 Server, complete the following steps:
+
+1. Install the Drill ODBC driver from MapR on the Tableau Server system and configure ODBC data sources.
2. Install the Tableau Data-connection Customization (TDC) file.
3. Publish Tableau visualizations and data sources from Tableau Desktop to Tableau Server for collaboration.
+
+----------
+
+### Step 1: Install and Configure the MapR Drill ODBC Driver
+
+Drill uses standard ODBC connectivity to provide easy data-exploration capabilities on complex, schema-less data sets. For the best experience use the latest release of Apache Drill. For Tableau 9.0 Server, Drill Version 0.9 or higher is recommended.
+
+Complete the following steps to install and configure the driver:
+
+1. Download the 64-bit MapR Drill ODBC Driver for Windows from the following location:<br> [http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/)
+**Note:** Tableau 9.0 Server works with the 64-bit ODBC driver.
+2. Complete steps 2-8 under on the following page to install the driver:<br>
+[http://drill.apache.org/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows/](http://drill.apache.org/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows/)
+3. Complete the steps on the following page to configure the driver:<br>
+[http://drill.apache.org/docs/step-2-configure-odbc-connections-to-drill-data-sources/](http://drill.apache.org/docs/step-2-configure-odbc-connections-to-drill-data-sources/)
+4. If Drill authentication is enabled, select **Basic Authentication** as the authentication type. Enter a valid user and password. 
+
+Note: If you select **ZooKeeper Quorum** as the ODBC connection type, the client system must be able to resolve the hostnames of the ZooKeeper nodes. The simplest way is to add the hostnames and IP addresses for the ZooKeeper nodes to the `%WINDIR%\system32\drivers\etc\hosts` file. 
Also make sure to test the ODBC connection to Drill before using it with Tableau.
+
+----------
+
+### Step 2: Install the Tableau Data-connection Customization (TDC) File
+
+The MapR Drill ODBC Driver includes a file named `MapRDrillODBC.TDC`. The TDC file includes customizations that improve ODBC configuration and performance when using Tableau.
+
+For Tableau Server, you need to manually copy this file to the Server Datasources folder:
+
1. Locate the `MapRDrillODBC.tdc` file in the `~\Program Files\MapR Drill ODBC Driver\Resources` folder.
2. Copy the file to the `~\ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Datasources` folder.
3. Restart Tableau Server.
+
+For more information about Tableau TDC configuration, see [Customizing and Tuning ODBC Connections](http://kb.tableau.com/articles/knowledgebase/customizing-odbc-connections)
+
+----------
+
+
+### Step 3: Publish Tableau Visualizations and Data Sources
+
+For collaboration purposes, you can now use Tableau Desktop to publish data sources and visualizations on Tableau Server.
+
+####Publishing Visualizations
+
+To publish a visualization from Tableau Desktop to Tableau Server:
1. Configure Tableau Desktop by using the ODBC driver; see []()
2. For best results, verify that the ODBC configuration and DSNs (data source names) are the same for both Tableau Desktop and Tableau Server.
3. Create visualizations in Tableau Desktop using Drill as the data source.
4. Connect to Tableau Server from Tableau Desktop. Select **Server > Sign In**. 
+
+5. Sign into Tableau Server using the server hostname or IP address, username, and password. 
+
+6. You can now publish a workbook to Tableau Server. Select **Server > Publish Workbook**. 
+
+7. Select the project from the drop-down list. Enter a name for the visualization to be published and provide a description and tags as needed. Assign permissions and views to be shared. Then click **Authentication**. 
+
+8. In the Authentication window, select **Embedded Password**, then click **OK**. Then click **Publish** in the Publish Workbook window to publish the visualization to Tableau Server. 
+
+####Publishing Data Sources
+
+If all you want to do is publish data sources to Tableau Server, follow these steps:
+
1. Open data source(s) in Tableau Desktop.
2. In the Workbook, select **Data > Data Source Name > Publish to Server**. 
3. If you are not already signed in, sign into Tableau Server.
4. Select the project from the drop-down list and enter a name for the data source (or keep the same name that is used in the Desktop workbook). 
5. In the **Authentication** drop-down list, select **Embedded Password**. Select permissions as needed, then click **Publish**. The data source will now be published on the Tableau Server and is available for building visualizations. 
+
+
+
+
+
+
+
+
+
+----------
+
+In this quick tutorial, you saw how you can configure Tableau Server 9.0 to work with Tableau Desktop and Apache Drill.
+