Searching Data Connections - trillium_discovery - 17.2

Trillium Administration Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
17.2
Language
English
Product name
Trillium Discovery
Title
Trillium Administration Center
Topic type
How Do I
Overview
Installation
Configuration
Reference
First publish date
2008
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T06:51:21.336195

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".

Note: When creating a filtered search, click Hide to remove the filter panel and see only the summary of your filter criteria. Click Show to display the filter panel.

To search for data connections

  1. 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.

  2. To run a search using conditions:
    1. Click Filtered Search. The conditions panel opens.
    2. Select the ALL (default) or ANY operator to build one or more conditions.
    3. 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.

    4. To add a condition, click the Add condition icon ().
    5. To remove a condition, click the Remove condition icon () .
    6. To add a sub-group, click Add Sub-group and add conditions for the group as needed.
    7. To remove a sub-group, click the Remove group icon ().
    8. To remove all conditions and sub-groups and start a new search, click Clear.
    9. 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.
  3. To clear the results, click Show All.
  4. To export the search results to a .CSV file, see Exporting Data Connection Metadata.
  5. To add a connection, see Adding New Data Connections.
  6. To open a data connection to review and manage, on the Data Connections tab, double-click a row. See Modifying Data Connection Properties.