Technology - Non SAP
← Back All series →

APIs & Integration

7 episodes · 87 min total

A practical series on how systems communicate — REST design, JSON, SQL, API security, OAuth, OData, and event-driven patterns in enterprise landscapes.

  1. 01
    REST API Design Principles
    REST API design principles have been the foundation of web APIs since 2000 — and they have not changed. This post explains the core principles clearly: resources, HTTP methods, statelessness, status codes, versioning, and idempotency. Whether you are building your first API or reviewing a design, this is the reference you will come back to.
    12 min
  2. 02
    JSON — From Zero to Confident
    JSON is the universal language of APIs and data exchange. Whether you are reading an API response, writing a config file or working with SAP BTP, you will encounter JSON every day. This post covers everything you need — data types, structure, nesting, arrays, common mistakes and real-world examples — to go from beginner to confident.
    11 min
  3. 03
    SQL Fundamentals — The Queries That Cover Most of What You Need
    SQL has been the language of data for over 40 years and it is not going anywhere. This post covers the fundamentals — SELECT, WHERE, JOIN, GROUP BY, subqueries and more — with real examples, clear explanations and the SAP angle. A reference whether you are writing your first query or just need a quick refresh.
    14 min
  4. 04
    API Security Essentials
    APIs are one of the most targeted attack surfaces in modern software. This post covers the essentials every developer and architect needs to know — API keys, OAuth tokens, rate limiting, input validation, and the OWASP API Security Top 10. A practical reference whether you are building, reviewing, or securing APIs.
    12 min
  5. 05
    OAuth 2.0 and OpenID Connect — How Modern Login Actually Works
    Every time you click 'Sign in with Google' or a system calls an API using a token, OAuth 2.0 is at work. This post explains what OAuth 2.0 actually does, how the key flows work, what OpenID Connect adds on top, and how JWT ties it all together — in plain English without the specification language.
    12 min
  6. 06
    OData Protocol in SAP — V2, V4 and How It Works
    OData is the protocol that connects SAP Fiori apps to SAP backends, powers the API layer of S/4HANA, and is used in every BTP integration. Yet most people only know it as a URL pattern. This post explains what OData actually is, how it works, the real differences between V2 and V4, and when to use each — clearly and without assuming deep technical knowledge.
    12 min
  7. 07
    Event-Driven Architecture — The Concept Behind Modern Integration
    Systems that wait to be asked are request-driven. Systems that react to what happens are event-driven. This post explains event-driven architecture — events vs commands vs queries, pub/sub patterns, event brokers like Kafka and SAP Event Mesh, and when this approach makes sense versus when it does not.
    14 min
Start Series — Episode 1 →