Versions Compared

Old Version 1

changes.mady.by.user eric revollo

Saved on

compared with

New Version 2

changes.mady.by.user eric revollo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  1. Select Tools>Manage discovery methods, as shown in the following screenshot:

...

  1. Image Added
  2. 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

...

  1. Image Added
  2. 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

...

  1. Image Added
  2. 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

...

  1. Image Added
  2. 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

...

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

...

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

...

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

...

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

...

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

...

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

...

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

...

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

...

  1. Image Added
Note
titleNote

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.