Running a mapping by supplying parameter values in a command

Another way to run a mapping is to issue the executeMapping command by providing all the necessary parameter values directly on the command line itself. The executeMapping command runs the unedited script, and you supply all the values in the command rather than in the script.

Before you begin

Before you run the mapping, review the command syntax, parameters, and usage:

 

Syntax:

executeMapping [-delete] mappingName repositoryUser repositoryPwd sourceUser sourcePwd targetUser targetPwd

Parameters:

-delete
[Optional.] Specify -delete if you want the mapping last-scan history to be deleted prior to running the mapping.
mappingName
The name of the predefined mapping; for example, type "Tivoli® to DPA".
repositoryUser
The login user name for the Integration Composer repository; for example, type maximouser.
repositoryPwd
The login password for the Integration Composer repository; for example, type maximopw.
sourceUser
The login user name for the data source of the discovered source data; for example, type discovereddata.
sourcePwd
The login password for the data source of the discovered source data; for example, type discoveredpw.
targetUser
The login user name for the target database; for example, type maximouser.
targetPwd
The login password for the target database; for example, type maximopw.

Usage:

  • Close Integration Composer before issuing the command.
  • UNIX users must specify ./executeMapping.sh instead of executeMapping as the command name.
  • Issue the command from the bin subdirectory in your Integration Composer installation directory, installation_dir\bin.
  • Always type the parameter values for your command in the same order as they appear in the command syntax.

The steps for running the mapping follow.

Procedure

  1. If Integration Composer is open, close the application.
  2. Open a command prompt.
  3. Navigate to the bin subdirectory in your Integration Composer installation directory, installation_dir\bin
  4. On the command line, type one of the following and add the command parameters and values you want:
      Windows: executeMapping
      UNIX: ./executeMapping.sh
  5. Press Enter to run the command.

Example

The following command example (for Windows operating systems) uses the -delete option to remove the last scan history, and uses the parameter values illustrated in the preceding "Parameters" section:

executeMapping -delete "Tivoli to DPA" maximouser maximopw discovereddata discoveredpw maximouser maximopw

To retain the last scan history, omit the -delete option:

executeMapping "Tivoli to DPA" maximouser maximopw discovereddata discoveredpw maximouser maximopw

On UNIX-based operating systems, specify ./executeMapping.sh instead of executeMapping as the command name.



Feedback