Page History
- 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 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
...
Note | ||
---|---|---|
| ||
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. |