PowerExchange for Microsoft Dynamics CRM User Guide for PowerCenter

10.5.6
- 10.5.2
- 10.5.1
- 10.5
- 10.4.0

Back Next

Microsoft Dynamics CRM Target Session Properties

You can configure the session properties for a Microsoft Dynamics CRM target on the Mapping tab. Define the properties for each target instance in the session.

You can use the session property Stop on Errors to indicate how many non fatal errors the PowerCenter Integration Service can encounter before it stops the session.

Stop on Errors are calculated as per batch size. A session fails only if the error count is greater than the Stop on Errors specified after the batch succeeds. For example, if you are using normal mode and if the thread count is greater than 1, then Stop on Errors will check for errors in the batch after the entire batch is processed.

The following table describes the session property you can configure for a Microsoft Dynamics CRM target session:

Session Property	Description
Use Bulk	The PowerCenter Integration Service writes records in bulk mode during data load. Default is not selected.
Alternate Key Name	Indicates whether the column is an alternate key for an entity. Specify the name of the alternate key. You can use alternate key in update, upsert, and delete operations. If you map both primary key and alternate key attributes in a mapping, the primary key takes precedence over the alternate key.
Add row reject reason	Select to add the reason for rejecting the rows in the reject file. Default is disabled.
Maximum Batch Size	Number of records that PowerCenter Integration Service writes at a time during bulk load of data. Default is 50.
Thread Count	Number of parallel threads for data load. Set the appropriate value based on the hardware capabilities of the machine on which the PowerCenter Integration service runs. Default is 8.
Reject File Directory	Directory name of the reject files. By default, the PowerCenter Integration Service writes all reject files to $PMBadFileDir .
Reject File Name	File name for the reject file.

Rename Saved Search

Table of Contents

PowerExchange for Microsoft Dynamics CRM User Guide for PowerCenter

PowerExchange for Microsoft Dynamics CRM User Guide for PowerCenter

Microsoft Dynamics CRM Target Session Properties

Microsoft Dynamics CRM Target Session Properties