1.睿思BI旗舰版最新版V5.2多数据源版支持数据仓库和支撑库单独部署数据源,配件文件在application.yml中,默认使用mysql配置支撑库和数据仓,默认配置如下:
#数据库连接 mysql
spring:
jackson:
date-format: yyyy-MM-dd HH:mm:ss
time-zone: GMT+8
datasource:
type: com.alibaba.druid.pool.DruidDataSource
dbType: mysql #定义支撑库类型
dwType: mysql #定义数据仓库类型
druid:
master: # 支持库
url: jdbc:mysql://localhost:3306/rsbi_sys4?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&serverTimezone=GMT%2B8
username: root
password: 12345678
driver-class-name: com.mysql.cj.jdbc.Driver
initialSize: 5
minIdle: 10
maxActive: 50
maxWait: 60000
datawarehouse: #数据仓
url: jdbc:mysql://localhost:3306/rsbi2?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&serverTimezone=GMT%2B8
username: root
password: 12345678
driver-class-name: com.mysql.cj.jdbc.Driver
initialSize: 5
minIdle: 10
maxActive: 50
maxWait: 60000
2.多数据源配置支持以mysql配置支撑库,以clickhouse配置数据仓库,配置文件如下:
#数据库连接 mysql
spring:
jackson:
date-format: yyyy-MM-dd HH:mm:ss
time-zone: GMT+8
datasource:
type: com.alibaba.druid.pool.DruidDataSource
dbType: mysql #定义支撑库类型
dwType: clickhouse #定义数据仓库类型
druid:
master: # 支持库
url: jdbc:mysql://localhost:3306/rsbi_sys4?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&serverTimezone=GMT%2B8
username: root
password: 12345678
driver-class-name: com.mysql.cj.jdbc.Driver
initialSize: 5
minIdle: 10
maxActive: 50
maxWait: 60000
datawarehouse: #数据仓
url: jdbc:clickhouse://112.124.13.251:8123/default
username: default
password: abc-123
driver-class-name: com.clickhouse.jdbc.ClickHouseDriver
initialSize: 5
minIdle: 10
maxActive: 50
maxWait: 60000
3.clickhouse 是一种专业支持olap分析的列存数据库,非常适合用来配置bi系统数据仓库,能极大提高数据处理和查询效率。