开源BI工具MetaBase-安装与使用

简介

metabase开源的BI工具，支持常见的数据库mysql、mongodb等，官网：http://www.metabase.com/

下载安装

http://downloads.metabase.com/v0.22.0/metabase.jar

运行启动

# h2(默认)
export MB_DB_TYPE=h2
export MB_DB_FILE=/the/path/to/my/h2.db
java -jar metabase.jar
#mysql
export MB_DB_TYPE=mysql
export MB_DB_DBNAME=metabase
export MB_DB_PORT=3306
export MB_DB_USER=<username>
export MB_DB_PASS=<password>
export MB_DB_HOST=localhost
java -jar metabase.jar
# 端口
export MB_JETTY_PORT=12345
export MB_JETTY_HOST=0.0.0.0
export MB_JETTY_SSL="true"
export MB_JETTY_SSL_Port="8443"
export MB_JETTY_SSL_Keystore="path/to/keystore.jks"
export MB_JETTY_SSL_Keystore_Password="storepass"

java -jar -Xms2048M -Xmx2048M -XX:NewSize=512m -XX:MaxNewSize=1024m -XX:PermSize=512m -XX:MaxPermSize=512m metabase.jar

访问localhost:3000,初次访问需要建立账号