You can perform a search against the catalog and discover catalog assets. You can use the assets that you discover as sources, targets, and lookup objects in mappings and as sources in synchronization and file ingestion and replication tasks.
Note: Before you can use data catalog discovery, your organization administrator must configure the Enterprise Data Catalog integration properties on the Organization page in Administrator. For more information about configuring Enterprise Data Catalog integration properties, see the Administrator help.
Perform data catalog discovery on the Data Catalog page.
The following image shows the Data Catalog page:
The page displays a Search field and the total number of table, view, and flat file assets in the catalog.
In the Search field, enter a search phrase that might occur in the object name, description, or other metadata such as the data domain or associated business glossary term. When you select an object from the search results, Data Integration asks you where you want to use the object.
To use the object as a source in a synchronization or file ingestion and replication task, select Create a new asset and choose the task. Data Integration imports the connection if it does not exist in your organization. Data Integration then creates the task and adds the object to the task as the source object. You cannot add the object as a source in an existing task.
You can't use data catalog discovery to add objects to mappings in SQL ELT mode.
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:
1Filter search results.
2Show or hide object details.
3Sort search results.
4Apply or remove all filters.
5Use the selected object in a mapping, a synchronization task, or a file ingestion and replication 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 and replication task, or mapping.
To use the object in a synchronization task, file ingestion and replication 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 and replication task, or to the inventory of a new or open mapping.
Discovering and selecting a catalog object
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.
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 synchronization task:
1Open the Data Catalog page.
2Enter the search phrase in the search field.
For example, to find customer tables, you might enter "Customer," "Cust*," or "tables with customer."
3On 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.
4Select 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.
5Click 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.
