Uncategorized

Master data synchronization using ColumbusSync

I wanted to share a nice tool I’m working on for Dynamics AX 2012.  It is called ColumbusSync, and solves some requirements we often see at larger enterprises.  The ability to quick and easy distribute master data from a master company to a set of “client” companies.  In this way a large set of companies can act as a single enterprise, even though it actually are a set of unique companies.   

image

What makes this tool great, it that is generic and uses all known relations defined in Dynamics AX 2012.  This means that if you want to synchronize your customers, then all other tables that have a dependency will also be suggested to be included in the synchronization. RecID related relations are also handled. Transactions(like sales orders, inventory transactions etc) are not supported to be included in this tool, and it will not work across partitions.

On each field you can define if the field should de synchronized, is a local field, is a fixed field or a script is associated to the field.  So parts of a record can be locally controlled and parts are synchronized.

You can also define a query criteria, so that set up that only a sub-set of the records should be synchronized to a set of destination companies.

The amount of data that could be included in the synchronization could surely be massive, so there is a set of optimizations that makes use of the Dynamics AX multithreading batch framework.  Just like the master planning in Dynamics AX,  splitting the synchronization into sub-jobs, that is executed the the correct sequence.  (Meaning that groups are typically synchronized before main table records)

The RecVersion field is also used find exactly those records that should be synchronized.  To also support “close-to-real-time” synchronization the current changed/added record can be collected just like the standard AX 2012 database log.

The tool is not ready for shipping yet, but I know that many companies has requested this.  It will also solve a requirement I have seen in the community a lot.  The ability to quickly create a new client company.  The idea is that you may just run the data synchronization to a destination company. 

Visit the blog later, and I’ll share some more details of the tool.

Take care, and happy DAXing.

I appreciate that I can be a part of this worldwide blog community—as a consultant working from Norway, the blog lets me share more than 20 years of experience with Microsoft Dynamics 365. Along the way, I participated in developing retail, PDA/RF, barcoding, master data, kitting and WMS-solutions for Dynamics. My blog focuses on my deepest interests and expertise: along with a 360 degree view of digital transformation topics, I welcome opportunities to dive into retail and intercompany supply chain automation, logistics, and production—everything that is moving around in a truly connected enterprise. As Enterprise Architect on Dynamics 365, I specialize in strategic development and planning for corporate vertical solutions and works to build international networks that increase knowledge and understanding for Dynamics 365. As an advocate for both providers and customers, I'm committed to ensure that customers constantly changing needs are meet, and I see community as key for increasing expertise. I welcome you to connect with me.

5 comments on “Master data synchronization using ColumbusSync

  1. This is a nice and simple . Thanks for sharing

    Like

  2. Pingback: SYNC for AX 2012 R2 CU7 - Warehouse Management and Distribution - Microsoft Dynamics AX - Microsoft Dynamics Community

  3. Pingback: SYNC for AX 2012 R2 CU7 | Kurt Hatlevik – Dynamics Ax Blog

  4. Great job Kurt, I’m also developing on similar tool since I find there is potential requirement. One more tool I’ve developed for Number Sequence Import as per the client specific number sequence format. Looking forward to hear more about tool, please share with us about development area which will improve more ideas and I can include them.

    Like

  5. Looks awesome Kurt! You just solved 1 million problems 🙂

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: