Profiling can be invoked through the command line.
Profile

repository
category
model
version (only valid when versions are used)
'full' / 'custom'
[options]

Options

-group (group)
-ent (entities)
-att (attributes)
-rlx (relations)
-rc (refresh row counts)
-ist (ignore entities smaller than)
-ilt (ignore entities larger than)
-schemas (if omitted assume all)

Examples:

java -Xmx512m -XX:MaxPermSize=256m -splash: -jar WhereScape-3D-HEAD-bundle.jar profile "my repo" "Source System" NorthWind 1.0 custom -ent -att -rlx -ist 50 -ilt 1000 -schemas dbo,wsmeta
java -Xmx512m -XX:MaxPermSize=256m -splash: -jar WhereScape-3D-HEAD-bundle.jar profile repository "Simple System" AdventureWorks full

To keep things practical we assume:

  • All metrics for entity, attributes and relations are selected .
  • 'Only profile metrics that haven't been profiled before' is turned off .
  • '%' for included tables.
  • No excluded tables.
  • '%' for included attributes.
  • No exclude attributes.