SSIS Components for Microsoft Dynamics SL

Unique Features

• Establish connections to Microsoft Dynamics SL via web services, requiring a Service URL and specific Company selection.

• Authenticate with Dynamics SL using either a Windows account or by providing User Name, Password, and Domain credentials.

• Enhance integration reliability with a configurable Timeout and an optional Retry on Intermittent Errors mechanism.

• Handle complex network setups through comprehensive Proxy Server Settings, including various proxy modes and authentication options.

• Read data from Dynamics SL by selecting a Source Object, with full support for retrieving records from Child Objects as well.

• Apply precise data filtering using an SQL-like syntax for both Source Object and Child Object filters.

• Optimize data retrieval performance by configuring the Batch Size for efficient web service calls.

• Write data to Dynamics SL with essential actions for Create, Update, and Delete records.

• Precisely manage record identification by specifying the Primary Key Field for both parent and child objects.

• Seamlessly handle data for related entities by supporting writes to Child Objects within your integration.

• Streamline data mapping with options to Map Unmapped Fields automatically or Clear All Mappings for a fresh configuration.

• Implement robust Error Handling with the ability to redirect erroneous rows to an error output, capturing specific SL error messages.