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
First publish date
2007
Last updated
2024-02-07
Published on
2024-02-07T17:21:58.768552

To create a new profile from the any of the database connections configured in Spectrum Technology Platform, perform these steps:

  1. In a web browser, go to:

    http://server:port/discovery

    Where server is the server name or IP address of your Spectrum Technology Platform server and port is the HTTP port. By default, the HTTP port is 8080.

  2. Log in using your credentials.
  3. On the Home page, click Profiling.
  4. Click the Add Profile button .
    The Add Profile page is displayed with a wizard showing three stages of profile creation: Select Source > Configure Profile > Finish.
  5. From the Select data source options, select the Connection option.
  6. From the Select connection drop-down list, select the connection you want to use to create the new profile. To narrow down your search by connection type or its name, type it in the field and the related connections will display below the field. For example, if you type mssql then all the MSSQL server connections will 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 Data Sources tab in Spectrum Discovery or with the Management Console. For steps to configure a new data source, see the section Connections.
  7. Click the Select tables button.
    The Select tables pop-up window is displayed showing all the tables in the selected connection.
  8. From the list of tables in the Select tables pop-up window, select the tables that you want to include in the profile and click OK.
    The selected tables are displayed below the Select tables button on the Add Profile page.
  9. To select columns from a table, click , and select the columns needed for creating the profile. To include all the columns, select the check box in the table header.
    Note: Use the type-ahead search text box to search for specific tables/columns.
  10. To configure the profile you created, click on the top right corner of the page.