Author: lidong
Date: Fri Sep 27 14:11:25 2019
New Revision: 1867636

URL: http://svn.apache.org/viewvc?rev=1867636&view=rev
Log:
Added blog entry 2019-09-22-kylin-tableau.md describing how to connect Tableau 
with Kylin

Added:
    kylin/site/blog/2019/09/
    kylin/site/blog/2019/09/22/
    kylin/site/blog/2019/09/22/kylin-tableau/
    kylin/site/blog/2019/09/22/kylin-tableau/index.html
    kylin/site/images/blog/kylin-tableau/
    kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_server.jpg   (with 
props)
    kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_working.jpg   (with 
props)
    kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_working_sheet.jpg   
(with props)
    kylin/site/images/blog/kylin-tableau/tableau_kylin_connection.jpg   (with 
props)
    kylin/site/images/blog/kylin-tableau/tableau_other_databases_jdbc.jpg   
(with props)
Modified:
    kylin/site/blog/index.html
    kylin/site/feed.xml

Added: kylin/site/blog/2019/09/22/kylin-tableau/index.html
URL: 
http://svn.apache.org/viewvc/kylin/site/blog/2019/09/22/kylin-tableau/index.html?rev=1867636&view=auto
==============================================================================
--- kylin/site/blog/2019/09/22/kylin-tableau/index.html (added)
+++ kylin/site/blog/2019/09/22/kylin-tableau/index.html Fri Sep 27 14:11:25 2019
@@ -0,0 +1,6534 @@
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+<!doctype html>
+<html>
+       <!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<head>
+  <meta charset="utf-8">
+  <meta http-equiv="X-UA-Compatible" content="IE=edge">
+  <meta name="viewport" content="width=device-width, initial-scale=1">
+
+  <title>Apache Kylin | Connecting Tableau Desktop and Tableau Server with 
Apache Kylin</title>
+  <meta name="description" content="BackgroundThis document describes how to 
connect Tableau to Apache Kylin OLAP server, particularly (but not only) in 
live mode to use both reporting and anal...">
+  <meta name="author"      content="Apache Kylin">
+  <link rel="shortcut icon" href="fav.png" type="image/png">
+
+
+
+<link rel="stylesheet" href="/assets/css/animate.css">
+<!-- Bootstrap -->
+<link rel="stylesheet" href="/assets/css/bootstrap.min.css">
+
+<!-- Fonts -->
+<!-- <link rel="stylesheet" 
href="http://fonts.googleapis.com/css?family=Alice|Open+Sans:400,300,700"> -->
+
+<!-- Icons -->
+<link rel="stylesheet" href="/assets/css/font-awesome.min.css">
+
+  <!-- Custom styles -->
+  <link rel="stylesheet" href="/assets/css/styles.css">
+  <link rel="stylesheet" href="/assets/css/docs.css">
+  <link rel="stylesheet" href="/assets/css/pygments.css">
+
+  <link rel="canonical" 
href="http://kylin.apache.org/blog/2019/09/22/kylin-tableau/";>
+  <link rel="alternate" type="application/rss+xml" title="Apache Kylin" 
href="http://kylin.apache.org/feed.xml"; />
+
+<!--[if lt IE 9]> <script src="assets/js/html5shiv.js"></script> <![endif]-->
+<!-- Global site tag (gtag.js) - Google Analytics -->
+<script async 
src="https://www.googletagmanager.com/gtag/js?id=UA-120788561-1";></script>
+<script>
+  window.dataLayer = window.dataLayer || [];
+  function gtag(){dataLayer.push(arguments);}
+  gtag('js', new Date());
+
+  gtag('config', 'UA-120788561-1');
+</script>
+<script type="text/javascript" src="/assets/js/jquery-1.9.1.min.js"></script>
+<script type="text/javascript" src="/assets/js/nside.js"></script> </script>
+<script type="text/javascript" src="/assets/js/nnav.js"></script> </script>
+<script>
+var _hmt = _hmt || [];
+(function() {
+  var hm = document.createElement("script");
+  hm.src = "https://hm.baidu.com/hm.js?bdc5e03add430c0b72cc0eb91eabfa99";;
+  var s = document.getElementsByTagName("script")[0]; 
+  s.parentNode.insertBefore(hm, s);
+})();
+</script>
+
+</head>
+
+       <body>
+               <!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<header id="header" >
+  
+  <!-- Main Menu -->
+  <nav class="navbar navbar-default" role="navigation" id="nav-wrapper">
+    <div class="container-fluid" id="nav">
+      <!--
+      <img class="img-circle" width="40px" height="40px" id="circlelogo" 
src="/assets/images/kylin_logo.jpg">
+      -->
+      <!-- Brand and toggle get grouped for better mobile display -->
+      <div class="navbar-header">
+        <img class="navbar-logo" width="46" 
src="/assets/images/kylin_logo.png" ></img>
+        <button type="button" class="navbar-toggle collapsed" 
data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
+          <span class="sr-only">Toggle navigation</span>
+          <span class="icon-bar"></span>
+          <span class="icon-bar"></span>
+          <span class="icon-bar"></span>
+        </button>
+        <ul class="nav icon-navbar">
+            <li class="li-search">
+              <div>
+                <form target="_blank" autocomplete="false" 
action="https://sematext.com/opensee/big-data";>
+                  <input type="hidden" name="project" value="kylin">
+                  <div class="form-group search-container">
+                    <input type="text" autocomplete="false" 
class="form-control" name="q" placeholder="Search...">
+                    <div class="search fa fa-search fa-lg"></div>
+                  </div>
+                </form>
+              </div>
+              <!-- <a href="https://twitter.com/apachekylin"; target="_blank" 
class="fa fa-search fa-lg"  title="Search: @ApacheKylin" ></a> -->
+            </li>
+            <li><a href="https://twitter.com/apachekylin"; target="_blank" 
class="fa fa-twitter fa-lg"  title="Twitter: @ApacheKylin" ></a></li>
+            <li><a href="https://github.com/apache/kylin"; target="_blank" 
class="fa fa-github-alt fa-lg" title="Github: apache/kylin" ></a></li>
+            <li><a href="https://www.facebook.com/kylinio"; target="_blank" 
class="fa fa-facebook fa-lg" title="Facebook: kylin.io" ></a></li>
+        </ul>
+      </div>
+
+      <!-- Collect the nav links, forms, and other content for toggling -->
+      <div class="navbar-collapse collapse" id="bs-example-navbar-collapse-1">
+
+        <ul class="nav navbar-nav">
+
+          <li><a href="/">Home</a></li>
+          <li>
+            <a href="/docs">Docs</a>
+<!--        
+            <a href="#" class="dropdown-toggle" 
data-toggle="dropdown">Docs</a>     
+            <ul class="dropdown-menu">
+              
+                  <li class="dropdown-submenu"><a href="#titleGetting Started" 
data-toggle="collapse" class="navtitle">Getting Started</a>
+                  <ul class="dropdown-menu">
+                  
+
+
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/index.html" class="list-group-item-lay 
pjaxlink">Overview</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/release_notes.html" class="list-group-item-lay 
pjaxlink">Release Notes</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/gettingstarted/concepts.html" 
class="list-group-item-lay pjaxlink">Technical Concepts</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/gettingstarted/terminology.html" 
class="list-group-item-lay pjaxlink">Terminology</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/gettingstarted/faq.html" class="list-group-item-lay 
pjaxlink">FAQ</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/gettingstarted/events.html" class="list-group-item-lay 
pjaxlink">Events and Conferences</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+      <li class="navlist">
+        <a href="/docs/gettingstarted/best_practices.html" 
class="list-group-item-lay pjaxlink">Community Best Practices</a>
+      </li>      
+      
+
+
+
+
+
+
+
+                  <ul>
+                  </li>
+              
+                  <li class="dropdown-submenu"><a href="#titleInstallation" 
data-toggle="collapse" class="navtitle">Installation</a>
+                  <ul class="dropdown-menu">
+                  
+
+
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/install/index.html" class="list-group-item-lay 
pjaxlink">Installation Guide</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/install/kylin_cluster.html" class="list-group-item-lay 
pjaxlink">Deploy in Cluster Mode</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/install/configuration.html" class="list-group-item-lay 
pjaxlink">Kylin Configuration</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/install/kylin_aws_emr.html" class="list-group-item-lay 
pjaxlink">Install Kylin on AWS EMR</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/install/kylin_docker.html" class="list-group-item-lay 
pjaxlink">Run Kylin with Docker</a>
+      </li>      
+      
+
+
+
+
+
+
+
+                  <ul>
+                  </li>
+              
+                  <li class="dropdown-submenu"><a href="#titleTutorial" 
data-toggle="collapse" class="navtitle">Tutorial</a>
+                  <ul class="dropdown-menu">
+                  
+
+
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/kylin_sample.html" class="list-group-item-lay 
pjaxlink">Quick Start with Sample Cube</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/web.html" class="list-group-item-lay 
pjaxlink">Web Interface</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/create_cube.html" class="list-group-item-lay 
pjaxlink">Cube Wizard</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/cube_build_job.html" 
class="list-group-item-lay pjaxlink">Cube Build and Job Monitoring</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/sql_reference.html" class="list-group-item-lay 
pjaxlink">SQL Reference</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/project_table_level_acl.html" 
class="list-group-item-lay pjaxlink">Project And Table Level ACL</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/cube_spark.html" class="list-group-item-lay 
pjaxlink">Build Cube with Spark</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/cube_streaming.html" 
class="list-group-item-lay pjaxlink">Scalable Cubing from Kafka</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/cube_build_performance.html" 
class="list-group-item-lay pjaxlink">Cube Build Tuning</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/kylin_client_tool.html" 
class="list-group-item-lay pjaxlink">Kylin Python Client</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/setup_systemcube.html" 
class="list-group-item-lay pjaxlink">Set Up System Cube</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/use_cube_planner.html" 
class="list-group-item-lay pjaxlink">Use Cube Planner</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/use_dashboard.html" class="list-group-item-lay 
pjaxlink">Use Dashboard</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/setup_jdbc_datasource.html" 
class="list-group-item-lay pjaxlink">Setup JDBC Data Source</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/hybrid.html" class="list-group-item-lay 
pjaxlink">Hybrid Model</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/mysql_metastore.html" 
class="list-group-item-lay pjaxlink">Use MySQL as Metastore</a>
+      </li>      
+      
+
+
+
+
+
+
+
+                  <ul>
+                  </li>
+              
+                  <li class="dropdown-submenu"><a href="#titleIntegration" 
data-toggle="collapse" class="navtitle">Integration</a>
+                  <ul class="dropdown-menu">
+                  
+
+
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/odbc.html" class="list-group-item-lay 
pjaxlink">Kylin ODBC Driver</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/jdbc.html" class="list-group-item-lay 
pjaxlink">Kylin JDBC Driver</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/tableau.html" class="list-group-item-lay 
pjaxlink">Tableau 8</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/tableau_91.html" class="list-group-item-lay 
pjaxlink">Tableau 9</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/powerbi.html" class="list-group-item-lay 
pjaxlink">MS Excel and Power BI</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/microstrategy.html" class="list-group-item-lay 
pjaxlink">MicroStrategy</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/squirrel.html" class="list-group-item-lay 
pjaxlink">SQuirreL</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/flink.html" class="list-group-item-lay 
pjaxlink">Apache Flink</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/spark.html" class="list-group-item-lay 
pjaxlink">Apache Spark</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/hue.html" class="list-group-item-lay 
pjaxlink">Hue</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/Qlik.html" class="list-group-item-lay 
pjaxlink">Qlik Sense</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/tutorial/superset.html" class="list-group-item-lay 
pjaxlink">Superset</a>
+      </li>      
+      
+
+
+
+
+
+
+
+                  <ul>
+                  </li>
+              
+                  <li class="dropdown-submenu"><a href="#titleHow To" 
data-toggle="collapse" class="navtitle">How To</a>
+                  <ul class="dropdown-menu">
+                  
+
+
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/howto/howto_use_restapi.html" 
class="list-group-item-lay pjaxlink">Use RESTful API</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/howto/howto_build_cube_with_restapi.html" 
class="list-group-item-lay pjaxlink">Build Cube with API</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/howto/howto_optimize_cubes.html" 
class="list-group-item-lay pjaxlink">Optimize Cube Design</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/howto/howto_optimize_build.html" 
class="list-group-item-lay pjaxlink">Optimize Cube Build</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/howto/howto_backup_metadata.html" 
class="list-group-item-lay pjaxlink">Backup Metadata</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/howto/howto_cleanup_storage.html" 
class="list-group-item-lay pjaxlink">Cleanup Storage</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/howto/howto_upgrade.html" class="list-group-item-lay 
pjaxlink">Upgrade From Old Versions</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/howto/howto_use_cli.html" class="list-group-item-lay 
pjaxlink">Use Utility CLIs</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/howto/howto_ldap_and_sso.html" 
class="list-group-item-lay pjaxlink">Secure with LDAP and SSO</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/howto/howto_use_beeline.html" 
class="list-group-item-lay pjaxlink">Use Beeline for Hive</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/howto/howto_update_coprocessor.html" 
class="list-group-item-lay pjaxlink">Update Coprocessor</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/howto/howto_install_ranger_kylin_plugin.html" 
class="list-group-item-lay pjaxlink">Install Ranger Plugin</a>
+      </li>      
+      
+
+
+
+  
+      
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/docs/howto/howto_enable_zookeeper_acl.html" 
class="list-group-item-lay pjaxlink">Enable Zookeeper ACL</a>
+      </li>      
+      
+
+
+
+
+
+
+
+                  <ul>
+                  </li>
+              
+            </ul> -->
+          </li>
+          <li><a href="/download">Download</a></li>
+          <li><a href="/community" >Community</a></li>
+          <li><a href="/development" >Development</a></li>
+          <li><a href="/blog">Blog</a></li>
+          <li><a href="/cn" >中文版</a></li> 
+        </ul>     
+      </div><!-- /.navbar-collapse -->
+    </div><!-- /.container-fluid -->
+  </nav>
+
+  <div id="head" class="parallax normal-header" >
+    <div class="text-center header-apache">
+      <a href="http://apache.org/foundation/contributing.html"; title="Support 
Apache" style="margin-left: 150px;">
+        <div>
+          <img src="https://www.apache.org/images/SupportApache-small.png"; >
+        </div>
+      </a>
+    </div>  
+  </div>
+  
+ </header>
+
+               <div class="page-content main">
+                       <header style=" padding:2em 0 0 ">
+                       <div class="container" >
+                         <div style=" padding:0 4em">
+                <div class="blog-icon">
+                  <img width="30" src="/assets/images/icon_blog_w.png">
+                </div>
+                               <h4 class="index-title" style=" 
float:left;"><span>Apache Kylin™ Technical Blog</span></h4>
+                         </div>
+                       </div>
+               </div>
+
+               <div class="container blog">
+                       <div>
+                               <article class="post-content" > 
+                               <!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<div class="post" style=" padding:2em 4em 4em 4em">
+
+  <header class="post-header">
+    <h1 class="post-title">Connecting Tableau Desktop and Tableau Server with 
Apache Kylin</h1>
+    <p class="post-meta" >Sep 22, 2019 • Piotr Naszarkowski</p>
+  </header>
+
+  <article class="post-content" >
+    <h2 id="background">Background</h2>
+<p>This document describes how to connect Tableau to Apache Kylin OLAP server, 
particularly (but not only) in live mode to use both reporting and analytics 
features of Tableau together with Apache Kylin’s fast query processing 
engine. The configuration is platform independent - it works for both Windows 
and Linux installations of Tableau Server.</p>
+
+<p>For the time of writing this guide we tested that it works with Kylin 3.0.0 
and Tableau Server 2019.1.</p>
+
+<h2 id="prerequisites">Prerequisites</h2>
+<p>### Apache Kylin JDBC Driver<br />
+First we need to get Apache Kylin JDBC Driver - kylin-jdbc-X.Y.Z.jar file. You 
can either get it from the compiled package available on the download page 
http://kylin.apache.org/download/ from <code 
class="highlighter-rouge">lib</code> folder or compile it on your own using 
instructions below.</p>
+
+<p><em>Note</em>: To make JDBC driver work properly, there has been a fix 
recently https://github.com/apache/kylin/pull/739 that upgraded one of the 
libraries used by the driver. The fix was applied for version 3, so if for some 
reason you need a jar for earlier version, you have to apply the fix on the 
lower version’s codebase and compile yourself.<br />
+#### Compiling Apache Kylin JDBC Driver<br />
+<code class="highlighter-rouge">
+git clone https://github.com/apache/kylin.git 
+cd kylin
+mvn clean package -DskipTests -am -pl jdbc
+</code></p>
+
+<p>The compiled jar is located in the following location: <code 
class="highlighter-rouge">jdbc/target/kylin-jdbc-X.Y.Z.jar</code></p>
+
+<h3 id="tableau-server-on-linux">Tableau Server on Linux</h3>
+<p>If you have installed Tableau Server in a Linux box, e.g. CentOS, copy the 
driver’s jar file to the following location: <code 
class="highlighter-rouge">/opt/tableau/tableau_driver/jdbc/</code> and restart 
Tableau Server. <br />
+The server is now ready to create and refresh data from Apache Kylin.</p>
+
+<h3 id="tableau-server-and-tableau-desktop-on-windows">Tableau Server and 
Tableau Desktop on Windows</h3>
+<p>For either Tableau Server or Tableau Desktop that is installed on a Windows 
machine, copy the driver’s jar file to the following location <code 
class="highlighter-rouge">C:\Program Files\Tableau\Drivers</code> and restart 
Tableau Server or reopen Tableau Desktop.</p>
+
+<p>Some more details regarding jdbc connection from Tableau are well described 
in Tableau’s documentation: 
https://onlinehelp.tableau.com/current/pro/desktop/en-us/examples_otherdatabases_jdbc.htm.</p>
+
+<h2 
id="creating-report-in-tableau-desktop---connecting-to-apache-kylin">Creating 
report in Tableau Desktop - connecting to Apache Kylin</h2>
+<p>To create report follow the steps:<br />
+1. Open Tableau Desktop<br />
+2. Use “Other Databases (JDBC)” to create connection for the data 
source</p>
+
+<p><img src="/images/blog/kylin-tableau/tableau_other_databases_jdbc.jpg" 
alt="Other Databases (JDBC)" /></p>
+
+<ol>
+  <li>Configure the connection in the following way:
+    <ul>
+      <li>URL: <code 
class="highlighter-rouge">jdbc:kylin://&lt;kylin-server-name&gt;:&lt;kylin-port&gt;/&lt;project&gt;</code></li>
+      <li>Dialect: <code class="highlighter-rouge">SQL92</code></li>
+    </ul>
+  </li>
+</ol>
+
+<p><img src="/images/blog/kylin-tableau/tableau_kylin_connection.jpg" 
alt="Datasource connection" /></p>
+
+<ol>
+  <li>Configure data source as follows:
+    <ul>
+      <li>Database: <code class="highlighter-rouge">defaultCatalog</code></li>
+      <li>Schema: <code class="highlighter-rouge">DEFAULT</code></li>
+    </ul>
+  </li>
+</ol>
+
+<p>You should be able to see the tables/cubes in the Apache Kylin’s 
project</p>
+
+<p><img src="/images/blog/kylin-tableau/kylin_jdbc_tableau_working.jpg" 
alt="Data source" /></p>
+
+<p><strong>Important</strong>: Decide if you want the data source be in <code 
class="highlighter-rouge">live</code> or <code 
class="highlighter-rouge">extract</code> mode. Some of the functions might not 
work in <code class="highlighter-rouge">live</code> mode as for the other data 
sources - it’s just how Tableau works. Recommendation is to start with <code 
class="highlighter-rouge">live</code> mode to utilize performance of Apache 
Kylin. If you’re forced to switch to <code 
class="highlighter-rouge">extract</code> mode - consider creating a custom 
query against Apache Kylin’s cubes to retrieve as small amount of data as 
possible as it will help the report to perform well.</p>
+
+<ol>
+  <li>Finish designing your data source and then switch to worksheets, 
dashboards</li>
+</ol>
+
+<p><img src="/images/blog/kylin-tableau/kylin_jdbc_tableau_working_sheet.jpg" 
alt="Tableau Desktop" /></p>
+
+<h2 id="publishing-reports-from-tableau-desktop-to-tableau-server">Publishing 
reports from Tableau Desktop to Tableau Server</h2>
+<p>To publish the data source and the report follow these steps:<br />
+1. In Tableau Desktop from top menu select Server -&gt; Publish<br />
+2. Choose the settings for publishing like Project, select sheets<br />
+3. <strong>Important</strong>: For data source Authentication set <code 
class="highlighter-rouge">Embedded</code> - this is very important for data 
refresh to work, however keep in mind that the credentials will be embeded in 
the report then<br />
+4. Publish the report<br />
+5. Pop up should be displayed with the preview of the report rendered by the 
server</p>
+
+<p><img src="/images/blog/kylin-tableau/kylin_jdbc_tableau_server.jpg" 
alt="Tableau Server" /></p>
+
+<p>Verify if the report is displaying properly and can connect to Apache Kylin 
correctly by opening it directly in Tableau Server web application.</p>
+
+  </article>
+
+</div>
+
+
+
+
+
+                               </article>
+                       </div>
+               </div>          
+               <!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<footer id="underfooter">
+    <div>
+        <div class="row">
+            <div class="col-md-12 widget">
+                <div class="widget-body">
+                    <div class="footer-img">
+                        <a href="http://www.apache.org";>
+                            <img id="asf-logo" height="78px" alt="Apache 
Software Foundation" src="/assets/images/apache_footer.png">
+                        </a>
+                    </div>
+                    <p style="padding-top: 11px;">
+                        The contents of this website are © 2015 Apache 
Software Foundation under the terms of the 
+                        <a href="http://www.apache.org/licenses/LICENSE-2.0";> 
Apache License v2 </a>. 
+                    </p>
+                    <p style="margin-bottom: 11px;">    
+                        Apache Kylin and its logo are trademarks of the Apache 
Software Foundation.
+                    </div>
+
+                </div>
+            </div>
+        </div>
+        <!-- /row of widgets -->
+
+    </div>
+    <div></div>
+
+</footer>
+
+       <script src="/assets/js/jquery-1.9.1.min.js"></script> 
+       <script src="/assets/js/bootstrap.min.js"></script> 
+       <script src="/assets/js/main.js"></script>
+       </body>
+</html>
+
+
+
+

Modified: kylin/site/blog/index.html
URL: 
http://svn.apache.org/viewvc/kylin/site/blog/index.html?rev=1867636&r1=1867635&r2=1867636&view=diff
==============================================================================
--- kylin/site/blog/index.html (original)
+++ kylin/site/blog/index.html Fri Sep 27 14:11:25 2019
@@ -6367,6 +6367,16 @@ var _hmt = _hmt || [];
             
             
             <div class="col-md-6 col-lg-6 col-xs-12">
+              <a class="blog-card" href="/blog/2019/09/22/kylin-tableau/">
+                <div class="blog-pic">
+                  <img width="20" src="../assets/images/icon_blog_w.png" />
+                </div>
+                <p class="blog-title">Connecting Tableau Desktop and Tableau 
Server with Apache Kylin</p>
+                <p align="left" class="post-meta">posted: Sep 22, 2019</p>
+              </a>
+            </div>
+      
+            <div class="col-md-6 col-lg-6 col-xs-12">
               <a class="blog-card" 
href="/blog/2019/07/30/detailed-analysis-of-refine-query-cache/">
                 <div class="blog-pic">
                   <img width="20" src="../assets/images/icon_blog_w.png" />

Modified: kylin/site/feed.xml
URL: 
http://svn.apache.org/viewvc/kylin/site/feed.xml?rev=1867636&r1=1867635&r2=1867636&view=diff
==============================================================================
--- kylin/site/feed.xml (original)
+++ kylin/site/feed.xml Fri Sep 27 14:11:25 2019
@@ -19,11 +19,101 @@
     <description>Apache Kylin Home</description>
     <link>http://kylin.apache.org/</link>
     <atom:link href="http://kylin.apache.org/feed.xml"; rel="self" 
type="application/rss+xml"/>
-    <pubDate>Tue, 24 Sep 2019 06:59:42 -0700</pubDate>
-    <lastBuildDate>Tue, 24 Sep 2019 06:59:42 -0700</lastBuildDate>
+    <pubDate>Fri, 27 Sep 2019 06:59:31 -0700</pubDate>
+    <lastBuildDate>Fri, 27 Sep 2019 06:59:31 -0700</lastBuildDate>
     <generator>Jekyll v2.5.3</generator>
     
       <item>
+        <title>Connecting Tableau Desktop and Tableau Server with Apache 
Kylin</title>
+        <description>&lt;h2 id=&quot;background&quot;&gt;Background&lt;/h2&gt;
+&lt;p&gt;This document describes how to connect Tableau to Apache Kylin OLAP 
server, particularly (but not only) in live mode to use both reporting and 
analytics features of Tableau together with Apache Kylin’s fast query 
processing engine. The configuration is platform independent - it works for 
both Windows and Linux installations of Tableau Server.&lt;/p&gt;
+
+&lt;p&gt;For the time of writing this guide we tested that it works with Kylin 
3.0.0 and Tableau Server 2019.1.&lt;/p&gt;
+
+&lt;h2 id=&quot;prerequisites&quot;&gt;Prerequisites&lt;/h2&gt;
+&lt;p&gt;### Apache Kylin JDBC Driver&lt;br /&gt;
+First we need to get Apache Kylin JDBC Driver - kylin-jdbc-X.Y.Z.jar file. You 
can either get it from the compiled package available on the download page 
http://kylin.apache.org/download/ from &lt;code 
class=&quot;highlighter-rouge&quot;&gt;lib&lt;/code&gt; folder or compile it on 
your own using instructions below.&lt;/p&gt;
+
+&lt;p&gt;&lt;em&gt;Note&lt;/em&gt;: To make JDBC driver work properly, there 
has been a fix recently https://github.com/apache/kylin/pull/739 that upgraded 
one of the libraries used by the driver. The fix was applied for version 3, so 
if for some reason you need a jar for earlier version, you have to apply the 
fix on the lower version’s codebase and compile yourself.&lt;br /&gt;
+#### Compiling Apache Kylin JDBC Driver&lt;br /&gt;
+&lt;code class=&quot;highlighter-rouge&quot;&gt;
+git clone https://github.com/apache/kylin.git 
+cd kylin
+mvn clean package -DskipTests -am -pl jdbc
+&lt;/code&gt;&lt;/p&gt;
+
+&lt;p&gt;The compiled jar is located in the following location: &lt;code 
class=&quot;highlighter-rouge&quot;&gt;jdbc/target/kylin-jdbc-X.Y.Z.jar&lt;/code&gt;&lt;/p&gt;
+
+&lt;h3 id=&quot;tableau-server-on-linux&quot;&gt;Tableau Server on 
Linux&lt;/h3&gt;
+&lt;p&gt;If you have installed Tableau Server in a Linux box, e.g. CentOS, 
copy the driver’s jar file to the following location: &lt;code 
class=&quot;highlighter-rouge&quot;&gt;/opt/tableau/tableau_driver/jdbc/&lt;/code&gt;
 and restart Tableau Server. &lt;br /&gt;
+The server is now ready to create and refresh data from Apache Kylin.&lt;/p&gt;
+
+&lt;h3 id=&quot;tableau-server-and-tableau-desktop-on-windows&quot;&gt;Tableau 
Server and Tableau Desktop on Windows&lt;/h3&gt;
+&lt;p&gt;For either Tableau Server or Tableau Desktop that is installed on a 
Windows machine, copy the driver’s jar file to the following location 
&lt;code class=&quot;highlighter-rouge&quot;&gt;C:\Program 
Files\Tableau\Drivers&lt;/code&gt; and restart Tableau Server or reopen Tableau 
Desktop.&lt;/p&gt;
+
+&lt;p&gt;Some more details regarding jdbc connection from Tableau are well 
described in Tableau’s documentation: 
https://onlinehelp.tableau.com/current/pro/desktop/en-us/examples_otherdatabases_jdbc.htm.&lt;/p&gt;
+
+&lt;h2 
id=&quot;creating-report-in-tableau-desktop---connecting-to-apache-kylin&quot;&gt;Creating
 report in Tableau Desktop - connecting to Apache Kylin&lt;/h2&gt;
+&lt;p&gt;To create report follow the steps:&lt;br /&gt;
+1. Open Tableau Desktop&lt;br /&gt;
+2. Use “Other Databases (JDBC)” to create connection for the data 
source&lt;/p&gt;
+
+&lt;p&gt;&lt;img 
src=&quot;/images/blog/kylin-tableau/tableau_other_databases_jdbc.jpg&quot; 
alt=&quot;Other Databases (JDBC)&quot; /&gt;&lt;/p&gt;
+
+&lt;ol&gt;
+  &lt;li&gt;Configure the connection in the following way:
+    &lt;ul&gt;
+      &lt;li&gt;URL: &lt;code 
class=&quot;highlighter-rouge&quot;&gt;jdbc:kylin://&amp;lt;kylin-server-name&amp;gt;:&amp;lt;kylin-port&amp;gt;/&amp;lt;project&amp;gt;&lt;/code&gt;&lt;/li&gt;
+      &lt;li&gt;Dialect: &lt;code 
class=&quot;highlighter-rouge&quot;&gt;SQL92&lt;/code&gt;&lt;/li&gt;
+    &lt;/ul&gt;
+  &lt;/li&gt;
+&lt;/ol&gt;
+
+&lt;p&gt;&lt;img 
src=&quot;/images/blog/kylin-tableau/tableau_kylin_connection.jpg&quot; 
alt=&quot;Datasource connection&quot; /&gt;&lt;/p&gt;
+
+&lt;ol&gt;
+  &lt;li&gt;Configure data source as follows:
+    &lt;ul&gt;
+      &lt;li&gt;Database: &lt;code 
class=&quot;highlighter-rouge&quot;&gt;defaultCatalog&lt;/code&gt;&lt;/li&gt;
+      &lt;li&gt;Schema: &lt;code 
class=&quot;highlighter-rouge&quot;&gt;DEFAULT&lt;/code&gt;&lt;/li&gt;
+    &lt;/ul&gt;
+  &lt;/li&gt;
+&lt;/ol&gt;
+
+&lt;p&gt;You should be able to see the tables/cubes in the Apache Kylin’s 
project&lt;/p&gt;
+
+&lt;p&gt;&lt;img 
src=&quot;/images/blog/kylin-tableau/kylin_jdbc_tableau_working.jpg&quot; 
alt=&quot;Data source&quot; /&gt;&lt;/p&gt;
+
+&lt;p&gt;&lt;strong&gt;Important&lt;/strong&gt;: Decide if you want the data 
source be in &lt;code class=&quot;highlighter-rouge&quot;&gt;live&lt;/code&gt; 
or &lt;code class=&quot;highlighter-rouge&quot;&gt;extract&lt;/code&gt; mode. 
Some of the functions might not work in &lt;code 
class=&quot;highlighter-rouge&quot;&gt;live&lt;/code&gt; mode as for the other 
data sources - it’s just how Tableau works. Recommendation is to start with 
&lt;code class=&quot;highlighter-rouge&quot;&gt;live&lt;/code&gt; mode to 
utilize performance of Apache Kylin. If you’re forced to switch to &lt;code 
class=&quot;highlighter-rouge&quot;&gt;extract&lt;/code&gt; mode - consider 
creating a custom query against Apache Kylin’s cubes to retrieve as small 
amount of data as possible as it will help the report to perform well.&lt;/p&gt;
+
+&lt;ol&gt;
+  &lt;li&gt;Finish designing your data source and then switch to worksheets, 
dashboards&lt;/li&gt;
+&lt;/ol&gt;
+
+&lt;p&gt;&lt;img 
src=&quot;/images/blog/kylin-tableau/kylin_jdbc_tableau_working_sheet.jpg&quot; 
alt=&quot;Tableau Desktop&quot; /&gt;&lt;/p&gt;
+
+&lt;h2 
id=&quot;publishing-reports-from-tableau-desktop-to-tableau-server&quot;&gt;Publishing
 reports from Tableau Desktop to Tableau Server&lt;/h2&gt;
+&lt;p&gt;To publish the data source and the report follow these steps:&lt;br 
/&gt;
+1. In Tableau Desktop from top menu select Server -&amp;gt; Publish&lt;br /&gt;
+2. Choose the settings for publishing like Project, select sheets&lt;br /&gt;
+3. &lt;strong&gt;Important&lt;/strong&gt;: For data source Authentication set 
&lt;code class=&quot;highlighter-rouge&quot;&gt;Embedded&lt;/code&gt; - this is 
very important for data refresh to work, however keep in mind that the 
credentials will be embeded in the report then&lt;br /&gt;
+4. Publish the report&lt;br /&gt;
+5. Pop up should be displayed with the preview of the report rendered by the 
server&lt;/p&gt;
+
+&lt;p&gt;&lt;img 
src=&quot;/images/blog/kylin-tableau/kylin_jdbc_tableau_server.jpg&quot; 
alt=&quot;Tableau Server&quot; /&gt;&lt;/p&gt;
+
+&lt;p&gt;Verify if the report is displaying properly and can connect to Apache 
Kylin correctly by opening it directly in Tableau Server web 
application.&lt;/p&gt;
+</description>
+        <pubDate>Sun, 22 Sep 2019 13:30:00 -0700</pubDate>
+        <link>http://kylin.apache.org/blog/2019/09/22/kylin-tableau/</link>
+        <guid 
isPermaLink="true">http://kylin.apache.org/blog/2019/09/22/kylin-tableau/</guid>
+        
+        
+        <category>blog</category>
+        
+      </item>
+    
+      <item>
         <title>Detailed Analysis of refine query cache</title>
         <description>&lt;hr /&gt;
 
@@ -1454,85 +1544,6 @@ The checkpoint info is the smallest part
         
       </item>
     
-      <item>
-        <title>Apache Kylin v2.6.0 正式发布</title>
-        <description>&lt;p&gt;近日Apache Kylin 社区很高å…
´åœ°å®£å¸ƒï¼ŒApache Kylin 2.6.0 正式发布。&lt;/p&gt;
-
-&lt;p&gt;Apache Kylin 
是一个开源的分布式分析引擎,旨在为极大数据集提供 SQL 
接口和多维分析(OLAP)的能力。&lt;/p&gt;
-
-&lt;p&gt;这是继2.5.0 后的一个新功能版本。该版本引å…
¥äº†å¾ˆå¤šæœ‰ä»·å€¼çš„改进,完整的改动列表请参见&lt;a 
href=&quot;https://kylin.apache.org/docs/release_notes.html&quot;&gt;release 
notes&lt;/a&gt;;这里挑一些主要改进做说明:&lt;/p&gt;
-
-&lt;h3 id=&quot;jdbcsdk&quot;&gt;针对以JDBC为数据源的SDK&lt;/h3&gt;
-&lt;p&gt;Kylin目前已经支持通过JDBC连接包括Amazon Redshift, SQL 
Server在内的多种数据源。&lt;br /&gt;
-为了便于开发者更便利地处理各种 SQL 方言(dialect) 
的不同以更加简单地开发新的 JDBC 数据源,Kylin 
提供了相应的 SDK 和统一的 API 入口:&lt;br /&gt;
-* 同步元数据和数据&lt;br /&gt;
-* 构建 cube&lt;br /&gt;
-* 
当找不到相应的cube来解答查询时,下推查询到数据源&lt;/p&gt;
-
-&lt;p&gt;更多内容参见 KYLIN-3552。&lt;/p&gt;
-
-&lt;h3 id=&quot;memcached--kylin-&quot;&gt;使用 Memcached 作 Kylin 
的分布式缓存&lt;/h3&gt;
-&lt;p&gt;在过去,Kylin 
对查询结果的缓存不是十分高效,主要有以下两个方面的原å›
 ï¼š&lt;br /&gt;
-一个是当 Kylin 的 metadata 发生变化时,会主动盲目地去清
除大量缓存,使得缓存会被频繁刷新而导致利用率降低。&lt;br
 /&gt;
-另一点是由于只使用本地缓存而导致 Kylin server 之间不能å…
±äº«å½¼æ­¤çš„缓存,这样查询的缓存命中率就会降低。&lt;br /&gt;
-本地缓存的一个缺点是大小受到限制,不能像分布式缓存那æ
 ·æ°´å¹³æ‰©å±•ã€‚è¿™æ 
·å¯¼è‡´èƒ½ç¼“存的查询结果量受到了限制。&lt;/p&gt;
-
-&lt;p&gt;针对这些缺陷,我们改变了缓存失效的机制,不再主动去æ¸
…理缓存,而是采取如下的方案:&lt;br /&gt;
-1. 在将查询结果放入缓存之前,根据当前的å…
ƒæ•°æ®ä¿¡æ¯è®¡ç®—一个数字签名,并与查询结果一同放å…
¥ç¼“存中&lt;br /&gt;
-2. 从缓存中获取查询结果之后,根据当前的å…
ƒæ•°æ®ä¿¡æ¯è®¡ç®—一个数字签名,对比两者
的数字签名是否一致。如果一致,那么缓存有效;反之,该缓存失效并åˆ
 é™¤&lt;/p&gt;
-
-&lt;p&gt;我们还引入了 Memcached 作为 Kylin 的分布式缓存。这样 
Kylin server 之间可以共享查询结果的缓存,而且由于 Memcached 
server 之间的独立性,非常易于水平拓展,更加
有利于缓存更多的数据。&lt;br /&gt;
-相关开发任务是 KYLIN-2895, KYLIN-2894, KYLIN-2896, KYLIN-2897, 
KYLIN-2898, KYLIN-2899。&lt;/p&gt;
-
-&lt;h3 id=&quot;forkjoinpool--fast-cubing-&quot;&gt;ForkJoinPool 简化 fast 
cubing 的线程模型&lt;/h3&gt;
-&lt;p&gt;在过去进行 fast cubing 时,Kylin 
使用自己定义的一系列线程,如 split 线程,task 线程,main 
线程等等进行并发的 cube 构建。&lt;br /&gt;
-在这个线程模型中,线程之间的å…
³ç³»ååˆ†çš„复杂,而且对异常处理也十分容易出错。&lt;/p&gt;
-
-&lt;p&gt;现在我们引入了 ForkJoinPool,在主线程中处理 split 
逻辑,构建 cuboid 的任务以及子任务都在 fork join 
pool中执行,cuboid 
构建的结果可以被异步的收集并且可以更早地输出给下游的 
merge 操作。更多内容参见 KYLIN-2932。&lt;/p&gt;
-
-&lt;h3 id=&quot;hllcounter-&quot;&gt;改进 HLLCounter 的性能&lt;/h3&gt;
-&lt;p&gt;对于 HLLCounter, 我们从两方面进行了改进:构建 
HLLCounter 和计算调和平均的方式。&lt;br /&gt;
-1. 关于 HLLCounter 
的构建,我们不再使用merge的方式,而是直接copy别的HLLCounter里面的registers&lt;br
 /&gt;
-2. 关于计算 HLLCSnapshot 
里面的调和平均,做了以下三个方面的改进:&lt;br /&gt;
-* 缓存所有的1/2^r&lt;br /&gt;
-* 使用整型相加代替浮点型相加&lt;br /&gt;
-* 删除条件分支,例如无需检查 registers[i] 是不是为0&lt;/p&gt;
-
-&lt;p&gt;更多内容参见 KYLIN-3656。&lt;/p&gt;
-
-&lt;h3 id=&quot;cube-planner-&quot;&gt;改进 Cube Planner 算法&lt;/h3&gt;
-&lt;p&gt;在过去,cube planner 的 phase two 增加未被预计算的 
cuboid 的方式只能通过 mandatory cuboid 的方式。而一个 cuboid 
是否为 mandatory,又有两种方式:&lt;br /&gt;
-手动设置,查询时 rollup 
的行数足够大。这里通过判断查询时 rollup 
的行数是否足够大来判断是否为 mandatory cuboid 
的方式有两大缺陷:&lt;br /&gt;
-* 一是估算 rollup 的行数的算法不是很好&lt;br /&gt;
-* 二是很难设立一个静态的阈值来做判定&lt;/p&gt;
-
-&lt;p&gt;现在我们不再从 rollup 
行数的角度看问题了。一切都是从 cuboid 
行数的角度看问题,这样就和 cost based 的 cube planner 
算法做了统一。&lt;br /&gt;
-为此我们通过使用 rollup 比率来改进了未被预先构建的 cuboid 
的行数的估算,然后让 cost based 的 cube planner 
算法来判定哪些未被构建的 cuboid 
该被构建,哪些该被遗弃。&lt;br /&gt;
-通过这样的改进,无需通过设定静态的阈值来推荐 mandatory 
cuboid 了,而 mandatory cuboid 
只能被手动设置,不能被推荐了。更多内容参见 
KYLIN-3540。&lt;/p&gt;
-
-&lt;p&gt;&lt;strong&gt;下载&lt;/strong&gt;&lt;/p&gt;
-
-&lt;p&gt;要下载Apache Kylin v2.6.0源代码或二进制包,请访问&lt;a 
href=&quot;http://kylin.apache.org/download&quot;&gt;下载页面&lt;/a&gt; 
.&lt;/p&gt;
-
-&lt;p&gt;&lt;strong&gt;升级&lt;/strong&gt;&lt;/p&gt;
-
-&lt;p&gt;参考&lt;a 
href=&quot;/docs/howto/howto_upgrade.html&quot;&gt;升级指南&lt;/a&gt;.&lt;/p&gt;
-
-&lt;p&gt;&lt;strong&gt;反馈&lt;/strong&gt;&lt;/p&gt;
-
-&lt;p&gt;如果您遇到问题或疑问,请发送邮件至 Apache Kylin dev 
或 user 邮件列表:d...@kylin.apache.org,u...@kylin.apache.org; 
在发送之前,请确保您已通过发送电子邮件至 
dev-subscr...@kylin.apache.org 或 user-subscr...@kylin.apache.org订阅
了邮件列表。&lt;/p&gt;
-
-&lt;p&gt;&lt;em&gt;非常感谢所有贡献Apache 
Kylin的朋友!&lt;/em&gt;&lt;/p&gt;
-</description>
-        <pubDate>Fri, 18 Jan 2019 12:00:00 -0800</pubDate>
-        <link>http://kylin.apache.org/cn_blog/2019/01/18/release-v2.6.0/</link>
-        <guid 
isPermaLink="true">http://kylin.apache.org/cn_blog/2019/01/18/release-v2.6.0/</guid>
-        
-        
-        <category>cn_blog</category>
-        
-      </item>
-    
       <item>
         <title>Apache Kylin v2.6.0 Release Announcement</title>
         <description>&lt;p&gt;The Apache Kylin community is pleased to 
announce the release of Apache Kylin v2.6.0.&lt;/p&gt;

Added: kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_server.jpg
URL: 
http://svn.apache.org/viewvc/kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_server.jpg?rev=1867636&view=auto
==============================================================================
Binary file - no diff available.

Propchange: kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_server.jpg
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_working.jpg
URL: 
http://svn.apache.org/viewvc/kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_working.jpg?rev=1867636&view=auto
==============================================================================
Binary file - no diff available.

Propchange: kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_working.jpg
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_working_sheet.jpg
URL: 
http://svn.apache.org/viewvc/kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_working_sheet.jpg?rev=1867636&view=auto
==============================================================================
Binary file - no diff available.

Propchange: 
kylin/site/images/blog/kylin-tableau/kylin_jdbc_tableau_working_sheet.jpg
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: kylin/site/images/blog/kylin-tableau/tableau_kylin_connection.jpg
URL: 
http://svn.apache.org/viewvc/kylin/site/images/blog/kylin-tableau/tableau_kylin_connection.jpg?rev=1867636&view=auto
==============================================================================
Binary file - no diff available.

Propchange: kylin/site/images/blog/kylin-tableau/tableau_kylin_connection.jpg
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: kylin/site/images/blog/kylin-tableau/tableau_other_databases_jdbc.jpg
URL: 
http://svn.apache.org/viewvc/kylin/site/images/blog/kylin-tableau/tableau_other_databases_jdbc.jpg?rev=1867636&view=auto
==============================================================================
Binary file - no diff available.

Propchange: 
kylin/site/images/blog/kylin-tableau/tableau_other_databases_jdbc.jpg
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream


Reply via email to