Integration Composer adapters

An adapter consists of a data schema and a mapping. To import data from a source database into a target database, you create a mapping that specifies how to transform data from the source format to the target format.

A mapping is a set of expressions that tell Integration Composer how to create data in the target using information from a source. For each property in the target that you want to import data into, you define an expression that specifies how to transform the data for that property. To import the data, you execute the mapping.

To facilitate data migration, Integration Composer provides adapters to transform and import data maintained by commonly used asset- and system-management tools. Each adapter is designed for a specific discovery tool.

Adapters include a file with an .fsn extension that contains predefined mapping expressions for transforming data from the format of the source data to the format of the target Integration Composer database. You import an adapter mapping into Integration Composer, modify it to suit your business needs, and execute the mapping to import data into a target database.

For information about the discovery tools that are supported, see Discovery Tools Supported in the IBM® Control Desk wiki.

To integrate data from other discovery tools, you can use the Create Data Schema feature in Integration Composer to create a data schema for the discovery tool. After creating the data schema, you can create a mapping based on the new data schema. You can then use the mapping to import data into the target database.