BizTalk Mapper Extensions UtilityPack for BizTalk Server 2013 R2 Updated to v1.9.1.0

Exciting news… Version 1.9.1.0 of BizTalk Mapper Extensions UtilityPack for BizTalk Server 2013 R2 and 2013 is now available!

Here’s the changelog for this release:

  • Updated Logical Functoids:
    • The project has sign strong name key solving an issue regarding “Unable to add BizTalk.Logical.Functoids.dll to the GAC (version 1.9.0.0)” – However, this is a false problem or a BizTalk Deployment Framework problem that always try to put the functoids assemblies in the GAC. In reality, these functoids doesn’t need to be placed inside the GAC.
  • Updated CRM Functoids:
    • CRM Lookup Functoid: This functoid was updated. This functoid allows you to retrieve a value from CRM lookup field. But now this functoid is also able to perform lookup operation using two different approaches: Accessing the CRM database (read-only), for local CRM integration or through the CRM web services if you want to avoid giving access to the database or if you have to integrate CRM online.

The new CRM Lookup Functoid

One of the biggest changes in this new version was made by Salvatore Pellitteri that decided to change the previous CRM Lookup Functoid (also created by him) by adding additional features.

This functoid has the previous one, allows you to retrieve a value from CRM lookup field. However, this new version of the functoid is able to perform lookup operation using two different approaches:

  • Accessing the CRM database (read-only), for local CRM integration
  • Through the CRM web services if you want to avoid giving access to the database or if you have to integrate CRM online.

Parameters

The functoid takes five mandatory input parameters:

  1. SSO Application Name: the connection parameters are stored inside SSO. Here you have to specify the application name where you decide to store the settings. This allows you to have multiple CRM environments that you can integrate;
  2. CRM Guid Field Name: key field name of which you want to get the value;
  3. CRM Entity Name: CRM entity name on which the resolution will be performed
  4. CRM Input Field Name: imagining having a “code” as input and you want to know the CRM physical key, in this attribute should specify the name of the “code” field.
  5. CRM Input Value: value from the source system to resolve

The output of the functoid is a string, Example: 6erg5r-sdrf56-4dfgt5-6ty5r4-456trt 24

new CRM Lookup Functoid

Installation

Create an SSO application.

SQL Server Lookup

Create the following SSO configuration parameters:

  • CrmConnectionType: “sql”
  • CrmDatabaseConnectionString: specify the CRM database connection string

Open SQL Server management console, connect to the CRM database and execute the script under CRMLookup.sql file in the project folder.

Local CRM web services lookup

Create the following SSO configuration parameters:

  • CrmConnectionType: “ws”
  • CrmUserName: specify a valid CRM username
  • CrmUserDomain: specify a user active directory domain name
  • CrmUserPassword: specify the user password
  • CrmUri: specify the CRM web service URL (ex: http://MyCrmServer/MyCrmInstance/XRMServices/2011/Organization.svc)

CRM Online web services lookup

Create the following SSO configuration parameters:

  • CrmConnectionType: “ws”
  • CrmUserName: specify a valid CRM username (ex: harry@mydomain.onmicrosoft.com
  • CrmUserPassword: specify the user password
  • CrmUri: specify the CRM web service URL (ex: https://mydomain.crm4.dynamics.com/XRMServices/2011/OrganizationData.svc )

Download

You can download Source Code and Application Binaries here:
BizTalk Mapper Extensions UtilityPack GitHub RepositoryBizTalk Mapper Extensions UtilityPack
GitHub

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

Leave a Reply

Your email address will not be published. Required fields are marked *

turbo360

Back to Top