Delphi ODBC Database Sync Utility

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.

Kemahiran: Delphi

Lihat lagi: delphi odbc project, sync tool odbc, delphi database sync, what are the application of data structure, uses of data structure, select medical, data structure uses, applications of data structure, Applications builder, database delphi odbc, database sync utility, delphi odbc import, what is database management, what is community management, service management database, service database , propose, medical records, import database, delphi to c#, database system, database management project, select deleted, delphi utility, added database

Tentang Majikan:
( 121 ulasan ) Belfast, Ireland

ID Projek: #255512