Implementing a CVMD

You can reduce the database footprint and improve system performance by creating and implementing a Centralized Vendor Metadata Database (CVMD). The CVMD must be created using a Command Line Interface, and it is implemented (as with all databases) using the Configuration Manager.

  1. Launch the Configuration Manager and select the Applications tab.
  2. Select the application you want to use with the CVMD, and click Edit.
  3. In the Edit Application dialog box, select the Advanced tab.
  4. In the Central Vendor Forms Metadata section, select the Enable option.
  5. In the Database Connection dialog box that opens, provide these values:
    User
    Supply the user ID for a user who is authorized to log in and use the CVMD.

    This user ID must have, at the least, read, execute, and View Definition SQL rights for the CVMD database.

    Password
    Supply the password required for the user identified to log in to the CVMD.
    Server
    Supply the name of the SQL instance in which the CVMD resides.
    Database Name
    Supply the name of the CVMD that was assigned when it was created.
    Misc. Connect Info

    Optionally, specify any keyword/value pair that modifies the connection string that is used to connect to the database.

    A connection string to a database consists of a series of keyword/value pairs, separated by semicolons, for example:

    Server=ServerName;Database=DatabaseName;User Id=User;Password=xxx

    The application creates connection strings based on configuration information. However, there can be situations where you might want to add a particular keyword/value pair to achieve a desired result. An example is MultiSubnetFailover=True, which is required for SQL Server AlwaysOn configurations.

    To use Microsoft Windows credentials for SQL Server authentication, specify ;Integrated Security=SSPI for each database type. The IDO runtime must be set to a Windows user ID with SQL permissions.
    Note: Only use this field to add a particular keyword/value to every connection made by Factory Track.
  6. Click OK.
  7. Stop and restart the Infor Mongoose IDO Runtime service.

The system now pulls all requested vendor-level data and metadata from the CVMD and all other data/metadata from the customer database.