Skip to content

Integration · explainer

Types of System Integration: Methods, Patterns and When to Use Each

System integration is a way to link separate apps so they share data or do a job together. The types of integration in business involve two choices: how to reach each system, and how to arrange the routes. Choose by the data you need, its freshness and who will fix failures.

Beezr · Published · 10 min read

Sandline, our example company, runs this on Beezr → see how

On this page

“We need to integrate them.”

Monday at Sandline. Karim hears this just before a deadline. He puts down his coffee.

Which systems? What needs to move, and who fixes it when it stops?

The types of integration in business answer two questions. How do you reach each system? How do the routes fit together?

Let's draw both.

Types of integration in business: two choices

System integration means linking separate systems to share data or do a job together. Think of a delivery.

Choosing a van says how the parcel travels. It doesn't plan the stops.

Beezr's technique × architecture model splits those choices. It's our model, not an industry standard.

Technique means how you get data in or out. Architecture means how the whole set of connections fits together.

Two terms need care. An SDK helps a developer write the connection.

An iPaaS hosts and manages flows. Neither is a wire protocol.

Which integration methods fit your systems?

Start with what each system lets you do. One method won't fit every job.

Think about the handoff first. Can the data wait for a file?

Does the next system let you ask for the job you need? Is a page the only way in?

Here are the routes and their catches. Start with the one your system supports. Check the real inputs and outputs before you promise a result.

Method What it does The catch
File One side writes a file; the other reads it. Data can go stale. Own missing files and safe repeats.
Approved database read Reads data when no suitable export exists. Agree what the data means; get vendor approval.
API Requests data or an action in an agreed way. A read-invoices endpoint doesn't imply a create-invoice action. See the API guide.
SDK A software development kit helps write a connection. Check its language and operations; maintain the added dependency.
Webhook Sends an event notice to a registered address. Handle repeats and gaps. A notice doesn't prove completion. See the webhook guide.
Browser automation Uses fields and buttons on a page. The page or sign-in can change. Check permission and reachability when supported data routes don't fit.

Point-to-point vs middleware: how do routes fit?

With point-to-point, one system talks straight to another. It can suit two systems with a narrow job and clear owners. Lots of direct links can become a jungle.

Don't count boxes alone. Count which routes rely on each other.

Where do you map the same fields twice? Who fixes each failed path?

Adding one system doesn't mean you must redesign it all.

Middleware puts shared work between apps. Think of a pipe with a traffic officer directing each request. It can share translation, routing and connection management.

The shared layer needs an owner too. An enterprise service bus, or ESB, is one older approach. Middleware is the broader idea, not one product.

Publish-subscribe sends news through a middle layer, like a broker or event bus. Those who want the news sign up for it. Think of a noticeboard: pin the notice, then walk away.

The sender needn't wait for each reader to finish. Each must track its own work and deal with repeats and failures. Microsoft's pattern guide warns that news can arrive twice or out of order, depending on the delivery guarantee.

Here, “event-driven” means that style. These choices can mix: a webhook can feed middleware, middleware can publish events, and files can feed direct links.

Separate routes or a shared pipe Two architecture options, not a deployed map: the Shopify shop, Beezr app, accounting ledger and warehouse monitor have separate tangled connections, or connect through a shared routing and translation pipe. NG-200 is measured in box units. Both arrangements need maintenance owners. Separate mappingsShared routing + translationNG-200boxEach route · owner?Shared layer · owner?
Separate routes or a shared pipe Two architecture options, not a deployed map: the Shopify shop, Beezr app, accounting ledger and warehouse monitor have separate tangled connections, or connect through a shared routing and translation pipe. NG-200 is measured in box units. Both arrangements need maintenance owners. Separate mappingsShared routing + translationNG-200boxShared layer · owner?
Changing the arrangement changes who owns the translation and recovery work.

What are Sandline's system integration examples?

Sandline sells safety and packaging supplies from Dubai. Its records and workflows run in Beezr. Each route has a different job.

The store sends events. Accounting needs a posting action. Yousef's warehouse PC in Jebel Ali must release stock counts.

Lumen Gloves sends Excel prices. Why make all four use the same route?

Several methods meet in one process Shopify sends a registered webhook to Beezr, where Load data and Decision check repeats. Beezr sends the approved order for 40 boxes of NG-200 through an integration action or REST step to accounting and saves the returned reference. Warehouse export and Lumen Gloves Excel price list import separately. Product and price-list units are NG-200 · box. A warehouse Web Agent alternative requires a browser-accessible interface. ShopifyRegistered webhookAccountingApproved · 40 boxes NG-200BeezrSales OrdersNG-200 · boxWorkflowsWarehouseExport → importLumen GlovesNG-200 · boxPrice list → import
Several methods meet in one process Shopify sends a registered webhook to Beezr, where Load data and Decision check repeats. Beezr sends the approved order for 40 boxes of NG-200 through an integration action or REST step to accounting and saves the returned reference. Warehouse export and Lumen Gloves Excel price list import separately. Product and price-list units are NG-200 · box. A warehouse Web Agent alternative requires a browser-accessible interface. ShopifyRegistered webhookBeezrSales OrdersNG-200 · boxWorkflowsAccountingApproved · 40 boxesNG-200WarehouseExport → importLumen GlovesNG-200 · boxPrice list → import
One business process can use several connection methods.

Sandline · example

One order, several separate facts

Northbay Hotels orders 40 boxes of NG-200 nitrile gloves. Sara's order is approved in Beezr. The workflow calls accounting's create-invoice action, then saves its reference and posting status.

Karim maps product, unit and customer to accounting IDs. Missing mappings need review. Hana can check the returned reference at month-end.

A small business's store order takes another route: Shopify's registered webhook URL. Load data checks its ID; a Decision ends repeats. Neither warehouse stock nor supplier prices prove an accounting post worked.

Follow the order to its result

  1. Name the source — approved order, 40 boxes of NG-200.
  2. Map the fields — match the accounting action's inputs.
  3. Call accounting — Integration Hub action or outbound REST step.
  4. Save the reply — accounting reference and posting status.
  5. Check failures — inspect the run and fix the handoff before calling it done.

How should you choose a route?

This matrix is Beezr's selection guidance. It isn't a benchmark or industry standard. Each arrangement is a possible choice, not a required pairing.

Constraint Technique to consider Architecture to consider Failure to design for
A supplier provides a monthly workbook File import Direct for one receiver; shared translation if several need it Changed headings, wrong units, stale or repeated file
Only an approved reporting view exposes stock Database read A shared adapter if several consumers need the same translation Schema change, ambiguous quantities, excessive source load
Approval must produce an accounting invoice API, directly or through a connector; SDK in custom code if suitable Direct for a bounded route; middleware for reused mappings Timeout after acceptance, expired credentials, rejected data
A store announces a new order Webhook into a receiver Direct intake or middleware; pub/sub if consumers need independence Duplicate, delayed or missing event
Several app integrations need managed workflows iPaaS using its supported connectors or APIs Central orchestration, with events where appropriate Unsupported action, broken mapping, an unowned shared flow
A permitted browser export is the only useful interface Browser automation followed by file processing A bounded adapter into the wider process Changed selector, sign-in challenge, incomplete download
An AI application needs discoverable capabilities MCP, through a server that exposes them A governed AI host/client/server arrangement alongside existing integrations Wrong capability selected, permission mismatch, unreviewed action
Choose the route and its repair owner Selection worksheet. Supplier price list: Excel file, direct import, changed heading → Karim. Approved order, 40 boxes NG-200: accounting action, workflow orchestration, rejected mapping → Karim + Hana. Warehouse stock: export or permitted browser route, adapter into Beezr, stale count → Karim + Yousef. No blank placeholder rows. Failure / ownerSupplier price listExcel · direct importHeading changed→ Karim40 boxes NG-200Accounting actionWorkflow orchestrationRejected mapping→ Karim + HanaWarehouse stockExport / permitted web routeAdapter into BeezrStale count→ Karim + Yousef
Choose the route and its repair owner Selection worksheet. Supplier price list: Excel file, direct import, changed heading → Karim. Approved order, 40 boxes NG-200: accounting action, workflow orchestration, rejected mapping → Karim + Hana. Warehouse stock: export or permitted browser route, adapter into Beezr, stale count → Karim + Yousef. No blank placeholder rows. Failure / ownerSupplier price listExcel · direct importHeading changed→ KarimApproved order40 boxes NG-200Accounting actionWorkflow orchestrationRejected mapping→ Karim + HanaWarehouse stockExport / web routeAdapter into BeezrStale count → Karim + Yousef
Start with what the system permits. Finish with who fixes the failure.

Use the narrowest supported route that fits

  • If an API or connector covers the job → start there. Check its operation and error reply.
  • If a batch is fresh enough → use a file. Agree format, handoff and repeats.
  • If only approved database reads fit → document the read boundary. Assign schema and workload owners.
  • If only the browser fits → test it. Check permission, reachability and sign-in before promising unattended runs.
  • If many mappings repeat → consider middleware or iPaaS. Assign an owner.
  • If independent consumers need the news → consider publish-subscribe. Define recovery and completion for each.

Myth / Reality

“Integration means an API.” Sandline also uses files and webhooks. Every route needs agreed fields and an owner.

Our take

Our take. Choose a failure you can maintain. A plain file with an owner can beat an event setup nobody checks. Extra complexity should solve a real need.

How Beezr does it

Save a connector connection per workspace. The workflow's Integration step picks it and an action. REST calls offer timeouts, retries and an idempotency key kept across tries.

The receiver must honour that key to prevent duplicates. Run history shows steps, timings and errors. See Beezr's integration approach.

What should you bring to the meeting?

Write one card per route. Where does it start, and what should the other end do? Note the IDs and how fresh the data must be.

What proves the work is done? Who fixes it if it fails? Test a repeat, bad input and a call when the other end is down.

For the warehouse, start with nightly stock counts: SKU, bin and unit. The no-API guide works through that choice.

Key takeaways

  • If you're technical: separate technique from architecture. Test failures and repeats.
  • If you're not: ask what proves it's done and who fixes it.
  • Check the actual connector action against your job.
  • Each file, webhook and outgoing action needs its own completion check.

Set up Sandline's integration routes in Beezr

Build around records and a clear result.

  1. Connect accounting. Save the workspace connection; pick its action in an Integration step.
  2. Set up intake. Register the webhook workflow URL in Shopify. Check order IDs with Load data and a Decision.
  3. Map outgoing data. Use the connector or REST step. Save accounting reference and posting status.
  4. Add warehouse stock. A Web Agent signs in nightly, downloads Excel and reads a list. Manual export/import is the fallback.
  5. Inspect runs. Use steps, timings and errors to find the failed handoff.

Questions readers ask

Which details should we check for each integration method?

Keep these checks beside the route you choose. A file name, column name or connector logo won't settle them.

Route Detail to agree or test
Supplier file Lumen Gloves sends monthly Excel prices. Agree columns, product IDs, units and effective date before automating.
CSV .csv isn't a full specification. Quote fields with commas, quotes or line breaks; test exporter and importer together.
CSV source RFC 4180 records common practice. It's informational, not a binding standard.
Stock read Does quantity mean available, reserved or physically counted? Ask for a vendor-approved read account and documented view or extract.
Database writes PostgreSQL's guide separates read and write privileges. Direct writes need their own project and vendor support.
HTTP API OpenAPI describes operations, inputs and replies. Send expected inputs and interpret the reply.
SDK example AWS's JavaScript SDK gives JavaScript apps an interface to AWS services.
Store events Shopify subscriptions use a registered destination. Karim registers Beezr's workflow URL. Shopify advises duplicate handling and reconciliation.
Browser elements Selectors locate fields and buttons. Microsoft distinguishes web and desktop elements; don't assume browser tools drive native desktop apps.
What is iPaaS?

Integration platform as a service means cloud tools for connecting apps, systems and data, as IBM explains. It manages flows using APIs, events and files.

Example What its docs say
Azure Logic Apps A cloud service: workflows start with triggers, then connector actions and conditions. The iPaaS label is ours; that page doesn't use it.

Check exact actions and recovery paths. The fields and business rules stay with you.

What is n8n used for?

n8n's docs describe workflow automation combining AI features and business process automation. It chains app actions and data steps. Hosted cloud and self-hosted installs are offered; check the nodes and failure paths you need.

Where does MCP fit?

MCP gives AI apps a common connection to servers offering capabilities. Review what they expose and who may act. The connection doesn't settle approval rights.

Technical detail Source
Hosts, clients and servers; tools, resources and prompts Versioned MCP architecture
ESB metadata describes endpoints, interfaces and policies; mediation patterns satisfy policies IBM's 2005 ESB paper

Sandline's map has no MCP branch. It's here because AI tools increasingly bring it up. Read what MCP does.

Sandline Supplies is a fictional example company.

Sources

  1. Common Format and MIME Type for CSV Files, RFC 4180 · RFC Editor · 2005-10
  2. Privileges, PostgreSQL 18 · PostgreSQL Global Development Group · Accessed 2026-10-17
  3. OpenAPI Specification v3.1.1 · OpenAPI Initiative · 2024-10-24
  4. What's the AWS SDK for JavaScript? · AWS · Accessed 2026-10-17
  5. About webhooks · Shopify · Accessed 2026-10-17
  6. What is Azure Logic Apps? · Microsoft · 2026-09-11
  7. n8n documentation · n8n · Accessed 2026-10-17
  8. Automate using UI elements · Microsoft · Accessed 2026-10-17
  9. Architecture, MCP specification · Model Context Protocol · 2025-11-25
  10. The enterprise service bus: Making service-oriented architecture real · IBM Systems Journal · 2005-01-01
  11. Publisher-Subscriber pattern · Microsoft · 2026-03-04
  12. What is iPaaS? · IBM · Accessed 2026-10-17

Related guides

Your process, made concrete.

Let's talk

Show us how the work runs today. We'll work through what to build with you.

Talk to us