Category: Scribe

Scribe Insight Data Flow

If you are looking to integrate Microsoft CRM and Microsoft Dynamics AX 2012, then Scribe Insight is one of the software I came across recently. After playing with it quite around, realized it is one of best option to meet such requirements.

I would like to throw some insight on this. I am going to start with the data flow from MS CRM to AX 2012 and vice versa.

Let’s take an example of Account creation in CRM to understand more clearly:

  1. A customer is created in MS CRM.
  2. MS CRM Publishers monitors the activity and sends XML message in ScribeIn queue (MSMQ).
  3. Scribe Integration Processor reads the message header and redirects to integration process based on message label and invokes the concerned DTS file.
  4. DTS file has source and target connection settings, data massaging and transformation logic and steps to convert the request message into AX understandable message. So, it then makes a connection with Dynamics AX 2012, calls the AX Web service with the converted message.

Similarly, once the customer is created AX 2012, let’s say – AX customer id needs to be updated back to MS CRM:

  1. AX Publishing Routines, a class called ScribeMaster more specifically, facilitates in sending XML message in ScribeIn queue (MSMQ).
  2. Scribe Integration Processor reads the message header and redirects to integration process based on message label and invokes the concerned DTS file.
  3. DTS file has source and target connection settings, data massaging and transformation logic and steps to convert the request message into AX understandable message. So, it then makes a connection with MS CRM and gets the MS CRM updated with AX customer id.

The following diagram depicts how data flows in real-time integration between MS Dynamics CRM and MS Dynamics AX 2012:

Scribe Data Flow.JPG

To one level down, let’s look at different components of Scribe Insight:

 

Message Queue (MSMQ) — There are three publisher message queues:

  1. _CRMPubIn — Required. When a message arrives in the PubIn queue, the Microsoft Dynamics AX and CRM Publisher lets any publisher entities know that the related operation, Insert, Update, or Delete, has occurred. The PubIn queue is always created when you add a publisher.
  2. _CRMPubFailed — Optional. If no publisher entity exists to handle this message and you have configured your publisher to log failed messages, then the message is routed to the PubFailed queue.
  3. _CRMPubSucceeded — Optional. If the Microsoft Dynamics AX and CRM Publisher can resolve the message successfully, then a message is created in the ScribeIn queue. If you have configured your publisher to log successful messages in the PubSucceeded queue, then a single copy of the PubIn message is also created in the PubSucceeded queue.

 

1.png

2.jpg

Data Translation Script/Specification (DTS) — A DTS file created in Scribe Workbench that stores the information required to migrate or integrate data between source and target data stores. This file consists of:

  • Source and target data stores.
  • Data processing logic to use when the DTS file is run.
  • Formulas to link source fields to target fields, set constant values in target
  • fields, or define matching criteria.
  • Formulas used to convert, parse, or import selected source fields.

 

Integration Process (IP) — A part of Scribe Console – It detects an event and runs a DTS to modify and integrate your data. Events that an IP detects include:

  • A message being written into a queue.
  • The results of a SQL query.
  • A file being saved in a folder.
  • A specific time.

 

3.jpg

Collaboration — A set of Integration Processes, related files, and reports that

enables you to organize IPs into meaningful abstractions of business processes.

4.jpg

To reach out to Collaborations folder for ‘Dynamics AX to Dynamics CRM Jumpstart’, go to C:\Users\Public\Documents\Scribe\Collaborations:

5.jpg

Collaboration folder contains many:

  • DTS files
  • .xml & .xsd files
  • ini

 

Publishers

For CRM > AX data synchronization, CRM Publisher generates XML messages to Scribe input queue in the event of Account create/update/delete, Order create/update/delete provided message qualifying criteria is met. Similarly, for AX > CRM data synchronization AX Publishing routines generates XML messages to Scribe input queue in the event of Account create/update/delete, Order create/update/delete provided message qualifying criteria is met.

6.jpg

That’s it for now…but stay tuned…more to come on this.

 

Kindly note – take me just as a reviewer and not as a Sales Person.

 

Source:

https://help.scribesoft.com/scribeinsight/en/index.htm

https://crmconsultancy.wordpress.com

Advertisements