We have a need to dynamically import data from other applications into an existing database. The 'other' applications are patient management systems used by General Practitioners, medical doctors in the community. They run a variety of database systems, with a variety of database back-ends.
This project is therefore to create a ‘generic’ tool to link my application to almost any database system that already contains the data that needed by my existing application. The structure of my own database and the data that I ‘need’ is known – the structure of the third party database is unknown.
What I propose is to create an application which uses ODBC to create a link to the third party database; then use a query builder to select the fields required. These settings are then saved. This is the ‘administrative’ front end to the utility.
A small application, running as a service would then, based on a configurable timer, run the query and extract data from the third party database. This would be ‘merged’ into the local DBISAM database of my application; records that had changed would be updated and any new records added in. No records would need to be deleted.