Adding Data from a Connection

To add data from the any of the database connections configured in Spectrum Technology Platform, perform these steps:

On the Spectrum Discovery Home page, click Profile.
Click the icon on the icon bar just below the tabs.
From the Select data source options, select the Connection option.
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 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 Connection tab in Spectrum Discovery or with the Management Console. For steps to configure a new data source, see the section ../../../ClientTools/ConfiguringExternalResources/Admin_ConfiguringExternalResources.html#concept_DataSourceConns.
Click the Select tables button.
The Select tables pop-up window is displayed showing all the tables in the selected connection.
From the list of tables in the Select tables pop-up window, select the tables that you want to include, and click OK.
The selected tables are displayed below the Select tables button.
To select columns from a table, click , and select the columns you require. 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 and columns.
To go to the configuration stage, click on the top right corner of the page.