Sander ten Brinke

Say goodbye to building boring APIs with Azure Data API Builder

Stop building boring CRUD APIs. This open-source tool automatically generates secure REST and GraphQL endpoints directly from your database, saving you hours of boilerplate code.

Say goodbye to building boring APIs with Azure Data API Builder
#1about 3 minutes

The problem of building repetitive data APIs

Repetitive CRUD operations for simple applications create unnecessary overhead and boilerplate for developers.

#2about 2 minutes

Introducing the open-source Data API Builder

Data API Builder is an open-source tool that generates REST and GraphQL endpoints from your database at runtime.

#3about 2 minutes

Exploring core features and out-of-the-box benefits

The tool provides built-in support for filtering, sorting, pagination, authentication, caching, and OpenAPI documentation.

#4about 2 minutes

Getting started with the Data API Builder CLI

Use simple CLI commands like `dab init`, `dab add`, and `dab start` to initialize, configure, and run your API.

#5about 2 minutes

Understanding the main configuration file sections

The configuration file is structured into data source, runtime, and entity sections to define API behavior.

#6about 2 minutes

Querying your API using REST, OData, and GraphQL

Consume the generated API through standard REST endpoints, OData query options, or flexible GraphQL queries with relationships.

#7about 5 minutes

Live demo of a React app with role-based access

A practical demonstration shows a React application interacting with the generated API, including role-based permissions and GraphQL queries.

#8about 2 minutes

Handling custom logic with serverless functions

Extend the API's capabilities by intercepting specific requests with a gateway like API Management to trigger custom serverless functions.

#9about 3 minutes

Securing endpoints with authentication and authorization

Secure your API using providers like Entra ID or JWTs and define granular access control with roles, item security, and field security.

#10about 1 minute

Hosting options across cloud and on-premise environments

Deploy Data API Builder anywhere using Docker containers on services like Kubernetes, Azure Container Apps, AWS Fargate, or Google Cloud Run.

#11about 2 minutes

Integrating directly with Azure Static Web Apps

Azure Static Web Apps offers a built-in integration that hosts the Data API Builder for you, simplifying deployment.

#12about 5 minutes

Roadmap, community resources, and Q&A

Learn about upcoming features like hot reload, find links to documentation and source code, and hear answers to common questions.

Related jobs
Jobs that call for the skills explored in this talk.

Featured Partners

Related Videos

See all videos
The Great API Debate: REST, GraphQL, or gRPC?28:16

The Great API Debate: REST, GraphQL, or gRPC?

Alexis Yushin

Develop enterprise-ready applications for Microsoft Teams with Azure resources on modern web technologies43:26

Develop enterprise-ready applications for Microsoft Teams with Azure resources on modern web technologies

Markus Möller

Building APIs in the AI Era32:28

Building APIs in the AI Era

Hugo Guerrero

Enjoying SQL data pipelines with dbt26:53

Enjoying SQL data pipelines with dbt

Matthias Niehoff

API = Some REST and HTTP, right? RIGHT?!27:25

API = Some REST and HTTP, right? RIGHT?!

Rustam Mehmandarov

GraphQL: Does it replace SQL, REST or Something Else?28:12

GraphQL: Does it replace SQL, REST or Something Else?

Gregor Bauer

Specifications as the better way of software development29:31

Specifications as the better way of software development

Artem Manchenkov

Implementing an Event Sourcing strategy on Azure32:03

Implementing an Event Sourcing strategy on Azure

Eldert Grootenboer & Olena Borzenko-Turianska

From learning to earning

Jobs that call for the skills explored in this talk.