Executing a mapping
When you create a mapping, you define a set of expressions that specify how to transform instances of data from a source to a target. To transform the data and import it from the source into a target, you must execute the mapping.
You execute mappings from a command line interface. To execute a mapping, you run the script that is located in the bin subdirectory of the Integration Composer installation directory. For Microsoft Windows operating systems, the file is executeMapping.bat. For UNIX-based operating systems the file is executeMapping.sh.
The executeMapping.bat and executeMapping.sh files require that you set parameters for the mapping.
Deleting last scan history
Setting this parameter is optional. By default, when importing data, Integration Composer processes only the data that has changed since the last scan date. However, if you modify a mapping and you want to implement the change, you might want all data processed. To accomplish this, you must delete the last scan history. Set the -delete parameter only if you want all data processed when you execute the mapping.
You can also choose to delete the last scan history using the Delete Mapping Last Scan History option in the Integration Composer user interface before you execute the mapping.
Mapping execution specifications
You must specify mapping name, repository user name and password, source user name and password, and target user name and password for mapping execution.
There are three options for defining these parameters.
- You can use an editor such as Notepad to open the executeMapping.bat or executeMapping.sh file, specify the parameters, and then execute the file. If you have more than one mapping to execute, you can edit the file and save separate files for each mapping that you want to execute.
- You can provide parameter arguments directly after the executeMapping command line.
- You can use a command line that invokes the executeMapping.properties file to run the mapping. You must select this option if you want to encrypt passwords.