Blog

Master the all-in-one reporting platform with AI-driven report building, automated generation, bursting and distribution, self-service portals, and embeddable analytics. Learn how DataPallas's self-hosted solution harness the power of low-code simplicity to accelerate your data workflows.

Schedule dbt ETL Transforms with DataPallas — OLTP to OLAP on Autopilot

Automate your dbt transforms on a cron schedule using DataPallas's built-in Groovy scheduler. Keep your ClickHouse data warehouse fresh without external orchestrators.

April 2, 2026

Schedule Unattended Excel Power Query Refreshes — A PowerUpdate Alternative

Automatically refresh Power Query, Power Pivot, and ODBC connections in Excel workbooks on a schedule. DataPallas's built-in Groovy scheduler replaces discontinued tools like PowerUpdate.

April 2, 2026

Build a Business Intelligence Dashboard Over Your IBM DB2 Database

Take the Northwind Sales Dashboard from DataPallas's dashboards tutorial and run it on IBM DB2 — same dashboard, different database, just a few SQL tweaks.

March 24, 2026

Large-Scale Report Generation with MySQL: Seed, Generate, Measure

Generate thousands or millions of reports from your MySQL database and measure the results on your own hardware. Seed realistic invoice data, configure the datasource, design the report template, and see exactly how DataPallas performs at your scale.

March 17, 2026

DataPallas v14: Go Deeper With Embeddable Analytics & OLAP

v14 brings extensive new examples for tables, charts, and pivot tables, a Redis starter pack for faster dashboards, and major performance improvements for large datasets.

March 2, 2026

DataPallas v13: Meet Your AI Crew

Great report automation needs a great data platform. v13 adds AI agents, a conversational data lab, and OLAP engines — all self-hosted.

February 24, 2026

Use Claude Opus to Generate Invoices from PostgreSQL: Stop Copying Data Into Word

Learn how to generate hundreds of professional invoices from your PostgreSQL database in minutes. Use DataPallas with Claude Opus AI to create automated invoice workflows using Groovy scripts for complex master-detail reports.

January 26, 2026

DataPallas v12: Embeddable Analytics Have Arrived

New data-driven web components let you add interactive reports, charts, and dashboards to any web application.

January 15, 2026

Use Gemini 3 To Generate Reports From Your SQL Server Databases

Learn how to connect DataPallas to SQL Server and use Google Gemini AI for database management, SQL queries, and template generation to create automated reports.

November 26, 2025

Step-by-Step Guide: Generating Reports from Oracle Databases

Learn how to connect DataPallas to any Oracle database, using the Northwind sample database as a demonstration example to show the complete workflow from connection setup to report generation and distribution.

November 17, 2025

Database Connections: More Than Just Login Details

Discover how DataPallas transforms database connections from simple credential storage into powerful tools for understanding your data model, with AI assistance for domain grouping, ER diagrams, and ubiquitous language documentation.

November 10, 2025

DataPallas v11: AI-Assisted Reporting & Self-Service Portal

New AI-powered features and self-service web portal in DataPallas v11 reduce the technical barriers for report creation, helping users who know their business data but lack coding expertise.

October 28, 2025