You can search for some or all data connections residing on the current repository server. Use the Show All option to return a view of all available connections. Use the Filtered Search option to narrow your search using one or more conditions. For each condition, optionally add one or more sub-groups. Adding a sub-group refines the search by categorizing the results. For example, you can build the following condition and sub-group to find data connections with permissions to access all available data connections excluding the connection named delimited: "Repository Access equals All" and "Connection Name does not contain delimited".
To search for data connections
-
Do one of the following:
- On the navigation menu, click Data Access > Manage Data Connections.
- On the Home page, on the Data Connections at-a-glance view, click View All.
The Find Data Connections panel opens showing the Show All and Filtered Search options. By default, the Show All search is active and the view populated with all data connections on the current repository server.
You can also run a quick data connection search using the Find Panel on the Home page.
-
To run a search using conditions:
- Click Filtered Search. The conditions panel opens.
- Select the ALL (default) or ANY operator to build one or more conditions.
-
Build your conditions by selecting the metadata (left drop-down list),
operators (middle drop-down list), and populating the right text box or
drop-down list depending on the metadata and operators you select:
- Click the data connection metadata drop-down list (left) and select one of the following options:
Connection ID
Date Created
Note Count
Connection Name
Description
Parameters
Connection Type
Edited By
Repository Access
Created By
Enabled
Single Sign-On Date Changed
Filter
- Click the operator drop-down list (middle) and select from the available options:
contains
equals
is before
does not contain
does not equal
is before or equals
starts with
greater than
is after
ends with
less than
is after or equals
Note: Depending on the metadata selected, not all operators are available.- In the text box (right), enter the keyword by which to filter the connections. The text string you enter is not case-sensitive. For some metadata selections, text boxes are replaced with a drop-down list of additional metadata to choose:
Connection Type:
Select one of the following connection types:
- COBOL
- DB2
- Delimited
- Fixed-Length
- HDFS Delimited - Available when your repository server is installed and configured in a Hadoop environment.
- ODBC
- ODBC (Vendor)
- Oracle
Date Created and Date Changed:
Click the calendar icon () and choose the date the connection was added or changed.
Enabled:
Select yes or no.
Single Sign-On:
Select yes or no.
- To add a condition, click the Add condition icon ().
- To remove a condition, click the Remove condition icon () .
- To add a sub-group, click Add Sub-group and add conditions for the group as needed.
- To remove a sub-group, click the Remove group icon ().
- To remove all conditions and sub-groups and start a new search, click Clear.
- Click Find Data Connections. Connections matching the search criteria are listed in the Data Connections results tab. For information about data connection metadata, see Using the Find Panel for Data Connections.
- To clear the results, click Show All.
- To export the search results to a .CSV file, see Exporting Data Connection Metadata.
- To add a connection, see Adding New Data Connections.
- To open a data connection to review and manage, on the Data Connections tab, double-click a row. See Modifying Data Connection Properties.