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 is usually created using a Command Line Interface. The CVMD can implemented (as with all databases) using the Configuration Manager, or it can be implemented automatically in the Infor Mongoose Configuration Wizard.

Note: This topic and procedure apply only to those who are authorized to use the Configuration Manager, usually in an on-premises environment.

If you use the Express Configuration option in the Infor Mongoose Configuration Wizard, implementation is accomplished automatically, and so, you do not need this procedure.

  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 Mongoose.
  6. Click OK.
  7. Stop and restart the Infor Mongoose IDO Runtime service.

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

Once the CVMD has been implemented, you can create additional databases that use it. See Creating customer database to use with a CVMD in Infor Mongoose Administration Guide.