Metadata Server Configuration

Metadata Analyzer configuration is accomplished via the Metadata Analyzer Configuration utility. Use this utility to do the following:

• To perform initial set up of the Metadata Analyzer after installing DevEnterprise
• To later modify settings used by the Metadata Analyzer
• To troubleshoot the Metadata Server

To perform initial setup of the Metadata Analyzer after installing DevEnterprise

1. After the installation of DevEnterpriseis complete, if your installation included the Metadata Server, the Metadata Analyzer Configuration utility appears. If you have already successfully configured your database settings, simply click OK.

   Note

   On client installations, only the Logging tab is available and some fields on that tab are disabled. If the Metadata Server is not installed, some tabs are disabled.

   

2. Enter or revise the fields as necessary, referring to the field descriptions below then click Test Connection. If connection is unsuccessful, a warning message will indicate the reason.
3. Make any necessary changes and click Apply to save them without closing the dialog box or click OK to save them and close it. Changes do not take effect until the Metadata Server is restarted.

Fields on the Metadata Analyzer Configuration utility

Database tab:

The Metadata Server requires access to an instance of Microsoft SQL Server. for more information, see SQL Server configuration.

Server name – A string containing the host (or computer) name of the database instance.

Instance name – The SQL Server instance name on the host referenced by the Server name field. If you are using the Express edition of Microsoft SQL Server, SQLEXPRESS should be entered as the Instance name.

Database name – The name of the SQL Server database. By default, the name is cw_metadata.

Port – A string containing the network port that the SQL Server instance is listening on. Leave the port blank if you want to use the default SQL Server port or if SQL Server is configured to use dynamic ports (the default for named instances).

Authentication – Specifies whether to use SQL Server or Windows authentication. Valid values are:

• • SQL (for SQL Authentication)

  • Windows (for Windows Authentication)

Login – A SQL Server login having a role of dbcreator (for automatic database creation by the Metadata Server) or db_owner (if the database has already been created). Only required if The Authentication field is set to SQL Server Authentication. The default is sa.

Password – The password for the database login name referenced by the Login field. Only required if The Authentication field is set to SQL Server Authentication.

Connection timeout (sec) – A numeric value specifying the number of seconds to try to connect to the database before quitting. The default is 30.

File location – A string containing the location to store the primary database file that is allocated when a new database is created by the Metadata Server. If no value is entered, the SQL Server default location is used. If the host name is different from the current machine, DevEnterprisecannot verify whether the directory exists. For better performance, Compuware recommends placing the database (.mdf) file and the database log (.ldf) file on separate physical drives.

File size (MB) – A numeric value indicating the size (in MBs) of the primary database (.mdf) file that is allocated when a new database is created by the Metadata Server. The default is 500. The suggested database file size varies based on the amount of metadata to be collected. Compuware suggests an average of 10 MB per 15,000 Metadata entities.

Log location – A string containing a location to store the database log file that is allocated when a new database is created by the Metadata Server. If no value is entered, the SQL Server default location is used. If the host name is different from the current machine, DevEnterprisecannot verify whether the directory exists. For better performance, Compuware recommends placing the database (.mdf) file and the database log (.ldf) file on separate physical drives.

Log size (MB) – A numeric value indicating the size (in MBs) of the log (.ldf) file that is allocated when a new database is created by the Metadata Server. The default is 100. The suggested log file size varies based on the amount of metadata to be collected.

General tab:

Port – The port number of the Metadata Server. The default is 1240.

Download location – The location where source will be downloaded during collections.

Advanced tab:

Metadata Server learning – Indicates whether learning is enabled. The default it Enable.

Dynamic program resolution max level – The maximum number of levels that will be traced to find values that move to dynamic program names. The default is 2.

Dynamic program resolution use alias – If set to True, aliases will be included when tracing data items to find values that move to dynamic program names. The default is False. An alias is a parent data element, a child data element, or a redefined data element.

Database cleanup delay (min) – The amount of time that the Metadata Server will wait since the last Metadata Viewer activity before performing database cleanup. Default is 10.

File location – The directory used for exporting collections from one database to another, for moving a database, and during database conversions. The default is an Export directory in the UserDataPath specified during the installation (which is available in the About dialog box). Forward slashes are required when specifying this path.

Delimiter – The delimiter used when moving a database. The default is |%|.

Cached data timeout (min): The number of minutes of inactivity until the cached data created by the Program Analyzer APIs is cleared from the Metadata Server.

Logging tab:

Metadata Server – Allows you to select the logging level for messages about the Metadata Server.

Learner – Allows you to select the logging level for messages about the Learner.

Collectors – Allows you to select the logging level for messages about the collectors.

Batch Impact Analysis – Allows you to select the logging level for messages about batch impact analysis.

Metadata Viewer – Allows you to select the logging level for messages about the Metadata Analyzer.

To modify settings used by the Metadata Analyzer

1. Start the Metadata Analyzer Configuration utility.
2. Modify the settings as required referring to the field descriptions above, then click OK. Changes do not take effect until the Metadata Server is restarted.