Setting CDT preference settings in GUI mode

About this task

You can configure preferences (such as a reports directory) and parameters that determine the behavior of the comparison operation. When you modify these properties, the changes persist, so you do not need to reset them each time you use CDT. These changes are saved in the <INSTALL_DIR>/resources/ydkresources/ydkprefs.xml file.

The ydkprefs.xml is created the first time you start the CDT from the GUI. Alternatively, you can manually create the ydkprefs.xml file without starting the CDT from the GUI, which allows you to invoke the ydkprefs.xml file from the command line. For information about manually creating and editing the ydkprefs.xml file, see Setting CDT preference settings in text mode.

To specify Configuration Deployment Tool settings:

Procedure

  1. Start the Configuration Deployment Tool. For more information about starting the Configuration Deployment Tool, see Starting the CDT in GUI mode.
  2. From the Deployment Explorer action bar, choose the Preferences icon.
  3. In the Preferences window, fill in values using the descriptions provided in Table 1.
    Table 1. Configuration deployment tool preference settings
    Control Description
    Settings Tab
    Reports Directory (for CDT) If you are running CDT, specify the absolute path where you want reports to be generated.
    Reports Directory (for CDV Tool) If you are running CDV Tool, specify the absolute path where you want to export the comparison results report.
    Custom Deployment Class Specify the name of the class that should be invoked for deploying custom tables not handled by CDT.
    Max Changes to Display Specify the maximum number of differences to be displayed. The default display number is 100.
    Audit Version Deployment
    Validate Old Values If you select this check box, the system detects conflict based on the expected old value of an attribute of a record of the obtained changes from the source database against the current value of the corresponding record in the target database.
    Validate Lockid If you select this check box, the system detects conflict based on the expected Lockid of a record of the obtained changes from the source database against the current Lockid of the corresponding record in the target database.
    Validate Record Exists Before Delete If you select this check box, the system validates the record exists in the target database before it attempts to delete it. If the record is not there, the operation will be marked as a conflict.
    Transformations Tab
    Table Element Tables that can be added or deleted.
    Table Name Attribute Specify the name of the table on which you want to carry out the transformation. The syntax and case must match the name of the table used in the Sterling Selling and Fulfillment Foundation ERDs. Custom tables cannot be transformed. Choose the Details icon to specify a value.
    Column Element Columns that can be added or deleted.
    Column Name Attribute Specify the name of the column containing the data to be transformed. The syntax and case must match the name of the column used in the Sterling Selling and Fulfillment Foundation ERDs. Extended columns can be transformed. Choose the Details icon to specify a value.
    Transform Element Define the transformation for this column. For each column, you can define one or more transformations. These transformations are applied to data in this column in sequential order. You can specify multiple transformations for each column, using the delete action to remove the parent element.
    Match Attribute Specify the pattern to search for in the source data. All matching occurrences of this pattern are replaced with the value specified in the Replace attribute. Choose the Details icon to specify a value.
    Replace Attribute Specify the value to replace the pattern with. Choose the Details icon to specify a value.
    XPath Attribute Conditional. If the column to be transformed contains non-XML data, you do not need to specify this XPath attribute. However, some configuration information in Sterling Selling and Fulfillment Foundation is stored as XML in the database.

    If the column to be transformed contains XML data, use this attribute to specify the location of the exact attribute to be transformed.

    Use the syntax: xml:/Configuration/Connection/Host/@IPAddress. Choose the Details icon to specify a value.

    Append-Only Tables Tab
    Append-only Tables Specify configuration table, if any, in which some rows maintain data that is external to Sterling Selling and Fulfillment Foundation. This prevents the data from being deleted during deployment. Specify that table and all of its dependent tables.
    Note: Rows that are maintained externally should never be present in your source database, since this can lead to unpredictable results.
    Ignore Tables Tab
    Ignore Tables Specify any external configuration tables that you do not want the tool to deploy from the source to the target. Ignoring a table automatically ignores all dependent tables as well.