Searching for data connection definitions, maps, and columns
You can search for data connection definitions, maps, and columns used in a project.
How to search for a data connection definition, map, or column
1 Choose Search➛Database.
2 In Search—Database Search:
1 Do one of the following:
In Databases, select a host name and type from the list. The list includes only database hosts found in the current project, regardless of the scope of the search.
In Search for database host name or select from the list below, type the name of the database host.
In Search for database host name or select from the list below, make a selection from the drop-down list.
2 If you want to specify a table name and, optionally, a column name and have not already done so, choose Refine.
3 In Refine Database:
1 In Catalog, select the appropriate catalog.
2 In Filter:
To display tables and views from a particular schema, type the first few characters of the schema name in Schema name prefix, for example, dbo. Do not append an asterisk, for example, dbo*. This filter is case‑sensitive.
To display only tables and views whose names begin with a particular string, type the string in Table/View name prefix, for example, ac. Do not append an asterisk, for example, ac*. This filter is case-sensitive.
Select Show tables only, Show views only, or Show all.
Choose Apply filter.
3 In Available, select a table or expand the appropriate table and select a column. In Figure 5‑1, the paymentDate column in the Payments table is selected. Choose OK.
Figure 5‑1 Selecting a database column to search for
4 In Scope, specify the scope of the search. You can search the entire workspace, the resources selected in Navigator, the projects that enclose the selected resources, or predefined working sets. The Search dialog looks similar to Figure 5‑2. Choose Search.
Figure 5‑2 Searching for a database column
The search results appear in the Search view. If you searched only for a database host, the DCD path and file name appear. If you also searched for a table and a column, the SMA path and file name and column name appear as well, as shown in Figure 5‑3.
In Databases, select a host name and type from the list. The list includes only database hosts found in the current project, regardless of the scope of the search.
