Creating a property file for the Database Conversion tool

Property files let you type Database Conversion tool commands with a minimum of time and effort.

You can create several property files. However, you can include only one property file in each Database Conversion tool command. To override a value in a property file, include a -D option and specify the appropriate parameter and value in the Database Conversion tool command.

If you restrict access to a property file, no one else can use the file.

Note:

Do not use quotes in property file entries. For example, if you type esm.managers="gs0100 gs0200", the Database Conversion tool does not connect with managers gs0100 and gs0200. Instead, it attempts to connect with manager "gs0100 gs0200". Also, do not use quotes when specifying user names and passwords.

The following are the sample property files:

ODBC compliant database

This sample property file contains the parameters and values that are needed to export data from managers GS0100 and GS0200 to the ESMReports ODBC database.

The following is the format:

esm.managers=gs0100 gs0200
		gs0100.user=security officer
		gs0100.password=my1pass+
		gs0200.user=security officer
		gs0200.password=my2pass+
		jdbc.datasource=esmreports

ORACLE

This sample property file contains the parameters and values that are needed to export data from managers GS0300 and GS0400 to an ORACLE database.

The following is the format:

esm.managers=gs0300 gs0400
		gs0300.user=security officer
		gs0300.password=my3pass+
		gs0400.user=security officer
		gs0400.password=my4pass+
		jdbc.driver=oracle.jdbc.driver.OracleDriver
		jdbc.url=jdbc:oracle:thin:@GS0500:1521:REPORTS
		jdbc.user=user1453
		jdbc.password=secret7

To create a Database Conversion tool property file

Use any text editor to create the ASCII plain-text property file.
Type one parameter and its value per line in the file.
Save the property file in the directory that contains the Database Conversion tool.
Use any text file extension (for example, property.txt).