MySQL Sources in Data Synchronization Tasks
When you configure a Data Synchronization task to use a MySQL source, you can read data from a single object, multiple related objects, or a saved query. 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.
You can also create a data filter, where you can select an object, field, operator, and enter a filter value based on which the Data Synchronization task runs. 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 MySQL 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. |