View Source

Select Tools>Manage discovery methods, as shown in the following screenshot:
The customized discovery method enables the structure of a specified database and database version to be discovered. This includes the discovery of:
- Tables
- Columns
- Relationships
- Indexes
- Source mapping sets
- Source Mappings
- Queries
- Data Transformations
- UI config column properties
- Extended table properties
- Extended column properties
Looking at the Discovery Method for Microsoft SQL Server - *, for example; you can view the discovery method for Tables:
- Table database
- Table schema
- Table name
- Table comment
- Table type
- View query
- Target location
- Table group
You can view the discovery method for Columns:
- Column name
- Column datatype
- Column datatype size
- Column datatype scale
- Column default value
- Column primary key ind
- Column unique ind
- Column nullable ind
- Column comment
- Column auto increment
- Column label
- Column charset
- Column type
You can view the discovery method for Relationships:
- Parent column name
- Parent constraint name
- Ref database name
- Ref schema name
- Ref table name
- Ref column name
You can view the discovery method for Indexes:
- Index name
- Index type
- Index col order
- Index col name
You can view the discovery method for Source mapping sets:
- Source Set
You can view the discovery method for Source Mappings:
- Source entity
- Source attribute
You can view the discovery method for Queries:
- DW query
You can view the discovery method for Data Transformations:
- Transformation name
- Transformation condition
- Transformation description
- Transformation change
You can view the discovery method for UI config column properties:
- Property name
- Property value
You can view the discovery method for Extended table properties:
- Extended property name
- Extended property value
- Extended property type
Lastly, you can view the discovery method for Extended column properties:
- Extended property name
- Extended property value
- Extended property type

To customize discovery methods, the best approach is to clone the default WhereScape defined discovery methods, creating User defined discovery methods, which can then be modified as required.