# DataEase — Open-Source BI and Data Visualization Platform

> A self-hosted business intelligence platform that turns databases into interactive dashboards and charts. Supports MySQL, PostgreSQL, ClickHouse, and more with a drag-and-drop visual builder.

## Install

Save in your project root:

# DataEase — Open-Source BI and Data Visualization Platform

## Quick Use
```bash
curl -sSL https://dataease.io/docs/v2/installation/online_installation/ -o install.sh
# Or use Docker:
docker run -d -p 8100:8100 dataease/dataease:latest
# Open http://localhost:8100 (default: admin / DataEase@123456)
```

## Introduction
DataEase is a self-hosted business intelligence tool that lets teams build interactive dashboards without writing code. It connects to a wide range of databases and provides a drag-and-drop chart builder that produces shareable visualizations. The project aims to be an open-source alternative to commercial BI platforms like Tableau.

## What DataEase Does
- Connects to MySQL, PostgreSQL, ClickHouse, Oracle, SQL Server, and other data sources
- Provides a drag-and-drop dashboard builder with dozens of chart types
- Supports calculated fields, filters, and drill-down for deeper data exploration
- Offers role-based access control and dashboard sharing via public links
- Includes scheduled report generation and export to PDF or image formats

## Architecture Overview
DataEase is a Java-based application using Spring Boot on the backend and Vue.js on the frontend. It stores metadata in a built-in MySQL instance and connects to external databases for query execution. Charts are rendered using Apache ECharts. The system runs as a set of Docker containers managed by Docker Compose, with an embedded Nginx reverse proxy handling routing.

## Self-Hosting & Configuration
- Minimum requirements: 2 CPU cores, 4 GB RAM, 20 GB disk
- Install via the one-line script or Docker Compose
- Configure database connections through the web UI after login
- Set SMTP for email-based report delivery in the system settings
- Back up the built-in MySQL data directory for disaster recovery

## Key Features
- No-code dashboard builder with 20+ chart types including maps and pivot tables
- Multi-tenant architecture with workspace-level data isolation
- Template marketplace for reusable dashboard layouts
- Embedded analytics mode for integrating dashboards into other web applications
- Active community with frequent releases and plugin support

## Comparison with Similar Tools
- **Apache Superset** — more SQL-oriented; DataEase emphasizes drag-and-drop simplicity
- **Metabase** — simpler setup but fewer chart customization options
- **Grafana** — focused on time-series monitoring; DataEase targets general BI use cases
- **Redash** — query-first workflow; DataEase offers a visual builder for non-technical users

## FAQ
**Q: Does DataEase support English?**
A: Yes. The interface supports both English and Chinese, and can be switched in the system settings.

**Q: Can I connect to cloud-hosted databases?**
A: Yes. Any database accessible over the network can be added as a data source, including RDS, Cloud SQL, and similar managed services.

**Q: Is there a SaaS version?**
A: The team offers a managed cloud edition, but the open-source self-hosted version has full functionality.

**Q: How does DataEase handle large datasets?**
A: It pushes queries down to the connected database engine, so performance scales with the data source. For very large datasets, connecting to ClickHouse or a similar analytical database is recommended.

## Sources
- https://github.com/dataease/dataease
- https://dataease.io

---
Source: https://tokrepo.com/en/workflows/asset-aaecebf3
Author: AI Open Source