Oracle Migration Tool On Demand Guide > Migrating Integration Event Queue Configuration Data > Migrating Integration Event Queue Configuration Data >

Updating or Inserting an Integration Event Queue (Upsert)

This topic describes how to update the configuration data for an integration event queue (if the queue exists) or insert an integration event queue (if it does not exist) on your Oracle CRM On Demand environment (customer test environment or production).

About the Upsert Operation

The Upsert command inserts or updates integration event queue configuration data based on the user key: <QueueName>.

Oracle CRM On Demand attempts to locate the integration event queue specified in the input file based on the user key. If a match is located, then the configuration data for the integration event queue is updated. If Oracle CRM On Demand cannot locate an integration event queue based on the user key, then a new integration event queue is created.

Syntax

The following is the syntax for using the Oracle Migration Tool On Demand client to insert or update the configuration data for an event queue:

migrationtool -u UserID -s ServerURL Upsert IntegrationEventQueue IntegrationEventQueueXML

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.
• IntegrationEventQueueXML is the fully qualified path name of the integration event queue XML file, for example:

  C:\My Files\MyQueue.xml

  If the fully qualified path name contains any spaces, then it must be enclosed with quotation marks, for example:

  migrationtool -u UserID -s ServerURL Upsert IntegrationEventQueue "C:\My Files\MyQueue.xml"

NOTE:  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 the Configuration Data for an Integration Event Queue

The following is an example of updating the configuration data for an integration event queue (if the queue exists) or inserting an integration event queue (if it does not exist) in your Oracle CRM On Demand server:

migrationtool -u UserID -s ServerURL Upsert IntegrationEventQueue "C:\Oracle Migration Tool On Demand\repository\IntegrationEventQueue\MyQueue.xml"

NOTE:  Quotation marks are required only if the fully qualified path name contains spaces.