dataease/dataease
Dataease
DataEase is an open-source, self-hosted business intelligence platform designed for building interactive data visualizations and managing analytical reporting. It provides a centralized environment where users can construct dashboards through a drag-and-drop interface, connecting to diverse data sources including relational databases, data warehouses, and external APIs.
The platform distinguishes itself through its focus on embedded analytics and enterprise-grade governance. It allows for the seamless integration of charts, dashboards, and management modules into third-party web applications using secure iframe containers and token-based authentication. To support complex organizational needs, it includes granular role-based access control, row-level data filtering, and hierarchical organization management, ensuring that data remains secure and isolated across different departments.
Beyond core visualization, the system offers extensive automation and connectivity features. It supports automated report scheduling and distribution, cross-source data modeling, and a plugin-based architecture that allows for the addition of custom data sources and visualization types. The platform also includes robust monitoring tools, such as threshold-based alerting and execution logging, to maintain operational visibility over automated tasks.
The system is built to be highly configurable, offering options for platform branding, global variable definitions, and comprehensive identity management through integrations with external authentication providers.
Features
- Business Intelligence Dashboards - Provides a drag-and-drop interface for building interactive business intelligence dashboards.
- Data Visualization - Renders complex datasets into interactive bar, line, and scatter charts for business intelligence reporting.
- Business Intelligence Platforms - Serves as an open-source business intelligence platform for data visualization and reporting.
- Data Visualization Dashboards - Provides a drag-and-drop interface for constructing interactive analytical dashboards from diverse data sources.
- Row Level Security - Provides granular row-level security policies to restrict data access based on user attributes and roles.
- Role-Based Access Control - Enforces security by aggregating organizational permissions and row-level data filters to restrict resource visibility.
- Embedded Analytics Interfaces - DataDash enables bidirectional communication between the host application and embedded components to filter data dynamically or pass user interactions back to the host system.
- Embedded Dashboards - Integrates interactive data visualizations and dashboards into third-party web applications using iframe containers.
- Automated Reporting - Sends dashboard or data visualization snapshots to stakeholders via email or messaging platforms on a recurring schedule.
- Embedded Session Authentication - Validates external requests using JSON Web Tokens to securely embed dashboards in third-party applications.
- Embedded Analytics - Integrates dashboards, charts, and management modules into third-party applications to provide embedded business intelligence.
- Data Governance - Enforces enterprise-grade data governance through role-based access and row-level security.
- Data Source Connections - Integrates with a wide range of relational databases, data warehouses, data lakes, flat files, and API endpoints.
- Cross-Origin Security Policies - Enables secure integration of dashboards into third-party applications using iframe containers and postMessage protocols.
- External Identity Provider Integration - Integrates with OIDC, CAS, and OAuth2 identity providers for centralized user authentication.
- Organizational Structure Management - Creates multi-level organizational structures to group users and resources, ensuring strict data isolation.
- User Role Management - Manages user roles and permissions to regulate access to organizational resources and data.
- Multi-Factor Authentication - Enforces multi-factor authentication for enhanced account security.
- Single Sign-On - Enforces single sign-on for seamless access using linked third-party services.
- Dashboard Layout Engines - Constructs visual layouts by mapping drag-and-drop components to data models through a centralized configuration engine.
- Application Embedding - Integrates dashboards and management modules into external web applications using secure iframe containers and token-based authentication.
- LDAP Authentication - Supports LDAP integration for centralized user identity and access control.
- Data Reporting - Centralizes data reporting with automated scheduling and secure database connectivity.
- Data Collections & Datasets - Constructs data sets by selecting tables or writing custom SQL queries for cross-source integration.
- Dataset Creation - Selects specific tables from connected data sources to define the scope of information available for reporting.
- Cross-Source Querying - Executes data queries that span different connected sources for unified analysis.
- Data Synchronization - Maintains analytical storage by periodically syncing only modified or new records from operational sources.
- API Request Authentication - Secures API endpoints using token-based authentication and cryptographic signatures.
- User Account Management - Maintains user profiles and organizational access permissions.
- Plugin-Based Architectures - Supports modular expansion by allowing custom data sources and visualization types to be installed as independent plugins.
- Global System Settings - Centralizes global system settings including timeouts, health checks, and log retention.
- Dashboard Sharing - Generates shareable links with optional password protection and expiration dates for secure external access.
- Database Integrations - Integrates third-party database systems as data sources to enable real-time visualization and analysis.
- Data Joins - Combines data from different sources using join logic to create unified analytical views.
- Incremental Syncing - Updates datasets from external APIs by identifying records through primary keys to ensure data consistency.
- Relational Data Modeling - Joins multiple tables from different sources using configurable connection types and field mappings.
- SQL Query Builders - Unifies external database connections through a common query layer that translates visual interactions into parameterized SQL.
- Brute Force Protections - Protects accounts from brute-force attacks by limiting failed login attempts within specific timeframes.
- Data and Resource Permissions - Manages granular permissions for data sources, dashboards, and reports.
- Variable-Based Filters - Applies custom system variables to row-level security rules for dynamic data filtering.
- Identity Provisioning - Automates user account creation and role assignment upon external authentication.
- Password Policies - Mandates password expiration and initial password changes to ensure account security.
- Role-Based Access Control Systems - Allows the creation of custom roles with inherited permissions for granular access control.
- Backup and Recovery Utilities - Automates the creation of compressed archives to protect system configurations and data from loss.
- Branding Customization - Provides administrative branding tools to customize the platform's visual identity.
- Component Event Triggers - Uses a message bus to trigger cross-component filtering and drill-down actions based on user interactions.
- Dashboard Charting Tools - Synchronizes data across multiple charts by filtering related views based on user selections.
- Ticket-Based Sharing - Generates secure, time-limited access links for dashboards that automatically retrieve pre-configured parameters.
- Dashboard Data Filters - Links multiple dropdown components to filter data hierarchically for refined user analysis.
- Data View Configuration - Defines hierarchical paths for charts that allow users to click into specific data segments for granular detail.
- Connection Managers - Organizes and maintains connection details for various data sources to ensure data availability.
- Data Refresh Scheduling - Configures automated intervals to periodically pull and refresh remote data sources.
- Database Connectivity - Establishes connections to external database servers to enable data retrieval for visualization and analysis.
- Geographic Information Systems - Displays spatial information using regional, heat, flow, or symbol-based maps to reveal location-based patterns.
- External Table Querying - Enables unified reporting by querying external PostgreSQL tables alongside internal data sources.
- Task Schedulers - Assigns collection tasks to specific users or roles with configurable submission modes and validation.
- Login Redirects - Redirects users to preferred external authentication providers while maintaining local access fallbacks.
- Account Linking - Connects user profiles to third-party platforms for integrated authentication.
- Tab Access Restrictions - Restricts access to specific application modules based on user roles.
- Extensibility - Supports modular expansion by allowing custom data sources and visualization types to be installed as plugins.
- Delivery Monitoring - Retries report distribution automatically based on predefined settings when an initial delivery attempt fails.
- Plugin Management Systems - Provides administrative tools for installing and maintaining custom data source and visualization extensions.
- Service Lifecycle Management - Provides controls to start, stop, and restart application services to maintain operational availability.
- Conditional Formatting - Applies dynamic visual styles to chart elements and table cells based on data values to highlight trends.
