Integration Composer adapters

To import data from a source database into a target database, you use an integration adapter to transform data from the source format to the target format. An integration adapter consists of a data schema that defines data contents and relationships in a database and a mapping file that specifies what objects in the source database are mapped to objects in the target.

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.

For information about the discovery tools that are supported, see https://www.ibm.com/support/pages/node/6516328.

Data schemas

A data schema is a structure for organizing and classifying data in a database. Integration Composer provides default data schemas for the integration adapters.

The https://www.ibm.com/support/pages/node/6516328 provides the data schema names for the discovery tools that are supported and the name of the corresponding adapter mapping file. In the Integration Composer user interface, whenever you select the name of a data schema to use as your data source, the integration adapter that is associated with that data schema is used.

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.

Mappings and mapping files

A mapping file is a file with an .fsn extension that contains a set of expressions that tell Integration Composer how to create data in the target database using information from a source database. For each data instance that you want to import from a source to a target, you define an expression that specifies how to transform the data for that property when it is migrated.

When creating a mapping, you specify the connection information for the source data source and target data source, name the mapping, and import the .fsn file. After you import a mapping file into Integration Composer, you can modify the expressions in the file to suit your business needs. Then you run the mapping to bring the data from the source into the target. The data is transformed to the target data structure in the process.

Mapping files in Integration Composer are stored in the Integration Composer\data\mappings directory.