“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.
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?
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
- Name the source — approved order, 40 boxes of NG-200.
- Map the fields — match the accounting action's inputs.
- Call accounting — Integration Hub action or outbound REST step.
- Save the reply — accounting reference and posting status.
- 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 |
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.
- Connect accounting. Save the workspace connection; pick its action in an Integration step.
- Set up intake. Register the webhook workflow URL in Shopify. Check order IDs with Load data and a Decision.
- Map outgoing data. Use the connector or REST step. Save accounting reference and posting status.
- Add warehouse stock. A Web Agent signs in nightly, downloads Excel and reads a list. Manual export/import is the fallback.
- 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
- Common Format and MIME Type for CSV Files, RFC 4180 · RFC Editor · 2005-10
- Privileges, PostgreSQL 18 · PostgreSQL Global Development Group · Accessed 2026-10-17
- OpenAPI Specification v3.1.1 · OpenAPI Initiative · 2024-10-24
- What's the AWS SDK for JavaScript? · AWS · Accessed 2026-10-17
- About webhooks · Shopify · Accessed 2026-10-17
- What is Azure Logic Apps? · Microsoft · 2026-09-11
- n8n documentation · n8n · Accessed 2026-10-17
- Automate using UI elements · Microsoft · Accessed 2026-10-17
- Architecture, MCP specification · Model Context Protocol · 2025-11-25
- The enterprise service bus: Making service-oriented architecture real · IBM Systems Journal · 2005-01-01
- Publisher-Subscriber pattern · Microsoft · 2026-03-04
- What is iPaaS? · IBM · Accessed 2026-10-17