Method, apparatus and system for transforming, converting and processing messages between multiple systems

1. A method of sending change information from a first database to a second database, comprising:

within the first database, identifying data that has changed since some prior point in time, wherein the identified data changed as a result of executing a set of executable commands associated with the identified data;

regenerating the set of executable commands associated with the identified data;

attaching a tag to a first command of the regenerated set of executable commands, wherein the tag comprises a conversion rule for the first command, wherein the conversion rule when employed, is configured to resolve at least one discrepancy resulting from a database schema for the first database being different from a database schema for the second database;

generating a first message as a function of the regenerated set of executable commands wherein the message comprises the regenerated set of executable commands;

transforming the first message into a second message; and

converting the second message into a transmittable message.

2. The method of claim 1 further comprising:

finding a record identifier related to the first command, invoking a method for the first command and the record associated with the record identifier.

3. The method of claim 2 wherein:

transforming the first message into the second message comprises finding a next part of the first message, identifying sub-message parts of the next part, traversing a body of the first message, finding the first command of the body of the first message, transforming the first command of the body of the first message into a special format based on a set of pre-defined rules for repackaging, and packaging the formatted first message into the second message.

4. The method of claim 3 wherein:

converting the second message into the transmittable message comprises finding the second message, determining whether an envelope is required for the transmittable message, processing a transaction of the second message processing data objects of the transaction of the second message, generating processing instructions for the second message, and assembling the processed transaction, processed data objects, and processing instructions into the transmittable message.

5. The method of claim 4 wherein:

converting the second message into the transmittable message further comprises generating an envelope and headers if required for the transmittable message, and attaching the processed transaction and the processed data objects to the envelope of the transmittable message if the envelope is present.

6. The method of claim 5 wherein:

transforming the first message into the second message further comprises processing a header portion of the first message and passing through non-commands of the body portion of the first message.

7. The method of claim 1 wherein the conversion rule resolves the discrepancy resulting from the data type of a customer_id in the first database being defined as of type string and the data type of the customer_id being of type integer in the second database.

8. The method of claim 7 wherein the conversion rule causes the system to perform a set of predefined operations to convert the parameter customer_id from data type string into data type integer to resolve the discrepancy resulting from the distinct data types in the first and the second database.

9. A machine-readable medium embodying instructions, which, when executed by a processor, cause the processor to perform a method of sending change information from a first database to a second database, the method comprising:

within the first database, identifying data that has changed since some prior point in time wherein the identified data changed as a result of executing a set of executable commands associated with the identified data;

generating regenerating the set of executable commands associated with the identified data;

attaching a tag to a first command of the regenerated set of executable commands, wherein the tag comprises a conversion rule for the first command the conversion rule when employed is configured to resolve at least one discrepancy resulting from distinct database management systems for the first database and the second database;

generating a first message as a function of the regenerated set of executable commands wherein the message comprises the regenerated set of executable commands;

transforming the first message into a second message utilizing a custom script and default processing; and

converting the second message into a transmittable message;

transmitting the transmittable message to a computer system in data communication with the second database.