Appliance That Monitors Database Table for new Records and Posts to Webservice

Ολοκληρωμένο Αναρτήθηκε Apr 27, 2008 Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

The general idea is to build a linux app that can be installed on a network to monitor a database for new records, and post those records to a webservice to be inserted into my database.

I have a healthy budget to develop this app, so I want to do it right and build a solid and reliable appliance. Give me your BEST ideas and this could be a long term project! :) I am willing to pay for quality!

## Deliverables

First, let me explain the business problem I have then I will explain my idea for a solution that I am looking for a coder to help me with.

I developed the SQL 2005 database that collects information on other systems permits. the simplest way for the database to collect this information is through a webform where the information is inputted and saved.

However, there are other clients that we need to track their permit information and they want to keep their existing permit system and their volume is to high to have to reenter each one.

So I want to setup a webservice that acts as a gateway for other applications to write records to my permitstracked table directly.

However, instead of writing code INTO the other applications to post to the webservice, I had another idea:

1. Build a small server/appliance with a server system of something like CENTOS 5 that could be installed on the same network of the program whose data we want to capture.

2. This appliance would be configured with a site id, database connection information of the database that holds the data we want, and the exact table names of the data we want.

3. This appliance this had software on it that would monitor the tables it has been assigned to "watch". Whenever it detects a new record has been added to the database it would capture this record and its field names and post this to the webservice.

4. The webservice would be configured to take these fields and match them with the appropriate fields in my table and insert the record.

Thats the general idea, build a linux app that can be installed on a network to monitor a database for new records, and post those records to a webservice to be inserted into my database.

I am sure more details need to be fleshed out here. Perhaps there can be built in alerts if the field names change so we can know that we have to update the webservice to correctly process the data.

I would like this to monitor SQL server and Access and a minimum. Other databases types would be great as well but not a requirement.

I have a healthy budget to develop this app, so I want to do it right and build a solid and reliable appliance. Give me your BEST ideas and this could be a long term project! :) I am willing to pay for quality!

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

I would like some kind of Linux OS. i like Centos 5, but I am open to others.

** I will consider windows based solutions, but I would really like a linux based one. but if you think you have a really great windows based solution, please share it and convince me why yours is the best.

** I have no problems with a Java solution or any other language you want to write it it.

Διαχείριση Βάσεων Δεδομένων Μηχανολογία Linux MySQL PHP Αρχιτεκτονική Λογισμικού Δοκιμή Λογισμικού SQL UNIX

Ταυτότητα Εργασίας: #3897999

Σχετικά με την εργασία

20 προτάσεις Απομακρυσμένη εργασία Ενεργό Jul 5, 2008

Ανατέθηκε στον:

innovativeWork

See private message.

$1224 USD σε 14 μέρες
(101 Αξιολογήσεις)
6.9

20 freelancers κάνουν προσφορές κατά μέσο όρο $1474 για αυτή τη δουλειά

mrroberto

See private message.

$510 USD σε 14 μέρες
(209 Αξιολογήσεις)
7.3
kadnan

See private message.

$425 USD σε 14 μέρες
(8 Αξιολογήσεις)
4.1
thechaoshacker

See private message.

$467.5 USD σε 14 μέρες
(10 Αξιολογήσεις)
3.5
amarga

See private message.

$505.75 USD σε 14 μέρες
(3 Αξιολογήσεις)
3.4
indrasyafruddin

See private message.

$425 USD σε 14 μέρες
(4 Αξιολογήσεις)
3.2
vigo9

See private message.

$680 USD σε 14 μέρες
(5 Αξιολογήσεις)
2.3
hbsys

See private message.

$2125 USD σε 14 μέρες
(1 Κριτική)
0.0
sumitsahay

See private message.

$4250 USD σε 14 μέρες
(0 Αξιολογήσεις)
0.0
thomsonampt

See private message.

$2762.5 USD σε 14 μέρες
(2 Αξιολογήσεις)
0.0
wfpvw

See private message.

$2550 USD σε 14 μέρες
(0 Αξιολογήσεις)
0.0
josotec

See private message.

$1275 USD σε 14 μέρες
(0 Αξιολογήσεις)
0.0
domgio

See private message.

$4165 USD σε 14 μέρες
(0 Αξιολογήσεις)
0.0
chiappgon

See private message.

$467.5 USD σε 14 μέρες
(1 Κριτική)
0.0
mauricesarks

See private message.

$1572.5 USD σε 14 μέρες
(1 Κριτική)
0.0
toniosoft

See private message.

$1530 USD σε 14 μέρες
(0 Αξιολογήσεις)
0.0
bbhvw

See private message.

$1275 USD σε 14 μέρες
(0 Αξιολογήσεις)
0.0
donperez

See private message.

$1700 USD σε 14 μέρες
(1 Κριτική)
0.0
mashen

See private message.

$722.5 USD σε 14 μέρες
(2 Αξιολογήσεις)
0.0
marshallx

See private message.

$841.5 USD σε 14 μέρες
(1 Κριτική)
0.0