Oracle Migration Tool On Demand Guide > Migrating Access Profiles > Migrating Access Profiles >

Updating or Inserting an Access Profile (Upsert)

This topic describes how to update a specific access profile (if it exists), or insert that access profile (if it does not exist) on your Oracle CRM On Demand environment (customer test environment or production). For the purposes of the Oracle Migration Tool On Demand client, this is known as an Upsert operation. This operation is specified using the Upsert command.

About the Upsert Operation

The Upsert command inserts or updates an access profile based on the <Name> value, which is the system name of the access profile. If an access profile already exists with the same <Name> value, then the access profile is updated, otherwise, a new access profile is created. The matching of the access profile system names is case sensitive.

Syntax

The following is the syntax for using the Oracle Migration Tool On Demand client to update a specific access profile (if it exists) or insert the access profile (if it does not exist):

migrationtool -u UserID -s ServerURL Upsert AccessProfile AccessProfileXML 

where:

• UserID is the user sign-in ID that has the appropriate privileges to run the Oracle Migration Tool On Demand client commands.
• ServerURL is the URL for the Oracle CRM On Demand server where your company resides.
• AccessProfileXML is the fully qualified path name of the access profile XML file, for example:

  C:\My Files\My Profile.xml

The Oracle Migration Tool On Demand client requests your Oracle CRM On Demand password, which can be redirected (using the pipe command) to the client program from standard input; that is, from a file, from the command line, or from another program.

Example of Updating or Inserting an Access Profile

The following is an example of updating a specific access profile (if it exists) or inserting that access profile (if it does not exist) in your Oracle CRM On Demand server:

migrationtool -u UserID -s ServerURL Upsert AccessProfile "C:\My Files\My Profile.xml"

NOTE:  Quotation marks are required only if the path or file name contains spaces.