Change Data Capture(CDC): Point to Point or Hub Spoke

In rapidly changing IT landscape, enterprises have many drivers to outsource applications to SaaS providers. With this comes challenges around data. Each SaaS providers would have their own way of collecting, storing, naming data.

For example, customer’s address can be stored by one SaaS provider(let’s say CRM SaaS) as addressline1, addressline2 and by another SaaS provder(let’s say Accounting SaaS) with streetnumber, streetname and so on. Business case could be that data across both these providers has to be in sync and in real time!!. This leads to two ways the sync integration can be done.

Point to Point: Call API/Get Webhook/Get Stream/Data mirror to get updated data from one provider to another and vice versa. No storage of data outside the given systems.

Advantages:

No overhead of defining Common Data Model

No overhead of maintenance of Common Data Model

Less latency as there is single transformation to the target system model

Quicker development cycle for same reason i.e single transformation

Hub Spoke: A common data model for customer is defined and is populated with update on either system. And then update sent to the other system with customer details in format for the given system. Data is stored centrally in common data format as act as Master Data for given customer.

Advantages:

Allow loose coupling of given SaaS provider with other systems

Allow replacement of SaaS provider easier

Single and complete view of data

Better Data Analytics and Reporting