You can add sources to a synchronization task when you configure the task or when you perform data catalog discovery. If you add a source when you configure the task and the source connection is a database connection, you can add a single object or multiple related objects.
You can add a source to a synchronization task in the following ways:
When you configure the task
Select the source connection and source object on the Source tab when you configure the synchronization task.
If the source connection is a database connection, you can use a single object as a source or multiple related objects as sources. Define relationships based on key columns or create a user-defined join condition.
Through data catalog discovery
If your organization administrator has configured Enterprise Data Catalog integration properties, you can perform data catalog discovery to find the source object in the catalog.
Search for the source object on the Data Catalog page, select the object in the search results, and then add it to a new synchronization task.
Rules and guidelines for multiple-object databases
Use the following rules and guidelines when you configure a multiple-object database:
•All objects must be available through the same source connection. All database tables in a multiple-object source must have valid relationships defined by key columns or user-defined join conditions.
•When you add multiple database tables as sources for a task, you can either create relationships or user-defined joins, but not both.
•The synchronization task wizard removes a user-defined join under the following conditions:
- You remove one of two remaining database tables from the list of sources for the task.
- You change the source connection from database to flat file or Salesforce.