How to use DreamFactory to connect Base44 to an on-prem database!

DreamFactory | AI & Applications Data Gateway

Sep 23, 2026

Build a Logistics Dashboard on On-Prem SQL Server with DreamFactory + Base44

In this video, I connect an on-prem SQL Server database to Base44 using DreamFactory. DreamFactory serves a REST API with a read-only role and a scoped API key, and Base44 uses that API as a custom integration to build a full logistics dashboard, complete with related records, filtering, maps, and per-customer and per-driver analytics. No direct database access, no hand-written API code.

What's covered:

Why app builders like Base44 can't reach on-prem databases, and how DreamFactory bridges that gap securely
Connecting SQL Server in DreamFactory and exposing customers, delivery centers, drivers, GPS pings, and shipments
Creating a read-only role scoped to specific tables, plus schema and table-list access so the agent can discover relationships
Setting up a Base44 custom integration from the DreamFactory OpenAPI spec with the API key stored as a secret
Prompting Base44 to build a tabbed dashboard with sortable, filterable, paginated tables and record detail pages
Fixing a missing-table permission live by updating the DreamFactory role (no app changes needed)
Adding an ArcGIS map view for driver GPS pings, driven by DreamFactory's related fields
Building analytics views for customers and drivers: shipment status breakdown, total shipments, total miles, delivery centers

Timestamps:

0:00 Intro and architecture overview

0:31 The problem: on-prem SQL Server and app builders

0:46 SQL Server connection in DreamFactory

1:11 Touring the logistics data and related fields

2:22 Read-only role and scoped API key

3:16 Base44 custom integration from the OpenAPI spec

4:18 The dashboard prompt, explained

6:12 First result and fixing a missing table permission

7:21 Filtering through the DreamFactory API

7:34 Adding a driver map with ArcGIS

8:52 Related records and map view in action