Configuring Predictor Resource Properties

  • Article

Prediction recommendations are enabled by default in the Predictor resource for use with the Commerce Server Data Warehouse. If you want to disable the default recommendations, you must modify the Active Server Pages (ASP) code or rename the analysis model that the ASP code expects to load for the default recommendations.

The first two procedures explain how to configure the Predictor resource properties so that the Predictor resource will list models and model configurations in databases other than the Commerce Server Data Warehouse.

Ee797505.note(en-US,CS.10).gif Note

  • If you want to use a database other than the Commerce Server Data Warehouse database, you must reconfigure the Use external database property, and then enter a connection string for the external database using the Data Link Properties dialog box.

To list analysis models and model configurations in an external database

To set the connection string to an external database

To list only models and model configurations in the Commerce Server Data Warehouse

To list analysis models and model configurations in an external database

  1. Expand Commerce Server Manager, expand Global Resources, right-click Predictor on <server name>, and then click Properties.

  2. In the Predictor on <server name> Properties dialog box, on the Properties tab, in the Properties box, select Use external database.

  3. In the Selected property value box, set the property to -1 (True).

The Predictor resource will list models and model configurations from an external database, in addition to those in the Data Warehouse, in the Commerce Server Manager console. (Models and model configurations in the Commerce Server Data Warehouse are always listed.)

After you have set this property, you must set a connection to the external database.

To set the connection string to an external database

  1. Expand Commerce Server Manager, expand Global Resources, right-click Predictor on <server name>, and then click Properties.

  2. In the Predictor on <server name> Properties dialog box, on the Connection Strings tab, select External database, and then click Modify.

  3. In the Data Link Properties dialog box, do the following:

    Use this To do this
    Select or enter a server name Select a server name from the drop-down list, or type the location of the server where the database you want to access is located.
    Use Windows NT Integrated security Click to specify that the provider request a secure (or trusted) connection to a SQL Server running on Microsoft Windows NT.
    Use a specific user name and password Click to use a supplied user name and password to authenticate your logon information to the data source.
    User name Type the user ID to use for authentication when you log on to the data source.
    Password Type the password to use for authentication when you log on to the data source.
    Blank password Select this option to return a blank password in the connection string.
    Allow saving password Select this option to allow the password to be saved with the connection string.
    Select the database on the server Type the database name that you want to access.

Ee797505.note(en-US,CS.10).gif Note

  - For more information about using the **Data Link Properties** dialog box, click **Help** in the dialog box.

  1. Click Test Connection to ensure that you have entered server and database information correctly, and then click OK to close the connection message.

  2. To close the Data Link Properties dialog box, click OK.

    In the Predictor on <server name> Properties dialog box, on the Connection Strings tab, the value of the external connection string appears in the Connection strings in this resource box.

  3. To exit the Predictor on <server name> Properties dialog box, click OK.

If you want the value of an external connection string to be ignored, and have only those models and configuration files in the Data Warehouse be listed in the Predictor resource details screen, you must set the Use external database property to 0 (False).

To list only models and model configurations in the Commerce Server Data Warehouse

  1. Expand Commerce Server Manager, expand Global Resources, right-click Predictor on <server name>, and then click Properties.

  2. In the Predictor on <server name> Properties dialog box, on the Properties tab, in the Properties box, select Use external database.

  3. In the Selected property value box, set the property to 0 (False).

  4. To apply the changes and exit the Predictor on <server name> Properties dialog box, click Apply.

Only analysis models and analysis model configurations that are in the Data Warehouse will be listed in the Predictor resource details screen.


All rights reserved.