Microsoft Dynamics CRM 4.0

Microsoft Dynamics CRM 4.0 is a customer relationship management (CRM) software package that is available in two deployment styles: client-server and online. A client-server deployment is done on-premise within an organization and made available to users within an intranet or on the Internet. An online or cloud-based deployment using Microsoft Dynamics CRM allows users to subscribe to and access an instance from anywhere on the Internet. Both types of deployments expose the application functionalities through a web services interface.

Property	S/T	Description
Authentication	ST	The authentication protocol for your source or target data: • Default - Uses Windows cached credentials. If necessary, add or edit your user name and password information in the Manage Passwords section of the Windows Control Panel. • Basic • Digest • NTLM • Anonymous
ServiceType	ST	Select the service type for connecting Microsoft Dynamics CRM options: • On-premise (default) • Online
Update Nulls	T	Select this option if you want to allow null values from source rows to overwrite existing data in the target rows during an update operation. The available options are Always (the default), Null only, and Never nulls
Batch Response	T	In delete operations, one batch response entry exists for every delete action. In insert and update operations, one batch response entry exists for every insert or update action. The return code for individual operation will show the result of the operation execution. If the operation is success then the return code will be 0. For failed operations, the error Description tag will show the detailed error message. This will include any messages returned from Microsoft Dynamics CRM 4.0 as well as errors generated by DataConnect. When the return code is 0 (success), then this tag will return the Entity's unique ID for which the operation was successful.
MaxBatch	S	Controls how many records the server is asked to send at one time (read operations only). If you use a large number in this setting, you may see faster transformation run times. However, larger numbers may increase the need for memory. If you experience memory problems, lower the number. The default is 500. To change this property, overtype the default with a new value. The maximum setting is 2000. The recommendation for inserts is 500 maximum and for queries, the maximum can be 2000.
WhereStmt	S	Provides a pass-through mechanism where advanced users can construct the Where clause of the query themselves. It can be used as an alternative to writing a lengthy query statement in the Query Statement text box. This might be used to get the CRM server to filter the data based on a condition before it is sent to Map Designer. Omit WHERE when you enter the clause. There is no default for this setting. Do not apply the WhereStmt when the source connection is a Select statement. If you are using a Select statement, you should include the Where clause in that statement. The intent of this property is to enable data filtering when selecting a table.