You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by sh...@apache.org on 2018/07/25 03:10:04 UTC

[kylin] branch document updated: Apache Superset docs

This is an automated email from the ASF dual-hosted git repository.

shaofengshi pushed a commit to branch document
in repository https://gitbox.apache.org/repos/asf/kylin.git


The following commit(s) were added to refs/heads/document by this push:
     new 97be8b9  Apache Superset docs
97be8b9 is described below

commit 97be8b9ac1b9f4e94cd44812f84cb507cc55d68f
Author: GinaZhai <na...@kyligence.io>
AuthorDate: Mon Jul 23 14:09:23 2018 +0800

    Apache Superset docs
    
    Superset document
    
    Apache Superset documents
    
    Apache Superset document
    
    Superset document
    
    add content for Apache Superset
    
    remove whitespace
---
 website/_data/docs-cn.yml             |  1 +
 website/_data/docs.yml                |  1 +
 website/_docs/tutorial/superset.cn.md | 45 ++++++++++++++++++++++++++++++++++
 website/_docs/tutorial/superset.md    | 46 +++++++++++++++++++++++++++++++++++
 4 files changed, 93 insertions(+)

diff --git a/website/_data/docs-cn.yml b/website/_data/docs-cn.yml
index 421ff2f..ecbb6e7 100644
--- a/website/_data/docs-cn.yml
+++ b/website/_data/docs-cn.yml
@@ -51,6 +51,7 @@
   - tutorial/microstrategy
   - tutorial/squirrel
   - tutorial/Qlik
+  - tutorial/superset
 
 
 - title: 帮助
diff --git a/website/_data/docs.yml b/website/_data/docs.yml
index dcbdd34..bd78b83 100644
--- a/website/_data/docs.yml
+++ b/website/_data/docs.yml
@@ -63,6 +63,7 @@
   - tutorial/spark
   - tutorial/hue
   - tutorial/Qlik
+  - tutorial/superset
 
 - title: How To
   docs:
diff --git a/website/_docs/tutorial/superset.cn.md b/website/_docs/tutorial/superset.cn.md
new file mode 100644
index 0000000..80adc7a
--- /dev/null
+++ b/website/_docs/tutorial/superset.cn.md
@@ -0,0 +1,45 @@
+---
+layout: docs-cn
+title:  "Superset"
+categories: tutorial
+permalink: /cn/docs/tutorial/superset.html
+---
+### Apache Kylin 与 Apache Superset 的集成
+
+##### 简介
+Apache Superset(incubating)是一个现代化的企业级商业智能 Web 应用程序。Superset 的整个后端是基于 Python 开发的,用到了 Flask,Pandas,SqlAlchemy。可以与 Kylin Python Client 集成。
+
+##### Apache Superset 功能
+* 丰富的数据可视化集
+* 易于使用的界面,用于探索和可视化数据
+* 创建和共享仪表板
+* 与主要身份验证提供程序(数据库,OpenID,LDAP,通过 Flask AppBuilder 的 OAuth 和 REMOTE_USER)集成的企业级身份验证
+* 一种可扩展的,高粒度的安全/权限模型,对于可以访问个人特征和数据集的用户允许使用复杂的规则
+* 一个简单的语义层,允许用户通过定义哪些字段应显示在哪个下拉列表以及哪些聚合和功能度量标准可供用户使用来控制数据源在 UI 中的显示方式
+* 通过 SQLAlchemy 与大多数 SQL 的 RDBMS 集成
+
+##### 集成的好处
+Apache Kylin 和 Apache Superset 都是以为其用户提供更快和可交互式的分析的目的而构建。由于预先计算的 Kylin Cube,在 PB 级数据集上这两个开源项目的结合可以将这个目标变为现实。
+
+##### 集成的步骤
+1. 安装 Apache Kylin
+2. 成功的 build cube
+3. 安装 Apache Superset 并进行初始化
+4. 在 Apache Superset 中连接 Apache Kylin
+5. 配置一个新的数据源
+6. 测试及查询
+
+详细的集成步骤,请查看 [这篇文章](http://kylin.apache.org/blog/2018/01/01/kylin-and-superset/)。
+
+##### 其它功能
+Apache Superset 也支持导出 CSV, 共享, 以及查看 SQL 查询。
+
+### Kyligence Insight for Superset
+定制版的 Superset:Kyligence Insight for Superset,使得 Kylin 的用户多了一种选择。具体的安装步骤请在 github 上查看 [这个项目](https://github.com/Kyligence/Insight-for-Superset)。
+
+##### 相比原生 Superset, 提供了如下增强功能:
+1. 统一用户管理,用户无需在 "Superset" 上额外创建用户和赋予权限,统一在 Kylin 后端管理用户访问权限,直接使用 Kylin 账户登录 Superset。
+2. 一键同步 Kylin Cube,无需在 Superset 端重新定义数据模型,直接查询 Cube.
+3. 支持多表连接模型,支持 inner join 和 outer join.
+4. Docker 容器化部署 Superset,一键启动,降低部署和升级门槛。
+5. 自动适配 Kylin 查询语法。
\ No newline at end of file
diff --git a/website/_docs/tutorial/superset.md b/website/_docs/tutorial/superset.md
new file mode 100644
index 0000000..a1d0c9e
--- /dev/null
+++ b/website/_docs/tutorial/superset.md
@@ -0,0 +1,46 @@
+---
+layout: docs
+title:  "Superset"
+categories: tutorial
+permalink: /docs/tutorial/superset.html
+---
+### Integrate Apache Kylin and Apache Superset
+
+##### Introduction
+Apache Superset (incubating) is a modern, enterprise-ready business intelligence web application. The entire backend of Superset is based on Python and uses Flask, Pandas, and SqlAlchemy. It can be integrated with the Kylin Python Client.
+
+##### Features of Apache Superset
+* A rich set of data visualizations
+* An easy-to-use interface for exploring and visualizing data
+* Create and share dashboards
+* Enterprise-ready authentication with integration with major authentication providers (database, OpenID, LDAP, OAuth & REMOTE_USER through Flask AppBuilder)
+* An extensible, high-granularity security / permission model allowing intricate rules on who can access individual features and the dataset
+* A simple semantic layer, allowing users to control how data sources are displayed in the UI by defining which fields should show up in which drop-down and which aggregation and function metrics are made available to the user
+* Integration with most SQL-speaking RDBMS through SQLAlchemy
+
+##### Benefits of integration
+Both Apache Kylin and Apache Superset are built to provide fast and interactive analytics for their users. The combination of these two open source projects can bring that goal to reality on petabyte-scale datasets, thanks to pre-calculated Kylin Cube.
+
+##### Steps of integration
+1. Install Apache Kylin
+2. Build Cube successfully
+3. Install Apache Superset and initialize it
+4. Connect Apache Kylin from ApacheSuperset
+5. Configure a new data source
+6. Test and query
+
+Please read [this article](http://kylin.apache.org/blog/2018/01/01/kylin-and-superset/) for detailed steps.
+
+##### Other functionalities
+Apache Superset also supports exporting to CSV, sharing, and viewing SQL query.
+
+
+### Kyligence Insight for Superset
+A customized version of Superset: Kyligence Insight for Superset gives Kylin users a choice. Please check [this project](https://github.com/Kyligence/Insight-for-Superset) on github for specific installation steps.
+
+##### Compared to the native Superset, it offers the following enhancements:
+1. Unified user management, users do not need to create additional users and permissions on "Superset", manage user access rights on the Kylin backend, and log in to Superset directly using Kylin account.
+2. One-click synchronization Kylin Cube, no need to redefine the data model on the Superset side, directly query Cube.
+3. Support multi-table join model, support inner join and outer join.
+4. Docker containerized deployment Superset, one-click startup, reducing deployment and upgrade thresholds.
+5. Automatically adapt Kylin query syntax.