Systems | Development | Analytics | API | Testing

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.

Someone adds a column. Six weeks later a consumer breaks. Schema Contracts are opt-in. Lock a table and you get a versioned hashed snapshot. Two knobs after that. Mode decides what promotes. None means no contract. Auto promotes additive drift and holds breaking. Strict holds everything for review. Runtime enforcement decides if the live API obeys the lock. Off is docs and drift only. Shape response strips extra fields. Strict also rejects writes that name a field you did not publish.

An agent in your stack reads tables and spends tokens. That has to land on a person, a department, a cost center. DreamFactory maps the agent onto an identity you already have: LDAP, OpenID Connect, SSO. Access and cost follow that person.

DreamFactory 7.7 is out. Agents have owners. API Builder is new. Schema Contracts lock the shape. The admin console is new. Four things that shipped: Agent governance. Every agent has a human owner, a role, and a key that expires in four hours. Deactivate the owner and the agent stops. API Builder. Design the endpoint the app actually wants. Custom paths, shaped responses, on services you already have. Open source, in every edition.

A walk through demo video of the DreamFactory data explorer.

Walk through of the new API Builder available in DreamFactory v7.7.

Getting data out of source systems and into the applications that need it is usually slow, custom, and hard to secure. Today I'll show you how DreamFactory solves that as a secure data gateway. This demo today is based on a government healthcare use case.

Turn a Google BigQuery project into a secured REST API without putting the warehouse credential in your app. DreamFactory stores the service account. Your app calls a URL with an API key. Role-based access control decides what that key can see. Docs are generated from the live spec, so fields and filters become query parameters you can ship. In this walkthrough.

Getting data out of source systems and into the applications that need it is usually slow, custom, and hard to secure. Today I'll show you how DreamFactory solves that as a secure data gateway. This demo today is based on a government healthcare use case.

What if you could ask ChatGPT "which customers haven't ordered in 90 days?" and get an instant answer from your SQL Server database? I set this up live in under 5 minutes. No code. No SQL. Just questions and answers.