Bank of America Corporation
Data transformation tool

Abstract:

A data transformation tool includes a receiver, an extraction engine, a transformation engine, and a delivery engine. The receiver receives from a user a request indicating an identifier for reference data, a format, and a delivery type. The reference data includes a data field, a list of permissible values for the data field, and a textual description of the data field. The extraction engine generates, based on the request, a database query requesting reference data identified by the identifier from a database and communicates the query to the database. The transformation engine receives, from the database, the reference data in response to communicating the query to the database and transforms the received reference data into a flat file based on the format indicated by the request. The delivery engine delivers the flat file to the user according to the user using the deliver type indicated by the request.