Mappings > Data catalog discovery > Catalog search

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 Search 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 Search field.
You can also enter keyword searches. For example, if you enter tables with order in the Search 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:
The search results lists the catalog objects that match the search criteria. You can filter search results, show and hide the object details, sort objects, apply or remove filters, and select an object for use in a mapping, a synchronization task, or a file ingestion task.
  1. 1. Filter search results.
  2. 2. Show or hide object details.
  3. 3. Sort search results.
  4. 4. Apply or remove all filters.
  5. 5. 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.