drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tshi...@apache.org
Subject [24/25] drill git commit: Tableau Server doc
Date Tue, 12 May 2015 05:57:06 GMT
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 <brumsby@mapr.com>
Authored: Mon May 11 18:16:40 2015 -0700
Committer: Bob Rumsby <brumsby@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. ![drill query flow]({{ site.baseurl }}/docs/img/tableau-odbc-setup.png)
+
+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.
![drill query flow]({{ site.baseurl }}/docs/img/tableau-odbc-setup-2.png)

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**. ![drill query flow]({{ site.baseurl
}}/docs/img/tableau-server-signin1.png)
+
+5. Sign into Tableau Server using the server hostname or IP address, username, and password.
![drill query flow]({{ site.baseurl }}/docs/img/tableau-server-signin2.png)
+
+6. You can now publish a workbook to Tableau Server. Select **Server > Publish Workbook**.
![drill query flow]({{ site.baseurl }}/docs/img/tableau-server-publish1.png)
+
+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**. ![drill query flow]({{ site.baseurl }}/docs/img/tableau-server-publish2.png)
+
+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.
![drill query flow]({{ site.baseurl }}/docs/img/tableau-server-authentication.png)
+
+####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**. ![drill query flow]({{ site.baseurl }}/docs/img/tableau-server-publish-datasource.png)

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). ![drill query flow]({{ site.baseurl }}/docs/img/tableau-server-publish-datasource2.png)

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. ![drill query flow]({{ site.baseurl }}/docs/img/tableau-server-publish-datasource3.png)
+
+
+
+
+
+
+
+
+
+----------
+
+In this quick tutorial, you saw how you can configure Tableau Server 9.0 to work with Tableau
Desktop and Apache Drill. 
+


Mime
View raw message