Adding Data from a Connection - discovery - 23.1

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
Topic type
Overview
Reference
How Do I
First publish date
2007
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T17:21:58.768552
To add data from any of the database connections configured in Spectrum Technology Platform, perform these steps:
  1. On the Discovery application page, click Prepare.
  2. Click the Create Rule button .
    This displays the Select Source page.
  3. Next to Select data source, click the Connection option.
  4. In the Select connection drop-down list box, select the connection.
    To narrow down your search by connection type or its name, type it in the field, and the related connections display below it. For example, if you type mssql, then all the MSSQL server connections display.
    Note: The drop-down list displays all the connections that are configured in Spectrum Technology Platform. To configure a new connection, use the Add Data Sources page, which you can access through the Connect tab in Spectrum Discovery or the Management Console. For steps to configure a new data source, see the section Connections.
  5. Click the Select tables button.
    The Select tables pop-up window is displayed showing all the tables in the selected connection.
  6. From the list of tables in the Select tables pop-up window, select the tables that you want to include, and click OK.
    This displays the selected tables below the Select tables button.
  7. Select a column from the table.
    Note: Use the type-ahead search text box to search for specific tables and columns.
  8. Click Save and Continue to save your changes.
    You are now ready to create your match rule.