Annulleret

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.

Færdigheder: Delphi

Se mere: delphi odbc project, sync tool odbc, delphi database sync, uses data structure, select medical, data structure uses, applications data structure, applications builder, database delphi odbc, database sync utility, delphi odbc import, service management database, service database , propose, medical records, import database, database system, database management project, select deleted, delphi utility, added database, utility delphi, sync service, create sync service, sync data

Om arbejdsgiveren:
( 121 bedømmelser ) Belfast, Ireland

Projekt-ID: #255512