SaaS Integration: How Cloud Systems Actually Get Connected
SaaS integration is the work of making separate cloud applications share data automatically, so a customer, an order or a price entered once appears correctly everywhere it is needed. It sounds like a plumbing problem. In practice it is a decision problem, and the decisions are what this page is about.
There are six patterns in common use, and they are not interchangeable. Picking the wrong one is why integrations that demo beautifully fall apart at month end or at peak trading. Below: how each pattern behaves, what it costs to keep running, the failure modes nobody mentions in the sales meeting, and how to choose.
Realistic ROI
Four Things That Decide Whether a SaaS Integration Works
Integrations rarely fail on the technical connection. They fail on four decisions that get made too late, or by nobody.
Which system owns each piece of data
Before a single field is mapped, one system has to be declared the owner of each data type: the store owns the product, the accounting system owns the invoice, the CRM owns the contact. Everything else reads. Skip this and two systems will spend a year politely overwriting each other, and you will only find out when a customer receives the wrong price.
How often data needs to move
Real time is not automatically better, it is just more expensive and more fragile. Stock levels on a busy store genuinely need to be near instant. A nightly general ledger summary does not. Matching the frequency to the actual business need, field by field, is the difference between an integration that hums along and one that spends its life hitting rate limits.
What happens to the records that do not fit
Every integration meets data it cannot resolve: a duplicate, a missing product, a refund against something deleted, a name with an apostrophe that breaks a lookup. The design has to say where those go. Silently dropping them is the single most common reason a business loses trust in an integration it paid for.
Who finds out when it stops
Integrations do not usually fail loudly. They fail quietly, when a vendor changes an authentication flow or renames a field, and the damage accumulates until reconciliation. Monitoring, alerting and a named owner are not optional extras added at the end. They are part of the design or they never happen.
The Six SaaS Integration Patterns
Most real stacks use three or four of these together. The skill is knowing which job each one is right for.
Point to point
One system wired straight to another. Fast to build and perfectly sensible for two or three systems. The problem is growth: connecting ten systems this way can mean up to forty five separate links, each with its own credentials, rules and failure mode. Fine as a starting point, painful as a strategy.
Hub and spoke
Every system connects once to a central integration layer that holds the rules, the mappings and the logging. Adding an eleventh system is one new connection rather than ten. This is the default shape for any business that expects to keep buying software, which is most of them.
Scheduled batch
Data moves on a timer, often as a file: a nightly sales summary into accounting, a weekly price list out to a store. Unfashionable and genuinely excellent for high volume, low urgency data. It is also the only option for older systems that offer a file drop and nothing else.
Event driven
The source system announces that something happened (order placed, payment received, stock adjusted) and the integration reacts within seconds. Right for anything a customer is waiting on. It needs care: events arrive out of order, arrive twice, or do not arrive at all, so every action has to be safe to repeat.
Middleware and transformation
The layer in the middle that reshapes data so each system receives what it expects: date formats, currency in AUD, GST handling, unit conversions, tax codes, matching a customer across systems that store the name differently. Unglamorous, and where most of the actual build effort goes.
Human in the loop
The deliberate design decision to route ambiguous records to a person instead of guessing. A short daily queue with the reason attached, rather than a silent skip. This is what keeps a small percentage of odd records from turning into a loss of confidence in the whole system.
What Gets Connected in Practice
| Task | Traditional | Done Properly | Notes |
|---|---|---|---|
| Online order into accounting | Keyed in from a store export | Invoice created automatically | The most requested flow in Australian ecommerce, and the one where GST treatment and rounding need to be right on day one. |
| Stock levels across channels | Updated manually, often stale | Synced near real time | Overselling costs more than the integration. Buffers and safety stock are part of the design, not an afterthought. |
| New customer across systems | Typed into two or three tools | Created once, matched everywhere | Matching rules matter here: email, ABN and phone all fail in different ways, so most stacks need a combination. |
| Paid invoice updates the pipeline | Someone emails the salesperson | Deal stage moves automatically | Small flow, disproportionate effect on whether sales reporting is trusted. |
| Product and price changes | Maintained twice, drift over time | Pushed from the owning system | A clear source of truth stops the classic problem of the website advertising last quarter’s price. |
| Purchase order to supplier | Recreated in a second system | Raised once, tracked through | Works well as scheduled batch, since suppliers rarely need second by second updates. |
| Support ticket to customer record | Agent searches each system | Linked on arrival | Cuts handling time noticeably because the agent stops hunting across tabs. |
| A record that will not match | Skipped without telling anyone | Queued with the reason | The design choice that most affects whether people trust the numbers a year later. |
Where SaaS Integrations Quietly Go Wrong
Nobody agreed the source of truth
Two systems both allowed to write the same field will overwrite each other in a loop, and the corruption spreads slowly enough that nobody links it to the integration. Fix it before build: one owner per data type, written down, everything else reads. This is the cheapest hour you will spend on the project.
Retries create duplicates
Networks drop, APIs time out, and a retry is normal. If the action is not idempotent, meaning safe to run twice, a retry creates a second invoice or a second order. Every write needs a stable reference so the second attempt updates rather than duplicates. This bites hardest at peak trading, when retries are most frequent.
Rate limits were never modelled
Vendor APIs cap how many calls you may make. An integration that is comfortable in July can be throttled flat in November when volume triples, and a throttled integration usually looks like a stopped one. Pace the calls, queue the backlog, and test at three times current volume before peak season, not during it.
Nothing is watching
An unmonitored integration is a liability with a countdown on it. You need failure alerting to a named person within the same day, a record level log of what moved and when, and a way to replay the failed items once the cause is fixed. A dashboard nobody opens does not count as monitoring.
Privacy obligations were treated as an IT detail
Moving customer data between systems is regulated under the Privacy Act 1988 and the Australian Privacy Principles. Know which country each system stores data in, use least privilege service accounts rather than a staff login, keep only the logs you need, and be able to honour a deletion request across every connected system, not just the one the customer contacted.
The whole thing lives in one person’s head
Undocumented integrations get replaced rather than repaired, because the risk of touching something nobody understands outweighs the cost of rebuilding. Insist that the system map, the ownership decisions and the field mappings are deliverables, and that they are updated whenever the integration changes.
How Yes AI Approaches a SaaS Integration
Pattern selection before build
We work out which of the six patterns fits each flow, and say plainly where a cheap scheduled batch will serve you better than an expensive real time connection. Getting this right up front is worth more than any amount of clever engineering afterwards.
Data ownership agreed in writing
One owner per data type, documented and signed off before any field is mapped. It is the least exciting deliverable in the project and the one that determines whether your data is still trustworthy in two years.
Built, hosted and monitored by us
Connections run on a managed cloud automation layer we operate, with alerting and record level logging from the first day. You do not run servers, patch anything, or keep scripts alive, and you can see what moved and when.
Exceptions designed in, not bolted on
Ambiguous records go to a short review queue with the reason attached rather than disappearing. Your team handles the handful that genuinely need judgement and ignores the thousands that do not.
From Tangle to Working Integration
Five steps. The first flow is usually live between weeks four and six.
Map the stack and the manual work
Every system, including the shared spreadsheets and the mailbox someone watches. We trace each data type from where it is created to every place it is retyped, and put hours against it.
Choose the pattern per flow
Real time where a customer is waiting, scheduled batch where volume is high and urgency is low, hub and spoke as the overall shape. We agree the source of truth for each data type at the same time.
Specify in plain English
Trigger, fields, direction, matching rules, duplicate handling, exception routing. Written so a finance manager can check it, not just a developer. You approve before build.
Build, test on real data, go live
Built against official APIs and tested on a copy of your actual data including the awkward historical records. Monitoring and idempotent writes from day one, then a watched go live on the highest value flow.
Monitor, tune, extend
Same day alerting on failures, tuning of matching and exception rules against real traffic, and new flows added to the same layer as your stack grows. Documentation updated each time.
Related Reading
Choosing a SaaS Integrator
What one does and what to ask before you appoint one.
iPaaS in Australia
Where an integration platform helps and where it does not.
ERP to Ecommerce Integration
Connecting the back office to the online store.
POS to Ecommerce Integration
One stock pool and one customer across shop and web.
Two-Way Data Sync
Bidirectional syncing without the overwrite loops.
Custom API Integration
When the connector you need does not exist yet.
FAQ
Get the Integration Design Right First
Book a call. We map your systems, recommend the right pattern for each flow, and give you a priced plan. The map and the recommendations are yours either way.
All discussions held in confidence. Australian-based consultants.