Integration of COTS software data stores into integrated data access layer

摘要

A system for integration of commercial-off-the-shelf software applications and databases is provided. The system includes a commercial-off-the-shelf software application operable with a first data store and providing an output compatible with the first data store. The system includes a translator, a second data store, a service broker and a data access layer. The translator is operable to receive the commercial-off-the-shelf software application output and to translate the output to a format compatible with a second or other data store, such as newer version data stores or different vendor data stores. The second data store is operable to receive and store the translated output. The service broker is operable to maintain a record of transactions output from the commercial-off-the-shelf software application and to maintain a record of transactions stored in the second data store. The storage broker is further operable to roll-back failed transactions in the second data store.