[jira] [Updated] (KYLIN-3044) Support SQL Server as data source

[" Kaige Liu (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/KYLIN-3044?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kaige Liu updated KYLIN-3044:
-----------------------------
    Attachment: KYLIN-3304-sqlserver-as-datasource.patch

To use SQL Server as KYLIN data source, following properties should be added to kylin.properties:

*kylin.source.jdbc.connection-url=jdbc:sqlserver://youdbhost:1433;database=sample
kylin.source.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
kylin.source.jdbc.dialect=mssql
kylin.source.jdbc.user=user
kylin.source.jdbc.pass=pass
kylin.source.jdbc.sqoop-home=/usr/hdp/current/sqoop-client/bin
kylin.source.default=8
kylin.source.jdbc.filed-delimiter=|*

JDBC driver will not be shipped by KYLIN. Users should add proper driver by themselves.
For release package, jdbc driver jar should be added to $KYLIN_HOME/ext
For IDE, add jdbc driver jar to class path manually.


[~liyang.gmt8@gmail.com] [~Shaofengshi] please help review my patch. Thanks.

> Support SQL Server as data source
> ---------------------------------
>
>                 Key: KYLIN-3044
>                 URL: https://issues.apache.org/jira/browse/KYLIN-3044
>             Project: Kylin
>          Issue Type: Task
>            Reporter:  Kaige Liu
>            Assignee:  Kaige Liu
>         Attachments: KYLIN-3304-sqlserver-as-datasource.patch
>
>
> [KYLIN-1351|https://issues.apache.org/jira/browse/KYLIN-1351] has added Vertica as data source. Base on the work of KYLIN-1351, I'd like to enable SQL Server as data source of kylin.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)