1. Select Manage profiling methods from the Tools menu:
  2. Right-click the required Vendor / Version and select Copy.

    Change the Name , Vendor and Version as required and click OK .
     

    An asterix * can be used as a wildcard for either the whole version number or the minor version number in both the Min version and max version. For example , 9., and 9.0 are all valid values for Min version and Max version and match any version, any version 9 release, and only version 9.0 respectively. The method will be allowed to be used for any version between Min version and Max version (inclusive). Any User Defined Profiling methods created with a version of 3D prior to 2.4.0.0 match on the Version string returned by the RDBMS server. Leaving the version as * will allow the method to be used for any version.


    You need to assign the new profiling method to a model version for it to be used. Leaving the version as * will allow the method to be used for any version.

  3. The User defined methods can be edited as required—see details below.
    The toolbar enables you to perform the following:

    Icons

    Definition

    Click to import a method from a file.

    Click to export a method to a file.

    Click to reset a method from last save.

    Click to restore a method from last backup (before the last save)


    Looking at the Profiling Method for MS SQL Specifics for example; you can configure the profiling on Queries for:


To copy or delete a query, right-click the query as shown:

To add a query or copy multiple queries, right-click Queries as shown:

Looking again at the Profiling Method for MS SQL Specifics example; you can configure the profiling on Metrics for


To delete a metric, right-click the metric and choose Delete metric as shown:

To add a metric, right-click Metrics and choose Add metric as shown:


The Rowcount metric is not actually used as a profiling metric—it enables you to customize how 3D performs a row count on each table at the start of the profiling process. You can create your own metric to do this but it MUST be named Rowcount.