Patent ID: 8407237

Claim:
A computer-implemented method of connecting legacy database applications and new database systems, comprising: storing, by an application server, a legacy database application, wherein the legacy database application is configured to interface with a legacy database system, wherein the legacy database application includes a plurality of SQL (structured query language) scripts, and wherein the plurality of SQL scripts are written in an open SQL format; implementing, by the application server, a configuration table and a shared memory area; receiving, by the application server, a selected SQL script, selection parameters, and a database parameter, wherein the selected SQL script is one of the plurality of SQL scripts, and wherein the database parameter indicates one of the legacy database system and a new database system; storing, by the application server in the configuration table, the selected SQL script, the selection parameters and an identifier, wherein the identifier uniquely identifies the selected SQL script and the selection parameters; connecting, by a connector program, to the application server when the database parameter indicates the new database system; reading, by the connector program, the selected SQL script and the selection parameters according to the identifier; processing, by the connector program, the selected SQL script to generate a parsed SQL script, wherein the processing parses the open SQL format to a new format, wherein the new format is used by the new database system; executing, by the connector program, the parsed SQL script using the selection parameters to extract data from the new database system; writing, by the connector program, the data from the new database system into the shared memory area using the identifier; and displaying, by the application server, the data from the new database system in the shared memory area according to the identifier.