Method, system, and product for data integration through a dynamic common model

A system for data integration with respect to data stores in native repositories, the system implemented in conjunction with a data integration application coupled for data communications through a multiplicity of adapters to a multiplicity of native repositories, the native repositories comprising native records having formats having datatypes supported by the native repositories, the system comprising:

• means for extracting through a first adapter from a first native repository a first native record having a first native format, the first native format belonging to a category of formats identified as a first datatype;
• means for transforming, through the first adapter, the first native record having a first native format to a first native record having dynamic common format;
• means for transforming, through a second adapter, the first native record having dynamic common format to a first native record having second native format, the second native format belonging to a category of formats identified as the first datatype;
• and
• means for inserting, through the second adapter, the first native record having a second native format into a second native repository;
• wherein the first adapter and the second adapter each are loosely coupled for data integration to the data integration application;
• wherein dynamic common format comprises a subset of a dynamic common model, the dynamic common model comprising mappings specifying transformations to and from dynamic common formats for all native records having all datatypes supported in all native repositories coupled through adapters to the data integration application;
• means for finding in a catalog, in dependence upon search parameters, catalog records having identifying attributes that match the search parameters,
• wherein the identifying attributes for each catalog record include a catalog key for each catalog record,
• wherein the catalog comprises identifying attributes and proxy data for all native records in a multiplicity of native repositories,
• wherein the multiplicity of native repositories comprises the first native repository;
• and
• wherein at least one found catalog record contains identifying attributes that identify the first native record;
• means for marking for extraction the identifying attributes of the at least one found catalog record containing identifying attributes that identify the first native record;
• means for posting from the marked identifying attributes a catalog key to a transfer cart in the data integration application;
• and
• means for extracting, in dependence upon the posted catalog key, from the catalog through a catalog adapter proxy data for the first native record, wherein the proxy data comprises data representing the location of the first native record in the first native repository;
• wherein means for extracting a first native record from a first native repository further comprises means for reading, in dependence upon the proxy data, through the first adapter, from the first native repository, the first native record having a first native format.

A computer program product for data integration of a multiplicity of native repositories coupled for data communications through a multiplicity of adapters to at least one data integration application, the computer program product including the data integration application, the native repositories comprising native records having formats having datatypes supported by the native repositories, the computer program product comprising:

• a recording medium;
• means, recorded on the recording medium, for extracting through a first adapter from a first native repository a first native record having a first native format, the first native format belonging to a category of formats identified as a first datatype;
• means, recorded on the recording medium, for transforming, through the first adapter, the first native record having a first native format to a first native record having dynamic common format;
• means, recorded on the recording medium, for transforming, through a second adapter, the first native record having dynamic common format to a first native record having second native format, the second native format belonging to a category of formats identified as the first datatype;
• and
• means, recorded on the recording medium, for inserting, through the second adapter, the first native record having a second native format into a second native repository;
• wherein the first adapter and the second adapter each are loosely coupled for data integration to the data integration application;
• wherein dynamic common format comprises a subset of a dynamic common model, the dynamic common model comprising mappings specifying transformations to and from dynamic common formats for all native records having all datatypes supported in all native repositories coupled through adapters to the data integration application;
• means, recorded on the recording medium, for finding in a catalog, in dependence upon search parameters, catalog records having identifying attributes that match the search parameters,
• wherein the identifying attributes for each catalog record include a catalog key for each catalog record,
• wherein the catalog comprises identifying attributes and proxy data for all native records in a multiplicity of native repositories,
• wherein the multiplicity of native repositories comprises the first native repository, and
• wherein at least one found catalog record contains identifying attributes that identify the first native record;
• means, recorded on the recording medium, for marking for extraction the identifying attributes of the at least one found catalog record containing identifying attributes that identify the first native record;
• means, recorded on the recording medium, for posting from the marked identifying attributes a catalog key to a transfer cart in the data integration application;
• and
• means, recorded on the recording medium, for extracting, in dependence upon the posted catalog key, from the catalog through a catalog adapter proxy data for the first native record, wherein the proxy data comprises data representing the location of the first native record in the first native repository;
• wherein means for extracting a first native record from a first native repository further comprises means, recorded on the recording medium, for reading, in dependence upon the proxy data, through the first adapter, from the first native repository, the first native record having a first native format.