D4ESQL – SQL Companion for Excel-Based Data Automation

D4ESQL is a smart Google Sheets™ add-on designed to streamline collaboration between business users and SQL developers. It acts as a bridge between Google Sheets™ and the Data Mart for Excel (D4E) desktop tool, enabling powerful SQL-driven workflows without needing to write code.

With D4ESQL, you can:

    Prepare data tables and parameterized SQL templates inside Google Sheets.

    Use predefined commands and scheduling logic for SQL execution via the D4E Excel desktop server.

    Send data requests to a D4E-enabled server using built-in email workflows — no coding required.

    Automate periodic reporting with simple cell-based configurations.

Features:

    “Create Budget Application” instantly generates SQL query templates and a menu sheet.

    “Get Data Table from D4E Server” scans your sheet or SQL menu and builds an email for server processing.

    Full compatibility with ODBC, Excel macros, and Python connectors — when paired with the D4E desktop tool.

    Designed for enterprise use cases like finance reporting, budgeting, GL extraction, and schedule-based reporting.

Whether you're a business analyst or a developer, D4ESQL helps you set up collaborative SQL environments in minutes, not days.

Learn more at www.datamart4excel.com

(Google Sheets™ is a trademark of Google LLC)