Mappings overview

To migrate data from an external data source into a target database, you create a mapping that defines how to transform the data. A mapping is a set of expressions that tell Integration Composer how to format the data in the target that comes from a source.

When Integration Composer imports the data from the source, you define an expression in the target data schema for each property that you want to import. The expression specifies how to transform the data for that property.

To facilitate data migration, Integration Composer includes adapters to transform and import data provided by various asset and systems management tools. The adapters provide predefined mapping expressions that transform data and transfer it from a database created by a discovery tool into the Maximo® database. You can import an adapter mapping into Integration Composer and modify it to suit your business needs. You can then execute the mapping to import data into the target. IBM® provides information for each Integration Composer adapter, which explains how to use it to import data.

To create an Integration Composer mapping, you specify these parameters:

• Source data source
• Target data source
• Mapping name

You can import the mapping you create for an adapter and, using the features in the Integration Composer Mapping window, you can:

• Use the predefined mapping expressions in the adapter
• Create new mapping expressions
• Modify existing expressions

When you install Integration Composer, you can import the mappings that you want to use.

If you want to maintain mappings outside of the Integration Composer repository, you can also export and save a mapping as text file with a .fsnextension.