WhereScape Defined Discovery

1. Select Tools>Manage discovery methods, as shown in the following screenshot:

REPLACE WITH THIS IMAGE: Images/discovery/managedisocverymethos.png

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

REPLACE WITH THIS IMAGE: Images/discovery/discovery_method_mgr.png

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

REPLACE WITH THIS IMAGE: Images/discovery/discovery_method_mgr_2.png

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

REPLACE WITH THIS IMAGE: Images/discovery/discovery_method_mgr_3.png

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

REPLACE WITH THIS IMAGE: Images/discovery/discovery_method_mgr_4.png

1. You can view the discovery method for Indexes:
   • Index name
   • Index type
   • Index col order
   • Index col name

REPLACE WITH THIS IMAGE: Images/discovery/discovery_method_mgr_5.png

1. You can view the discovery method for Source mapping sets:
   • Source Set

REPLACE WITH THIS IMAGE: Images/discovery/discovery_method_mgr_6.png

1. You can view the discovery method for Source Mappings:
   • Source entity
   • Source attribute

REPLACE WITH THIS IMAGE: Images/discovery/discovery_method_mgr_7.png

1. You can view the discovery method for Queries:
   • DW query

REPLACE WITH THIS IMAGE: Images/discovery/discovery_method_mgr_8.png

1. You can view the discovery method for Data Transformations:
   • Transformation name
   • Transformation condition
   • Transformation description
   • Transformation change

REPLACE WITH THIS IMAGE: Images/discovery/discovery_method_mgr_9.png

1. You can view the discovery method for UI config column properties:
   • Property name
   • Property value

REPLACE WITH THIS IMAGE: Images/discovery/discovery_method_mgr_10.png

1. You can view the discovery method for Extended table properties:
   • Extended property name
   • Extended property value
   • Extended property type

REPLACE WITH THIS IMAGE: Images/discovery/discovery_method_mgr_11.png

1. Lastly, you can view the discovery method for Extended column properties:
   • Extended property name
   • Extended property value
   • Extended property type

REPLACE WITH THIS IMAGE: Images/discovery/discovery_method_mgr_12.png