Tasks

Back Next

Catalog search

Use the search on the

Data Catalog

page to find an Enterprise Data Catalog object. Enter the object name, part of the name, or keywords associated with the object in the

field, and then click the search icon.

Data Integration

returns all tables, views, and flat files in the catalog that match the search criteria.

You can use the

and

wildcard characters in the search phrase. For example, to find objects that start with the string "Cust", enter

Cust*

in the

field.

You can also enter keyword searches. For example, if you enter

tables with order

in the

field,

Data Integration

returns tables with "order" in the name or description, tables that have the associated business term "order," and tables that contain columns for which the "order" data domain is inferred or assigned.

For more information about Enterprise Data Catalog searches and search results, see the Enterprise Data Catalog documentation.

The following image shows an example of search results when you enter "tables with order" as the search phrase:

Filter search results.

Show or hide object details.

Sort search results.

Apply or remove all filters.

Use the selected object in a mapping, a

synchronization

task, or a

file ingestion

task.

You can perform the following actions on the search results page:

Filter search results.: Use the filters to filter search results by asset type, resource type, resource name, number of rows, data domains, and date last updated.
Show details.: To display details about the object, click
Show Details
.
Sort results.: Use the
Sort
icon to sort results by relevance or name.
Open an object in Enterprise Data Catalog.: To open an object in Enterprise Data Catalog, click the object name. To view the object, you must log in to Enterprise Data Catalog with your Enterprise Data Catalog user name and password.
Use the object in a synchronization task, file ingestion task, or mapping.: To use the object in a
synchronization
task,
file ingestion
task or mapping, click
Use Object
. You can select an object if the object is a valid source, target, or lookup type for a mapping or a valid source type for the task. For example, you can select an Oracle table to use as the source in a new
synchronization
task, but you cannot select a Hive table.

When you select the object,
Data Integration
prompts you to select the task where you want to use the object and imports the connection if it does not exist.

Connection properties vary based on the object type.
Data Integration
imports most connection properties from the resource configuration in Enterprise Data Catalog, but you must enter other required properties, such as the connection name and password.

After you configure the connection or if the connection already exists,
Data Integration
adds the object to a new
synchronization
task,
file ingestion
task, or to the inventory of a new or open mapping.