Discover and select a catalog object so that you can use the object as a source in a new
synchronization
or
file ingestion and replication
task, or as a source, target, or lookup object in a mapping.
Before you can use data catalog discovery, your organization administrator must configure the Enterprise Data Catalog integration properties on the
Organization
page in
Administrator
.
The following video shows you how to discover and select a catalog object as the source in a new mapping:
Open the
Data Catalog
page.
Enter the search phrase in the search field.
For example, to find customer tables, you might enter "Customer," "Cust*," or "tables with customer."
On the search results page, click
Use Object
in the row that contains the object.
You can select one object at a time.
Data Integration
prompts you to select where to use the object.
Select one of the following options:
To add the object to a new
synchronization
task, click
New Synchronization Task
.
To add the object to a new
file ingestion and replication
task, click
New File Ingestion and Replication Task
.
To add the object to a new mapping, click
New Mapping
.
To add the object to an open mapping, click
Add to an open asset
, and then select the mapping.
Click
OK
.
If the connection does not exist in your organization,
Data Integration
prompts you to import the connection. Enter the missing connection properties such as the connection name and password.
If you use the object in a
synchronization
or
file ingestion and replication
task,
Data Integration
creates the task with the object as the source. Configure other task properties such as the target, data filters, field mapping, and scheduling information.
If you use the object in a mapping,
Data Integration
adds the object to the mapping inventory. Select the object as the source, target or lookup object.
To select the object:
Open the
Inventory
panel.
Select the Source, Target, or Lookup transformation.
In the Properties panel, select the tab where you configure the connection:
- In the Source transformation, click the
Source
tab.
- In the Target transformation, click the
Target
tab.
- In the Lookup transformation, click the
Lookup Object
tab.
Click
Select an object from the inventory
.
Select the object from the inventory and click
OK
.
Data Integration
adds the object to the mapping as the source, target, or lookup object.