Understanding Integration Design Choices in Salesforce
Every Salesforce integration follows a design pattern, even when no formal plan exists. Some patterns are easy to start with but hard to maintain later. Others require more effort upfront but scale better over time. Understanding these choices helps avoid costly redesigns.
Direct System Integration
Direct connections link Salesforce to other systems using individual APIs. This approach is quick to set up and offers low latency. For small environments, it may be enough.
As more systems are added, connections multiply. Maintenance becomes difficult. Any change requires updates in multiple places. This pattern often struggles in enterprise environments.
A centralised integration layer acts as a middle point between Salesforce and other systems. All routing, transformation, and security rules live in one place.
This reduces duplication and improves control. However, the central layer must be designed for high availability to avoid becoming a single point of failure.
Orchestrated Enterprise Integration
Orchestrated integration platforms support complex workflows, retries, protocol translation, and centralised logging. They work well for high-volume and multi-step processes.
The trade-off is complexity. Such platforms must be planned, governed, and operationally supported carefully.
Real-Time Data Access
Some use cases require live data without storing it inside Salesforce. Data virtualisation exposes external data as if it were native Salesforce data.
This approach reduces storage costs and sync issues. It depends heavily on external system performance and may limit reporting flexibility.