Shulou(Shulou.com)06/02 Report--

This article mainly introduces the "installation and use of open source BI tool MetaBase". In daily operation, I believe that many people have doubts about the installation and use of open source BI tool MetaBase. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "installation and use of open source BI tool MetaBase". Next, please follow the editor to study!

Brief introduction

Metabase open source BI tool that supports common databases such as mysql, mongodb, etc. The official website: http://www.metabase.com/

Download and install

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

Create a MySQL database

Metabse startup can choose the default H2 database, but it can only be used as an exercise, because the data expands so rapidly, it is best to use the MySQL database to store Metabase metadata in the first place.

At this point, we create a new library of metabase:

CREATE DATABASE metabase default charset utf8 COLLATE utf8_general_ci;grant all on metabase.* to 'metabase'@'%' identified by' 123456' Run launch # h3 (default) export MB_DB_TYPE=h3export MB_DB_FILE=/the/path/to/my/h3.dbjava-jar metabase.jar#mysqlexport MB_DB_TYPE=mysqlexport MB_DB_DBNAME=metabaseexport MB_DB_PORT=3306export MB_DB_USER=export MB_DB_PASS=export MB_DB_HOST=localhostjava-jar metabase.jar# port export MB_JETTY_PORT=12345export MB_JETTY_HOST=0.0.0.0export 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

Of course, that part of the database can be abbreviated:

Export MB_DB_CONNECTION_URI= "mysql://192.168.10.204:3306/metabase?user=metabase&password=123456&useSSL=false"

Write it in jdbc style so that we can specify SSL as false, otherwise the log is a bit disgusting.

Remember to let the new environment variables take effect:

Source / etc/profile

Note: to access localhost:3000, you need to establish an account for the first visit.

Window startup mode rem set MB_JETTY_PORT=12345rem set MB_JETTY_HOST=0.0.0.0rem set MB_JETTY_SSL= "true" rem set MB_JETTY_SSL_Port= "8443" rem set MB_JETTY_SSL_Keystore= "path/to/keystore.jks" rem set MB_JETTY_SSL_Keystore_Password= "storepass" set MB_DB_TYPE=mysqlset MB_DB_DBNAME=metabaseset MB_DB_PORT=3306set MB_DB_USER=usernameset MB_DB_PASS=pwdset MB_DB_HOST=localhost java-jar-Xms1024M-Xmx1024M-XX:NewSize=512m- XX:MaxNewSize=1024m-XX:PermSize=512m-XX:MaxPermSize=512m metabase.jar so far The study on "installation and use of open source BI tool MetaBase" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.