Entity linking system

A computer executable method for creating a link between a first entity in a first application program and a second entity in a second application program, the method comprising:

• identifying a plurality of entities in the first and second application programs to be linked, wherein identifying comprises receiving a schema containing the plurality of entities to be linked, the plurality of entities being grouped in sets, each set comprising at leant one entity in the first application program and at least one entity in the second application program;
• validating each set of entities, wherein if the set of entities cannot be validated writing an error to a results file;
• after receiving the schema and validating each set of entities, gathering a data source connection for each of the plurality of entities to be linked;
• retrieving a configuration for each of the plurality of entities to be linked;
• for each set of entities to be linked,
• performing an ID check to determine if an ID associated with each entity in the set is valid;
• determining if a record for each entity in the set exists in instance table;
• if a record is not found for a particular entity in the set, creating record in the instance table for the entity, wherein the record includes information identifying the entity and one of the first and second application programs that created the entity;
• determining if a link record exists linking the set of entities in a link table;
• creating a link record, using a processor of the computer, indicative of the set of entities in the link table if no corresponding record is found in the link table linking the set of entities;
• and
• after creating a record in the link table, checking each set of entities for exceptions and returning any exceptions to a user, wherein checking for exceptions checks for at least one of business exceptions and system exceptions, and wherein if an exception is found, writing an entry indicative of the exception to the results file, wherein returning any exceptions returns the results file to the user.

A computer readable storage medium containing computer executable instructions that, when executed, cause a computer to perform a method comprising:

• receiving at an integration component a document including information contained in a first entity representing an entity in a first application program, wherein the document is received from the first application program;
• transforming the document, using a processor of the computer, from a first format associated with the first application program to a second format associated with a second application program, wherein transforming is performed by the integration component;
• posting the transformed document to the second application program;
• receiving at the integration component information contained in a second entity representing an entity in the second application program, wherein the information contained in the second entity is received from the second application program;
• creating a plurality of records in an instance table for a plurality of entities, wherein each of the plurality of records comprises an entry for a particular entity of the plurality of entities, the entry including a source system ID that identifies one of the first and second application programs that created the particular entity, an entity ID that identifies the particular entity, and an entity type that identifies a type of the particular entity, wherein creating the plurality of records comprises:
• creating a first record in the instance table for the first entity, and a second record in the instance table for the second entity, wherein if the source system ID for the entry of the first record is provided as a source system name, querying the first application program that created the first entity, searching a system table for the source system name, identifying a corresponding system ID for the source system name in the system table, and returning to the integration component the corresponding system ID;
• and
• creating a link record in a link table that associates the first application program with the second application program, the link record including an entry for the first record and an entry for the second record.

A computer readable storage medium containing computer executable instructions that, when executed, cause a computer to perform a method comprising:

• receiving an indication of a set of entities that are to be linked, the set of entities comprising at least one entity from a first application program and at least one entity from a second application program, wherein receiving an indication comprises receiving a schema containing a plurality of entities to be linked, the plurality of entities being grouped in sets;
• validating the set of entities, wherein if the set of entities cannot be validated writing an error to a results file;
• for each entity in the set to be linked,
• performing an ID check to determine if an ID of the entity is valid;
• determining if a record for the entity exists in an instance table;
• and
• creating a record in the instance table for the entity if no record is found, wherein creating a record in the instance table comprises creating a plurality of entries in the record including entries for a system ID associated with the entity, an entity type associated with the entity, an entity ID of the entity, and a time stamp indicative of when the record was created in the table;
• and
• determining if a link record exists linking the set of entities in a link table;
• creating a link record in the link table, using a processor of the computer, that links the set of entities if no corresponding record is found in the link table linking the set of entities;
• and
• after creating a record in the link table, checking the set of entities for exceptions and returning any exceptions to a user, wherein checking for exceptions checks for at least one of business exceptions and system exceptions, and wherein if an exception is found, writing an entry indicative of the exception to the results file, wherein returning any exceptions returns the results file to the user.