How Microsoft Dynamics CRM workflow definitions are stored in the SQL Database - Blogs
X
17Jun

How Microsoft Dynamics CRM workflow definitions are stored in the SQL Database

Microsoft Dynamics CRM, is one of the prominent offerings from the Microsoft Dynamics family of ERP and CRM products. It is quite a long time now that MS CRM is in the marketplace. We came across a very odd request from one of our clients, asking us develop a tool which will generate documentation for the CRM workflows. The definition of the workflows in MS CRM is quite intuitive and easy to use. However, the way this data is stored in the CRM SQL database is not that straight forward. Our team did some Googling without much success. All the blogs available seemed to be talking more about how to define workflows, what are the best practices to be followed while defining workflows, how effectively workflows can be used, etc. etc. But none of them really explained about how the metadata for the workflows are stored in the database. Also, MSDN was not of much help. So, we decided to look deeper into this subject ourselves.

We identified the table WorkflowBase, which seemed to be the most probable one to hold these metadata settings. We explored the table and found that our hunch was correct. We found most of the settings stored in this table, but were not able to find the step details. Then we found that these data components are stored in a field called XAML, in a XAML format. The data is not stored in a very straight forward manner, though it was good to know that the values stored were not encrypted. It is just that the data was formatted into some pre-defined XML format. You can see one of the sample XAML data below:

XAML

Decoding the XAML was another challenge faced by the team, because the way the data elements are stored is not something conventional, something which we don’t come across frequently. The team looked into the data to pinpoint the elements (text, numbers, etc.) to identify how the metadata is stored.  Finally, we were able to decipher the XAML formatted text stored and we made a sample output like the following: 

WFOutput

The journey through the storage layers of Dynamics CRM was quite interesting, and we were able to reach to what we had set-off for.

If you wish to discuss further on this topic, please feel free to drop me an email to chinmoy.roy@ecanarys.com

Related

VSTS Team project Monitor

Let us discuss how to install VSTS team project monitor and how we can make use of it easily.Particu...

Read More >

Base64 encoding in Objective c

When we have some binary data that need to send across network, we generally don't do it by just...

Read More >

What is Synchronization? Handling Synchronization in Selenium WebDriver using C#:

Synchronization meaning: when two or more components involved to perform any action, we expect these...

Read More >

DevOpSmartBoard- Multiple Team Capacity

DevOpSmartBoard -The Ultimate End-To-End and One Stop Dashboard solution for all the reporting needs...

Read More >

Instructions for configuring the VS2010 Virtual image in Windows Virtual PC (Windows 7)

Instructions for setting up VS2010 Hands-on labs:Minimum Hardware requirements: Processor :  &n...

Read More >

Technical Consultant | Visual Studio

Should be able to perform independently and with the team. Experience in creating reports using SQL...

Read More >

LDAP Integration with Jenkins

In this document, we are going to see the integration process of LDAP and Jenkins. The default insta...

Read More >

How to Prevent Users from Moving Task to Closed State with a non-Zero value Remaining Work field in VSTS/TFS

In this Blog I am going to explain how we can customize Task in VSTS/TFS to Prevent Users from Movin...

Read More >

What's New in Microsoft Dynamics NAV 2017

We were hearing about Dynamics NAV 2017 since long time that it will be releasing by the end of 2016...

Read More >

How to download YouTube Videos using .NET

Are you interested in downloading YouTube Videos?Want to download YouTube Videos in device specific ...

Read More >

Share

Try DevOpSmartBoard Ultimate complete Azure DevOps End-to end reporting tool

Sign Up

  • Recent
  • Popular
  • Tag
Monthly Archive
Subscribe
Name

Text/HTML
Contact Us
  • *
  • *