Need design approach for collecting data from multiple remote databases
- From: Bob Alston <bobalston9@xxxxxxxxx>
- Date: Thu, 30 Aug 2007 15:38:47 -0500
Looking for design approach ideas for collecting data from multiple remote, standalone databases. I have built one of these in Access. Another I am told was built in Access. some others the language and database is unknown.
These systems are all in small agencies which provide utility assistance to people who are having trouble paying their utility bills.
A foundation wants to provide funds. However they want a consolidated database of all services provided. And they want it EVERY NIGHT. Apparently not negotiable. Also the process must work WITHOUT HUMAN INTERVENTION ON THE FOUNDATION END.
the individual agencies, mostly very small aren't willing to duplicate enter the data and they all want to use their existing systems as they provide food, clothing and other kinds of assistance.
clearly I could build a process to extract data and reformat it as required from the Access databases.
I could build an automated FTP process to send the data.
On the receiving side, I could build a process to monitor the directory into which the FTP files are placed and grab the files and load the database.
Can anyone suggest an alternate approach, preferably much improved???
Bob
.
- Follow-Ups:
- Prev by Date: Blank Forms
- Next by Date: Re: outlook calendar
- Previous by thread: Blank Forms
- Next by thread: Re: Need design approach for collecting data from multiple remote databases
- Index(es):
Relevant Pages
|
