Poli BI （魄力BI）

Poli BI is an easy-to-use SQL reporting application built for SQL lovers!

Why Poli BI

⚡ Self-hosted & easy setup

Platform independent web application. Single JAR file + Single SQLite DB file. Get up and running in 5 minutes.

💪 Connect to any database supporting JDBC drivers

PostgreSQL, Oracle, SQL Server, MySQL, Elasticsearch... You name it.

💡 SQL editor & schema viewer

No ETLs, no generated SQL, polish your own SQL query to transform data.

🔥 Rich and flexible styling

Pixel-perfect positioning + Drag'n'Drop support to customize the reports and charts in your own way.

📑 Interactive Adhoc report

Utilize the power of dynamic SQL with query variables to connect Filters and Charts.

⌛ Canned report

Capture the snapshot of historical data. Free up space in your own database.

🎅 User management

Three system level role configurations + Group based report access control.

🌎 Internationalization

Custom the language pack and translations just for your audience.

💰 MIT license

Open and free for all usages.

💎 Is that all?

Auto refresh, drill through, fullscreen, embeds, color themes + more features in development.

What's New (latest)

Gallery

Slicer & Charts

Move & Resize

Color palette switch & export CSV

Quick Installation

Windows/Linux

java -jar poli-0.11.0.jar

Docker

docker run -d -p 6688:6688 --name poli zhonglu/poli:0.11.0

Check installation guide for more details.

except PDF

cd export-server npm install -- Start the server node poli-export-server.js

2019.12.24工作日志

1、拉取开源报表形成柱图，饼图

2、查询分公司列表，修改开源源码分组条件

3、修改开源源码实现组件多条件查询

4、核心系统结算状态梳理

Download

Download the latest version of Poli via the github release page.

Documentation

Poli's documentation and other information can be found at here.

Run on GCP

License

MIT License

suxg001/poli