Table of Contents

Search

  1. Preface
  2. Mappings
  3. Parameters
  4. CLAIRE recommendations
  5. Data catalog discovery
  6. Visio templates

Mappings

Mappings

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. Filter search results.
  2. Show or hide object details.
  3. Sort search results.
  4. Apply or remove all filters.
  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.