Microsoft Dynamics CRM Connector > Mappings and Mapping Tasks with Microsoft Dynamics CRM Connector > Microsoft Dynamics CRM Sources in Mappings
  

Microsoft Dynamics CRM Sources in Mappings

In a mapping, you can configure a Source transformation to represent a single Microsoft Dynamics CRM source or Microsoft Dynamics CRM parameter.
The following table describes the Microsoft Dynamics CRM source properties:
Property
Description
Connection
Name of the source connection.
Source Type
Type of the source object. Select Single Object or Parameter.
Object
Name of the source object. Select the source object for a single source or parameter.
Filter
Filters rows in a mapping. Configure a simple or an advanced filter.
Sort
Sort is not supported for Microsoft Dynamics CRM connection type.
The following table describes the Microsoft Dynamics CRM advanced source properties that you can configure in a Source transformation:
Advanced Property
Description
Source Filter
Retrieves rows from an entity that meet a condition. Provide a source filter to improve the performance when you read from Microsoft Dynamics CRM. For example, you can specify filter conditions in the following FetchXML format:
<filter type='or'>
<condition attribute='account.modifiedon' operator='gt' value='10/30/2016 15:15:15' />
</filter>
In this example, or is the filter type, modifiedon is the column name, gt is the greater than operator, and 10/30/2016 15:15:15 is the date and time filter value.
Sorted Ports
Retrieves data from an entity in a specific order.
Maximum Page Size
The maximum number of records in a page buffer that Secure Agent reads from Microsoft Dynamics CRM. Default value is 50.
Tracing Level
Amount of detail that appears in the log for this transformation. You can choose Normal, Verbose Initialization, or Verbose Data. Default is Normal.