You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by br...@apache.org on 2015/10/16 00:33:03 UTC
drill git commit: edits to Qlik Sense doc
Repository: drill
Updated Branches:
refs/heads/gh-pages 76751f5dc -> 0c9fd5eb8
edits to Qlik Sense doc
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/0c9fd5eb
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/0c9fd5eb
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/0c9fd5eb
Branch: refs/heads/gh-pages
Commit: 0c9fd5eb8791751b448d1375db539de315690a89
Parents: 76751f5
Author: Bridget Bevens <bb...@maprtech.com>
Authored: Thu Oct 15 15:30:50 2015 -0700
Committer: Bridget Bevens <bb...@maprtech.com>
Committed: Thu Oct 15 15:30:50 2015 -0700
----------------------------------------------------------------------
.../045-using-qliksense-with-drill.md | 121 -------------------
.../055-using-qliksense-with-drill.md | 120 ++++++++++++++++++
2 files changed, 120 insertions(+), 121 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill/blob/0c9fd5eb/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/045-using-qliksense-with-drill.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/045-using-qliksense-with-drill.md b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/045-using-qliksense-with-drill.md
deleted file mode 100644
index 78042bd..0000000
--- a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/045-using-qliksense-with-drill.md
+++ /dev/null
@@ -1,121 +0,0 @@
----
-title: "Using Qlik Sense with Drill"
-parent: "Using Drill with BI Tools"
----
-You can use the Qlik Sense BI tool with Apache Drill, the SQL query engine for Big Data exploration, to access and analyze structured and semi-structured data in multiple data stores.
-
-This document provides you with the procedures required to connect Qlik Sense Desktop and Qlik Sense Server to Apache Drill via ODBC.
-
-**Prerequisites**
-
-* Apache Drill installed. See [Install Drill]({{site.baseurl}}/docs/install-drill/).
-* Qlik Sense installed. See [Qlik Sense](http://drill.apache.org/docs/install-drill/).
-
-
-To use Qlik Sense with Apache Drill, complete the following steps:
-
-1. Install and configure the Drill ODBC driver.
-2. Configure a connection in Qlik Sense.
-3. Authenticate.
-4. Select tables and load the data model.
-5. Analyze data with Qlik Sense and Drill.
-
-
-----------
-
-
-### Step 1: Install and Configure the Drill ODBC Driver
-
-Drill uses standard ODBC connectivity to provide easy data exploration capabilities on complex, schema-less data sets. Verify that the ODBC driver version that you download correlates with the Apache Drill version that you use. Ideally, you should upgrade to the latest version of Apache Drill and the MapR Drill ODBC Driver.
-
-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/)
-2. [Install the driver]({{site.baseurl}}/docs/installing-the-driver-on-windows).
-3. [Configure ODBC]({{site.baseurl}}/docs/configuring-odbc-on-windows).
-
-----------
-
-
-### Step 2: Configure a Connection in Qlik Sense
-Once you create an ODBC DSN, it shows up as another option when you create a connection from a new and/or existing Qlik Sense application. The steps for creating a connection from an application are the same in Qlik Sense Desktop and Qlik Sense Server.
-
-Complete the following steps to configure a Drill data connection:
-
-1. In the Data Load Editor, click **Create new connection**.
-2. Select the **ODBC** option.
-3. Click either the **User** or **System DSN** button, depending on whether the DSN was created as a User or System DSN.
-4. Select the appropriate DSN and provide the credentials, and name the connection accordingly.
-
-
-----------
-### Step 3: Authenticate
-After providing the credentials and saving the connection, click **Select** in the new connection to trigger the authentication against Drill.
-
-
-
-Based on the user’s credentials, security and filtration are applied accordingly. Different users may see a different number of tables and/or a different number of fields per table. For example, multiple types of users may use the same connection, but they may see a different number of tables and columns per table. For example, a manager may only see one table and a few fields in the table:
-
-
-
-While an Executive may have access to more tables and more fields per table:
-
-
-
-----------
-
-### Step 4: Select Tables and Load the Data Model
-
-Explore the various tables available in Drill, and select the tables of interest. For each table selected, Qlik Sense shows a preview of the logic used for the table:
-
-
-
-Notice that the metadata information that comes with each table is also accessible through the same window:
-
-
-
-Click **Insert Script** to add a new table as part of the associative data model that the Qlik Sense application creates. There are two of ways in which you can make a new table part of the data model:
-
-1. Load the data from the table into the memory of the Qlik Sense Server.
-2. Keep the data at the source and only capture the new table as part of the data model (this is called Direct Discovery). In order to learn more about Direct Discovery, see [http://www.qlik.com/us/explore/resources/whitepapers/qlikview-and-big-data](http://www.qlik.com/us/explore/resources/whitepapers/qlikview-and-big-data).
-
-{% include startnote.html %}After you select the tables that you want to include, verify that the top part of the script is set to the following, otherwise the load fails.{% include endnote.html %}
-
- SET DirectIdentifierQuoteChar="`"
-
-
-
-When the data model is complete, click **Load Data**. Verify that the load is completed successfully.
-
-
-
-If a Direct Discovery is used, the syntax of the script, as well as the messages that Qlik Sense displays while loading the data model vary slightly.
-
-
-
-----------
-
-### Step 5: Analyze Data with Qlik Sense and Drill
-
-After the data model is loaded into the application, use Qlik Sense to build a wide range of visualizations on top of the data that Drill delivers via ODBC. Qlik Sense specializes in self-service data visualization at the point of decision.
-
-
-
-If you use Direct Discovery to build the application, the application becomes a hybrid application. This means that some of the fields and tables are kept in memory as part of the application definition while other tables are kept in the data model only at the metadata level while the data behind them resides at the source. In such cases, any given visualization could end up representing the combination of in memory data and data polled in real time from Drill.
-
-
-
-----------
-
-### Summary
-Together, Drill and Qlik Sense can provide a wide range of solutions that enable organizations to analyze all of their data and efficiently find solutions to various business problems.
-
-To continue exploring Qlik Sense and download Qlik Sense Desktop, visit:
-[http://www.qlik.com/us/explore/products/sense](http://www.qlik.com/us/explore/products/sense)
-
-For more information about Drill, visit:
-[drill.apache.org](drill.apache.org)
-
-
-
-
http://git-wip-us.apache.org/repos/asf/drill/blob/0c9fd5eb/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/055-using-qliksense-with-drill.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/055-using-qliksense-with-drill.md b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/055-using-qliksense-with-drill.md
new file mode 100644
index 0000000..ad27cd9
--- /dev/null
+++ b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/055-using-qliksense-with-drill.md
@@ -0,0 +1,120 @@
+---
+title: "Using Qlik Sense with Drill"
+parent: "Using Drill with BI Tools"
+---
+You can use the Qlik Sense BI tool with Apache Drill, the SQL query engine for Big Data exploration, to access and analyze structured and semi-structured data in multiple data stores.
+
+This document provides you with the procedures required to connect Qlik Sense Desktop and Qlik Sense Server to Apache Drill via ODBC.
+
+To use Qlik Sense with Apache Drill, complete the following steps:
+
+1. Install and configure the Drill ODBC driver.
+2. Configure a connection in Qlik Sense.
+3. Authenticate.
+4. Select tables and load the data model.
+5. Analyze data with Qlik Sense and Drill.
+
+**Prerequisites**
+
+* Apache Drill installed. See [Install Drill]({{site.baseurl}}/docs/install-drill/).
+* Qlik Sense installed. See [Qlik Sense](http://www.qlik.com/us/explore/products/sense).
+
+
+----------
+
+
+### Step 1: Install and Configure the Drill ODBC Driver
+
+Drill uses standard ODBC connectivity to provide easy data exploration capabilities on complex, schema-less data sets. Verify that the ODBC driver version that you download correlates with the Apache Drill version that you use. Ideally, you should upgrade to the latest version of Apache Drill and the MapR Drill ODBC Driver.
+
+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/)
+2. [Install the driver]({{site.baseurl}}/docs/installing-the-driver-on-windows).
+3. [Configure ODBC]({{site.baseurl}}/docs/configuring-odbc-on-windows).
+
+----------
+
+
+### Step 2: Configure a Connection in Qlik Sense
+Once you create an ODBC DSN, it shows up as another option when you create a connection from a new and/or existing Qlik Sense application. The steps for creating a connection from an application are the same in Qlik Sense Desktop and Qlik Sense Server.
+
+Complete the following steps to configure a Drill data connection:
+
+1. In the Data Load Editor, click **Create new connection**.
+2. Select the **ODBC** option.
+3. Click either the **User** or **System DSN** button, depending on whether the DSN was created as a User or System DSN.
+4. Select the appropriate DSN and provide the credentials, and name the connection accordingly.
+
+
+----------
+### Step 3: Authenticate
+After providing the credentials and saving the connection, click **Select** in the new connection to trigger the authentication against Drill.
+
+
+
+Based on the user’s credentials, security and filtration are applied accordingly. Different users may see a different number of tables and/or a different number of fields per table. For example, multiple types of users may use the same connection, but they may see a different number of tables and columns per table. For example, a manager may only see one table and a few fields in the table.
+
+
+
+While an Executive may have access to more tables and more fields per table.
+
+
+
+----------
+
+### Step 4: Select Tables and Load the Data Model
+
+Explore the various tables available in Drill, and select the tables of interest. For each table selected, Qlik Sense shows a preview of the logic used for the table.
+
+
+
+Notice that the metadata information that comes with each table is also accessible through the same window.
+
+
+
+Click **Insert Script** to add a new table as part of the associative data model that the Qlik Sense application creates. There are two of ways in which you can make a new table part of the data model.
+
+1. Load the data from the table into the memory of the Qlik Sense Server.
+2. Keep the data at the source and only capture the new table as part of the data model (this is called Direct Discovery). In order to learn more about Direct Discovery, see [http://www.qlik.com/us/explore/resources/whitepapers/qlikview-and-big-data](http://www.qlik.com/us/explore/resources/whitepapers/qlikview-and-big-data).
+
+{% include startnote.html %}After you select the tables that you want to include, verify that the top part of the script is set to the following, otherwise the load fails:{% include endnote.html %}
+
+ SET DirectIdentifierQuoteChar="`"
+
+
+
+When the data model is complete, click **Load Data**. Verify that the load is completed successfully.
+
+
+
+If a Direct Discovery is used, the syntax of the script, as well as the messages that Qlik Sense displays while loading the data model vary slightly.
+
+
+
+----------
+
+### Step 5: Analyze Data with Qlik Sense and Drill
+
+After the data model is loaded into the application, use Qlik Sense to build a wide range of visualizations on top of the data that Drill delivers via ODBC. Qlik Sense specializes in self-service data visualization at the point of decision.
+
+
+
+If you use Direct Discovery to build the application, the application becomes a hybrid application. This means that some of the fields and tables are kept in memory as part of the application definition while other tables are kept in the data model only at the metadata level while the data behind them resides at the source. In such cases, any given visualization could end up representing the combination of in memory data and data polled in real time from Drill.
+
+
+
+----------
+
+### Summary
+Together, Drill and Qlik Sense can provide a wide range of solutions that enable organizations to analyze all of their data and efficiently find solutions to various business problems.
+
+To continue exploring Qlik Sense and download Qlik Sense Desktop, visit
+[http://www.qlik.com/us/explore/products/sense](http://www.qlik.com/us/explore/products/sense)
+
+For more information about Drill, visit
+[http://drill.apache.org/](http://drill.apache.org/)
+
+
+
+