[kylin] branch document updated: add doc for jdbc data source

[sh...@apache.org]

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 58bf469  add doc for jdbc data source
58bf469 is described below

commit 58bf469501b5109c0fcf35aec0b84bb627e77a72
Author: etherge <et...@163.com>
AuthorDate: Tue Apr 24 16:35:41 2018 +0800

    add doc for jdbc data source
    
    Signed-off-by: shaofengshi <sh...@apache.org>
    
    Refine doc of howto_setup_jdbc_datasource
---
 website/_data/docs23.yml                           |   4 ++
 .../_docs23/howto/howto_setup_jdbc_datasource.md   |  51 +++++++++++++++++++++
 .../images/docs/jdbc-datasource/load_table_03.png  | Bin 0 -> 159011 bytes
 3 files changed, 55 insertions(+)

diff --git a/website/_data/docs23.yml b/website/_data/docs23.yml
index bbe16ec..bb8a44b 100644
--- a/website/_data/docs23.yml
+++ b/website/_data/docs23.yml
@@ -78,3 +78,7 @@
   - howto/howto_update_coprocessor
   - howto/howto_install_ranger_kylin_plugin
   - howto/howto_enable_zookeeper_acl
+  - howto/howto_setup_systemcube
+  - howto/howto_use_cube_planner
+  - howto/howto_use_dashboard
+  - howto/howto_setup_jdbc_datasource
diff --git a/website/_docs23/howto/howto_setup_jdbc_datasource.md b/website/_docs23/howto/howto_setup_jdbc_datasource.md
new file mode 100644
index 0000000..7653360
--- /dev/null
+++ b/website/_docs23/howto/howto_setup_jdbc_datasource.md
@@ -0,0 +1,51 @@
+---
+layout: docs23
+title:  Setup JDBC Data Source
+categories: howto
+permalink: /docs23/howto/howto_setup_jdbc_datasource.html
+---
+
+> Available since Apache Kylin v2.3.x
+
+## Supported JDBC data source
+
+Since v2.3.0 Apache Kylin starts to support JDBC as the third type of data source (after Hive, Kafka). User can integrate Kylin with their SQL database or data warehouses like MySQL, Microsoft SQL Server and HP Vertica directly. Other relational databases are easy to support as well.
+
+## Configure JDBC data source
+
+1. Prepare Sqoop
+
+Kylin uses Apache Sqoop to load data from relational databases to HDFS. Download and install the latest version of Sqoop in the same machine with Kylin. We will use `SQOOP_HOME` environment variable to indicate the installation directory of Sqoop in this guide.
+
+2. Prepare JDBC driver
+
+   Copy Kylin JDBC driver from `$KYLIN_HOME/lib` to `$SQOOP_HOME/lib`.
+
+3. Configure Kylin
+
+In `$KYLIN_HOME/conf/kylin.properties`, add the following configurations (assumming your MySQL is in the same host):
+
+```
+kylin.source.default=8
+kylin.source.jdbc.connection-url=jdbc:mysql://localhost:3306/employees
+kylin.source.jdbc.driver=com.mysql.jdbc.Driver
+kylin.source.jdbc.dialect=mysql
+kylin.source.jdbc.user=your_mysql_username
+kylin.source.jdbc.pass=your_mysql_password
+kylin.source.jdbc.sqoop-home=/usr/hdp/current/sqoop-client/bin
+kylin.source.jdbc.filed-delimiter=|
+```
+
+Please note, when configure these parameters in `conf/kylin.properties`, all your projects are using the JDBC as data source. If you need access different types of data source, you need configure these parameters at project level, this is the recommended way.
+
+## Load tables from JDBC data source
+
+Restart Kylin to make the changes effective. You can load tables from JDBC data source now. Visit Kylin web and then navigate to the data source panel. 
+
+Click **Load table** button and then input table' name, or click the "Load Table From Tree" button and select the tables to load. Uncheck **Calculate column cardinality** because this feature is not supported for JDBC data source.
+
+Click "Sync", Kylin will load the tables' definition through the JDBC interface. You can see tables and columns when tables are loaded successfully, similar as Hive.
+
+![](/images/docs/jdbc-datasource/load_table_03.png)
+
+Go ahead and design your model and Cube. When building the Cube, Kylin will use Sqoop to import the data to HDFS, and then run building over it.
\ No newline at end of file
diff --git a/website/images/docs/jdbc-datasource/load_table_03.png b/website/images/docs/jdbc-datasource/load_table_03.png
new file mode 100644
index 0000000..7ed3a77
Binary files /dev/null and b/website/images/docs/jdbc-datasource/load_table_03.png differ