Method to perform complex data transformations in preparation for enterprise integration.
Original Publication Date: 2001-May-01
Included in the Prior Art Database: 2003-Jun-12
The data transformation tool will allow complex manipulations of Lotus Notes data in preparation for integration to a target database system. Currently there are products to synchronize and move data from a source database to a target database. Each of these tools has the ability to move data with minor editing functions. In most cases the data must be "prepared" for these data movement tools. This preparation requires custom coding. By using our invention the implementation teams will be able to "configure" how the data should be prepared for export to or import from a remote data source. This will reduce the cost to the customer of integrating their Lotus Notes applications with their enterprise databases. Our invention includes a graphical user interface to build the transformation definitions. The transformation engine will take these definitions and prepare the data accordingly. The following data transformations are included: Concatenate multiple fields on source Notes document to single field on a target Notes document. Parse single field on source Notes document into multiple fields on a target Notes document. Translate data from one value to another based on a definition or map. ex x to y. Convert data types (ex. character to numeric). Specify formatting of data. ex 2813362629 format to (281) 336 2629. Specify justification of data within target field. Specify pad character for target field. Move contents of one field on a source Notes document to multiple fields on a target Notes document. Map values from Notes multi-value field to specific fields on target Notes document (fixed parse). Map values from Notes multi-value field to varying fields on target Notes document (variable parse). Select values in Multi-value field on a Notes document from multiple fields on a Notes document . Parse value from a source Notes document field into multiple fields on a target Notes document. Concatenate multiple fields from source Notes document into one field in a target Notes document. Map groups of Notes response or FORMRunner "child" documents to a single target Notes document with repeating groups of fields representing the fields on each of the response or child documents. Map repeating groups of document fields to multiple Notes response or FORMRunner child documents. Maintain document hierarchy (native Notes or FORMRunner) when moving documents from source to target Notes database. Calculate new document hierarchy (native Notes or FORMRunner) in target Notes database. The transformation definition will include the following: