About the parameters for the Database Conversion tool

The Database Conversion tool uses specific parameters and values to access managers, extract their information, and convert the results for an external relational database.

Type all parameters, both mandatory and optional, and their related values on the same line at the command prompt.

Table: Database Conversion tool parameters and values lists the Database Conversion tool parameters and their related values.

Table: Database Conversion tool parameters and values

Parameter names	Parameter values
esm.managers (mandatory entry, one per Database Conversion tool command)	This value specifies the name of a manager. To include more than one manager, separate the manager names with spaces.
<manager_name>.user (mandatory entry, one per manager)	This value specifies a user account with rights to read information on the manager. If you include more than one manager, you must type a separate user account entry for each manager.
<manager name>. password (mandatory entry, one per manager)	This value specifies the password of the user account on a specified manager. If you include more than one manager, you must type a user account entry for each manager.
jdbc.datasource (mandatory when using the Windows ODBC Data Source Administrator; one entry per Database Conversion tool command)	This value specifies the data source name. For example, if you use the Windows ODBC Data Source Administrator to select the ESMReports database, type ESMReports.
jdbc.driver (mandatory when not using the Windows ODBC Data Source Administrator; one entry per Database Conversion tool command)	If you do not use the Windows ODBC Data Source Administrator to select the Reports database, download the JDBC driver for the destination database from the vendor's Web site. For example, if you use ORACLE, access www.oracle.com, find the JDBC driver, and download it to the host computer. Save the driver in the same directory with the dbconvert.jar file. In the vendor documentation, find the class name for the downloaded driver. This is a case-sensitive value of this parameter.
jdbc.url (mandatory when not using the Windows ODBC Data Source Administrator; one entry per Database Conversion tool command)	This parameter specifies the location of the destination database for the Database Conversion tool. If you are not using the Windows ODBC Data Source Administrator, see the database vendor's Web site documentation. For example, when using ORACLE, go to www.oracle.com. In the documentation for the JDBC driver, find the URL convention that locates the database. Follow the convention exactly. This is a case-sensitive value of this parameter.
jdbc.user (mandatory for a password enabled database; one entry per Database Conversion tool command)	This value specifies the name of the user account with rights to modify the destination database.
jdbc.password (mandatory for a password enabled database; one entry per Database Conversion tool command.)	This value specifies the password of the user account on the destination database.
dbconvert.rawreports (optional entry; one per Database Conversion tool command.)	This value is set to true by default. If true, the Database Conversion tool exports the raw report details for each policy run including the file and associated properties, permissions, and other miscellaneous data. If false, the Database Conversion tool disables raw report functionality.
dbconvert.jobsummary count (optional entry; dbconvert.jobsummary, dbconvert.jobnumber, and dbconvert.allrecent- jobs are mutually exclusive)	This value specifies the number of summary jobs for the Database Conversion tool to export. Type a positive integer to select that number of current summary jobs. For example, type 10 to export the 10 most recent summary jobs.
dbconvert.jobnumber (optional entry; dbconvert.jobsummary, dbconvert.jobnumber, and dbconvert.allrecent- jobs are mutually exclusive)	The Database Conversion tool can export a single policy run. Type 0 for the most current policy run. Type -1 for the first previous policy run, -2 for the second previous policy run, and so forth. Type a positive integer to select a specific policy run. For example, type 81 to specify policy run number 81.
dbconvert.allrecentjobs (optional entry; dbconvert.jobsummary, dbconvert.jobnumber, and dbconvert.allrecent- jobs are mutually exclusive)	This value is set to false by default. If true, the Database Conversion tool exports all policy runs that occurred subsequent to the last database conversion.
<manager name>.port (optional entry; one per Database Conversion tool command - the default is 5600.)	This value specifies the TCP port number that is used to contact the manager. If you select more than one manager, and the managers use different port numbers, you must specify the TCP port number for each manager. Separate TCP port numbers with spaces.

Parameter names

Parameter values

esm.managers

(mandatory entry, one per Database Conversion tool command)

This value specifies the name of a manager. To include more than one manager, separate the manager names with spaces.

<manager_name>.user

(mandatory entry, one per manager)

This value specifies a user account with rights to read information on the manager. If you include more than one manager, you must type a separate user account entry for each manager.

<manager name>. password

(mandatory entry, one per manager)

This value specifies the password of the user account on a specified manager. If you include more than one manager, you must type a user account entry for each manager.

jdbc.datasource

(mandatory when using the Windows ODBC Data Source Administrator; one entry per Database Conversion tool command)

This value specifies the data source name. For example, if you use the Windows ODBC Data Source Administrator to select the ESMReports database, type ESMReports.

jdbc.driver

(mandatory when not using the Windows ODBC Data Source Administrator; one entry per Database Conversion tool command)

If you do not use the Windows ODBC Data Source Administrator to select the Reports database, download the JDBC driver for the destination database from the vendor's Web site. For example, if you use ORACLE, access www.oracle.com, find the JDBC driver, and download it to the host computer. Save the driver in the same directory with the dbconvert.jar file. In the vendor documentation, find the class name for the downloaded driver. This is a case-sensitive value of this parameter.

jdbc.url

(mandatory when not using the Windows ODBC Data Source Administrator; one entry per Database Conversion tool command)

This parameter specifies the location of the destination database for the Database Conversion tool. If you are not using the Windows ODBC Data Source Administrator, see the database vendor's Web site documentation. For example, when using ORACLE, go to www.oracle.com. In the documentation for the JDBC driver, find the URL convention that locates the database. Follow the convention exactly. This is a case-sensitive value of this parameter.

jdbc.user

(mandatory for a password enabled database; one entry per Database Conversion tool command)

This value specifies the name of the user account with rights to modify the destination database.

jdbc.password

(mandatory for a password enabled database; one entry per Database Conversion tool command.)

This value specifies the password of the user account on the destination database.

dbconvert.rawreports

(optional entry; one per Database Conversion tool command.)

This value is set to true by default.

If true, the Database Conversion tool exports the raw report details for each policy run including the file and associated properties, permissions, and other miscellaneous data.

If false, the Database Conversion tool disables raw report functionality.

dbconvert.jobsummary count

(optional entry; dbconvert.jobsummary, dbconvert.jobnumber, and dbconvert.allrecent- jobs are mutually exclusive)

This value specifies the number of summary jobs for the Database Conversion tool to export. Type a positive integer to select that number of current summary jobs. For example, type 10 to export the 10 most recent summary jobs.

dbconvert.jobnumber

(optional entry; dbconvert.jobsummary, dbconvert.jobnumber, and dbconvert.allrecent- jobs are mutually exclusive)

The Database Conversion tool can export a single policy run. Type 0 for the most current policy run. Type -1 for the first previous policy run, -2 for the second previous policy run, and so forth. Type a positive integer to select a specific policy run. For example, type 81 to specify policy run number 81.

dbconvert.allrecentjobs

(optional entry; dbconvert.jobsummary, dbconvert.jobnumber, and dbconvert.allrecent- jobs are mutually exclusive)

This value is set to false by default.

If true, the Database Conversion tool exports all policy runs that occurred subsequent to the last database conversion.

<manager name>.port

(optional entry; one per Database Conversion tool command - the default is 5600.)

This value specifies the TCP port number that is used to contact the manager. If you select more than one manager, and the managers use different port numbers, you must specify the TCP port number for each manager. Separate TCP port numbers with spaces.