What is Data Mart for Excel (D4E SQL) used for?

It lets Excel users pull data from enterprise databases through menu-driven SQL queries for flash reports, ad hoc analysis, and governed spreadsheet tools.

Who should use Data Mart for Excel (D4E SQL)?

Finance, operations, and IT teams that rely on Excel and want fast, governed access to database data without business users writing SQL.

Is there a free version of Data Mart for Excel (D4E SQL)?

Yes. A free Community Edition includes advanced features with monthly limits, while the paid Enterprise Edition adds scheduling, governance, and AI Agent workflows.

Does Data Mart for Excel (D4E SQL) include AI?

Yes. Its AI Agent Mode, called BoBot, converts plain-English requests into SQL workflows, Excel actions, VBA code, API calls, or complete applications.

What are the best alternatives to Data Mart for Excel (D4E SQL)?

Alternatives to Data Mart for Excel (D4E SQL) include Microsoft Power Query, Devart Excel Add-ins, Coefficient, and Alteryx for getting database data into analysis.

Data Mart for Excel (D4E SQL) Reviews, Features & Alternatives

Overview

What is Data Mart for Excel (D4E SQL)?

Data Mart for Excel (D4E SQL) is an Excel add-in from Caratrel Consultants that lets business users pull data from databases into Excel through menus, without writing SQL. Developers build reusable Data Actions with SQL, VBA, ODBC, and API calls, and users run them in one click. An AI Agent Mode turns plain-English requests into queries and workflows. Finance, operations, and IT teams use it for flash reports, ad hoc analysis, and governed spreadsheet tools.

Best for

Finance TeamsBusiness AnalystsExcel Power UsersIT DevelopersOperations Teams

Product snapshot

Category: Data Discovery & Exploration
Best for: Excel-based data access
Deployment: On-premise
Free trial: Yes (free plan)
Integrations: Oracle, SQL Server, DB2, ODBC
AI features: Yes

Key features

Key features of Data Mart for Excel (D4E SQL)

Menu-driven SQL

Run prebuilt database queries from Excel menus without writing code.

Reusable Data Actions

Package SQL, VBA, API calls, and formulas into shareable scripts.

AI Agent Mode

Turn plain-English requests into SQL workflows and Excel actions.

ODBC connectivity

Query Oracle, DB2, SQL Server, and other ODBC data sources.

Scheduled execution

Run Data Actions on schedules with secure back-end processing.

Spreadsheet governance

Scan Excel files, extract their logic, and report on risk.

Reviews

Data Mart for Excel (D4E SQL) reviews

Overall

Nobody has reviewed

What users like

Works inside the familiar Excel interface
Free community edition available
Business users avoid writing SQL
Audit trails for spreadsheet tools

What users dislike

Scheduling limited to Enterprise Edition
Free edition has monthly limits
Tied to the Excel desktop
Needs developer-built Data Actions first

Write a review

Sign in with your account to review Data Mart for Excel (D4E SQL).

Sign in to review

Alternatives

Top Data Mart for Excel (D4E SQL) alternatives

Microsoft Power Query
Best for
Excel data import
Why choose it
Built into Excel at no extra cost
Devart Excel Add-ins
Best for
Database editing in Excel
Why choose it
Connects Excel to many databases and clouds
Coefficient
Best for
Live spreadsheet data
Why choose it
Syncs business systems into spreadsheets automatically
View Coefficient
Alteryx
Best for
Analyst data preparation
Why choose it
Visual workflows for blending and preparing data
View Alteryx

Integrations

Data Mart for Excel (D4E SQL) integrations

Data Mart for Excel (D4E SQL) connects Excel to enterprise databases through ODBC and SQL, with Oracle, DB2, and Microsoft SQL Server named as core targets. Listed ODBC sources also include PostgreSQL, MySQL, SQLite, Microsoft Access, Firebird, ASE, Salesforce, ServiceNow, Airtable, and xBase files, and the Standard Edition on Microsoft AppSource names MYOB as a supported example. Data Actions can combine ODBC or JDBC queries with REST API calls, such as requests to SAP, plus VBA and formula automation. A D4E listing also appears in the Google Workspace Marketplace. Results land directly in Excel worksheets, where business users can rerun them from ribbon menus.

FAQ

Data Mart for Excel (D4E SQL)