Microsoft SQL Server Sources in Data Synchronization Task
When you configure a Data Synchronization task to use a Microsoft SQL Server source, you can read data from a single object or multiple related objects. To read data from multiple sources, you must define relationships based on key columns or create a user-defined join condition.
To optimize performance, you can configure a filter in the Data Filters tab where you can select an object, field, operator, and enter a filter value based on which the Data Synchronization task runs. You cannot include UTF-8 characters in a data filter on a Microsoft SQL Server source.
You can also configure an advanced filter to define a more complex filter condition, which can include multiple conditions using the AND or OR logical operators.
The following table describes the Microsoft SQL Server source properties:
Property | Description |
|---|
Connection | Name of the active source connection. |
Source Type | Type of the source object available. You can choose from the following source types: - - Single
- - Multiple
- - Saved query
|
Source Object | Name of the source object. |
Display source fields in alphabetical order | Displays source fields in alphabetical order. By default, fields appear in the order returned by the source system. |