Creating a CVMD

Centralized Vendor Metadata Databases (CVMDs) are typically created and implemented by system administrators for Multi-Tenant Cloud (MTC) environments. However, CVMDs can also be implemented and can help improve system performance in on-premises installation environments as well.

CVMDs can be created, much like any other database, using the Infor Mongoose Configuration Wizard. If you decide to create it using the Infor Mongoose Configuration Wizard, you must select the CVMD option of the wizard, and then use the Express Configuration option.

You can also create the CVMD using a CLI (Command Line Interface). This topic provides the procedure to create the CVMD using the CLI.

On the application server, launch a Command Prompt window and navigate to the folder where the Mongoose-based application is installed.
In a typical installation, this is C:\Program Files\Infor\appName\, where appName is the name of your Mongoose-based application.
At the CLI prompt, enter this command:
infordbcl.exe createdb -databasename:CVMDname -product:appName -cvmd
where:
- CVMDname is the name to assign to the CVMD database you are creating.
  While the database name can be anything, as allowed by configuration naming standards, we suggest naming it appname_CVMD for easy identification.
  Note: This is the naming convention that the Express Configuration option uses to name the new database.
- appName is the name of your Mongoose-based application.
As given so far, this is the command to use if you are using Windows authentication and not SQL Server authentication. If you are using SQL Server authentication, these additional switches are required:
-username:SQLusername -password:SQLpassword -servername:SQLserverInstanceName
where:
- SQLusername is the user ID for an authorized SQL user (such as 'sa').
- SQLpassword is the login password for the user ID provided.
- SQLserverInstanceName is the name of the SQL server instance in which the CVMD is to be created.

The system creates the CVMD database. The -cvmd option instructs the system to create the database with all the required constituents.

Note: This procedure does not extract, or remove, the vendor-level metadata from the tenant databases. That is accomplished using a separate procedure. This procedure simply creates the CVMD. Once the CVMD is created, you must still implement it. This can be done manually, using the Configuration Manager. If you use the Express Configuration option, implementation is taken care of automatically.