Cetrix Blog

Agile MDM Cloud Integration and Enterprise Bus Platforms

Paul Nilsen - Mar 28, 2018 6:51:33 AM

Master and Other Business Data

Your organization’s master data are the fundamental and independent entities used to complete operational transactions. These entities include your customers, vendors, products, materials, and anything else your company uses on a daily basis. This data is related to but does not include your organizations:

  • Reference data (entities, dimensions, and values) used in analytics 
  • Transactional data which support your business applications
  • Analytical data which support decision making systems (BI systems)

Master data is the foundation your business information. For example, if a customer buys a product at a specific price, from a store:

  • The master data include the customer’s information and the product sold
  • The transactional data are the transaction timestamp, price, and any other relevant information
  • This specific customer’s marketing attitude comprises the analytics data- eg what product does he/she prefers, from what store
  • Finally, any analysis from this data is your reference data


Master data and the Enterprise Bus

Every business application supports and manages its own data as well any information derived from it.

Most businesses store their master and transactional data in their local application data store. As an example consider the above case of a customer buying a product. If the sales and financial accounting functions were supported by different applications then: 

  • There should be one transaction for each application (posting a sales order, delivery in the sales application and accounts payable in the financial one)
  • The entire transaction must be a part of a single commit to maintain data consistency. In other words, the individual application transactions should be real-time interfaced

Note that the customer buying the product is a single customer, regardless of the application managing his/her transactions. Therefore, you need some inline management of the financial accounting master data with the sales application.

If there are more than two applications (like in cases of acquisitions or groups/subsidiaries), then you might have the following spaghetti like illustration:

Point-to-point Integration - Cetrix Cloud Ser

                                                              Figure 1. Point to point integration


As before, all transactions still refer to the same entity (the specific customer, product).

Maintaining such heterogeneous architectures with distinct, per-function applications comes with high IT costs. According to Oracle, complexity of point-to-point integration follows a n2 relation, where n stands for the interface numbers. Other studies have shown that above 15 integrations point-to-point integration are more expensive.

These high costs and the complexity of the situation has led to the creation of a new intermediate level to improve inter-application transactions and integrity.This intermediate level is often called an Enterprise Service Bus (ESB) or Enterprise Application Integration.

 Enterprise application integration - Cetrix Cloud Services

Figure 2: Enterprise application integration

ESB is flexible enough that you can add additional business process logic into it to expand its reach, manage users better, or to integrate third party inputs (service oriented architecture).


Master Data Management

Enterprise integration platforms based on ESB provide master data management to help you keep track of your customers’ information. This lets you offer your customers tailored delivery options as well. For instance, let us say that one of your customers wants to buy one of your products and then have it delivered to them. Then, your delivery system should accurately send the product to the customer using their preferred method. Meanwhile, your ERP should log the sale in your inventory database while your CRM completes the sale process. Through it all, the transaction should be validated in real time against your customer’s credit, payment terms, etc.

Thus, you want your master data to be:

  • Cross-application (can be used by any application in your network)
  • Accurate and up-to-date regardless of the application using them
  • Normalized to a reliable standard with transparent naming and coding conventions
  • Synchronized in real time between all applications
  • A single business object in a one to one relation. (single piece of datum defines the business object bijectively)

Master data management (MDM) tools help you maintain the integrity of your master data according to this rules, and are the heart of a robust ESB network. They are enterprise, cross-application solutions for all your customer management platform needs.

Master data management and Enterprise bus - Cetrix Cloud Services

Figure 3: Master data management and Enterprise bus


Cloud-based Master Data Management

Like with any other enterprise application, you can host your MDM solution on-site or you can outsource it to the cloud. While hosting it yourself comes with many advantages, it does come with high maintenance costs. These costs are in addition to the already high initial hardware and software investments required to set up the system:

According to Forbes a switch to cloud may result up to 30% savings in IT resources and 50-67% of the lifecycle cost in a 1000 server environment.

Because of these costs, on-site MDM solutions are usually only cost-effective for large enterprises. For most other companies, you are generally better off outsourcing your MDM solution. Cloud-based MDM solutions keep your IT and operational costs low making it perfect for start-ups and midsize enterprises. This is especially true if most of your current IT infrastructure is already on the cloud such as using Salesforce as your CRM and Workday for HR management.

A typical cloud-based MDM system looks like this:

 Figure 4: Cloud MDM - Cetrix Cloud Services

Figure 4: Cloud MDM

Regardless of how you do it, as several studies have noted, cloud-based MDM solutions offer your organization :

  • More agile and flexible IT systems
  • Easier to maintain and deploy IT management
  • Higher performance, less downtime

In conclusion, cloud-based MDM solutions allow your organization to better manage your business applications through a robust middleware iSassS integration platform, ensuring that your data remains intact and accurate as possible.


Find out how to embrace the future and use software tools to their fullest potential!

Download the ebook Now


Software Driven

SFDC integrated solutions

Topics: Application Integration

Paul Nilsen

Paul Nilsen

Paul Nilsen is the director of solution development at Cetrix Cloud Services. He also works with the Solution Development Department at Cetrix Technologies, where he headed the department for three years. Paul has over 20 years of experience in IT, working on software engineering projects, hardware-software product integration, design of special purpose systems using artificial intelligence, and implementing CRM and ERP software systems.

Previous Post

Appropriate Integration Strategies for Higher Education Institutions

Next Post

EDI Legacy Integration vs. Enterprise Bus Platform


Subscribe Here!





Related Blogs