Mapping process
When you import data into the target database, there is a sequence of operations to perform. However, if you are using an Integration Composer adapter to migrate data, you may need to perform some additional preliminary steps before data can be imported.
- Define the source and target data sources.
You must define a data source for any source that contains the data you want to import and for the target Maximo® database. Integration Composer uses JDBC drivers or an API to connect to source and target data sources. After you install Integration Composer , you must define source and target data sources. To define a data source, select Define New Data Source in the Integration Composer user interface and perform the following steps:
- Select a data schema for the data source.
- Name the data source.
- Select a connection method and specify the parameters for connecting to the data source.
- For Hebrew or Arabic installations of Integration Composer, specify bidirectional layout formats for the data source to which you are connecting.
- Review the data in the data sources.
To review classes in a data schema, select Browse Data Source by Structure in the Integration Composer user interface. Select Browse Data Source by Data to review data source instances in addition to classes.
- Create a mapping.
To create a mapping, you select Create New Mapping in the Integration Composer window. Integration Composer displays a New Mapping window in which you select a source data source, select a target data source, and name the mapping.
- Add expressions to the mapping.
After you create a mapping and name it, Integration Composer displays the Mapping window. In this window, you can import the predefined mapping expressions provided in an Integration Composer adapter; or you can create mapping expressions.
- Execute the mapping.
After you create and save a mapping, you execute a mapping from a command line. When you execute a mapping, Integration Composer transforms the data and imports it into the target database. To update data in the target database, such as importing data about new computer equipment, you can run an existing mapping as often as needed.