User's Manual

Chapter 1
Defining the psupgrade.properties Parameters
Parameter Value Definition
pcm.jdbc.url The JDBC connection string to the Product Cost Management database. The format is
jdbc:oracle:thin@
<SOURCE_DB_HOST_NAME>:<PORT>:<SID> where
SOURCE_DB_HOST_NAME is the hostname of the Product Cost Management database,
PORT is the listener port of the database (1521 is the default), and SID is the database
instance.
pcm.jdbc.driver The database driver of the Product Cost Management database. The default is
oracle.jdbc.driver.OracleDriver.
pcm.db.user The database user of the Product Cost Management database.
pcm.db.password The encrypted database password of the Product Cost Management database. Use the
encryptpwd utility located in the $AUT_HOME\bin directory to encrypt the password.
pcm.tns.name The TNS entry name in the Oracle Home of the source database.
pcm.oracle.home The Oracle Home of the Product Cost Management 8.5 database.
Note Use either double back slashes or a forward slash for
directory separation, for example, d:/oracle/ora92.
generate.pcm.reports Set this parameter to true to generate a report about the data contained in the Product Cost
Management database before migration. The report will display data matching the following
rules:
1. Update firstname, lastname, and user organization for the matched
user login ID, if you set the update.matched.user.data parameter to true.
2. Migrate the Product Cost Management Items not found in Agile 8.5,
if you set the migrate.pcm.items.not.found.in.pc parameter to true.
3. Convert all manufacturer names to uppercase, if you set the
convert.mfrName.to.upperCase parameter to true.
4. Update all Agile 8.5 manufacturer data with the Product Cost
Management manufacturer data for the same manufacturer, if you set the
update.matched.mfr.data parameter to true.
5. Migrate Product Cost Management manufacturer parts not found in
Agile 8.5, if you set the migrate.pcm.mpns.not.found.in.pc to true.
If you set this parameter to false, migration will proceed without a report being generated.
If you choose to have a report generated, AUT will stop. After viewing the report and you
are satisfied with the results, change this parameter to false and run AUT again.
report.folder.location Location where you want the report to be generated.
update.matched.user.data If set to true, the firstname, lastname, and user organization are updated based on
matching users in the Agile 8.5 database.
Page - 15