Skip to content

Config DataSource

yzhang921 edited this page Dec 16, 2016 · 1 revision

JDBC

Configuraion -> DataSource -> new -> Select JDBC Data Source Type image
Type in all related connection properties and test connection of your input using a simple query
Attention: Please make surce related JDBC driver jar has been included in WEB-INF/lib path of tomcat. You can

  • add dependence in pom.xml to use Maven include your jar (Recommend)
  • or add driver manually into WEB-INF/lib

Kylin

After version 0.2, CBoard has add JDBC of kylin dependence in class path. Driver and url pattern as below:

[Driver]: apache.kylin.jdbc.Driver  
[JDBC URL]:jdbc:kylin://<host>:<port>/<project> 

Saiku Data Source

People who are familiar with Saiku known that the result of saiku report always be a cross table with multilevel row header and column header. How does CBoard reuse this table.

The answer is all the row level will be combined as one line header. Out put columns of above cross table as below: