Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We are currently using an old legacy ERP system (Thoroughbred) that we have been bolting on functionality by means of web apps we design in house. I interact with the legacy system via ODBC and have to pay on a per connection base via Licenses. I would like to build in intermediate system that would take the sql requests and process them so that any of our apps could just connect to it to avoid the lic issue.

What would be the best way to build this adapter. I was thinking a web service but to be honest I am not even sure technically what a web service is. I envision that it just takes in requests and "does stuff" with the data and then returns results back to the requester. Sorry about being vague but like I said, I don't have a lot of experience working with web services. Maybe a web service isn't the best way to handle it and I should come at the problem from another direction.

My current strengths are Python and turbogears so if I can stay within my comfort zone it's a plus but is not a requirement.

Thanks for any and all input!

share|improve this question
up vote 1 down vote accepted

Start here:

Also read this:

Then this:

All you're going to do is add RESTful web services to existing Turbogears apps, right? It's pretty easy.

share|improve this answer

Some sort of web service wrapper is definitely a good thought, but you should check the terms of the license to see how they define connection before pulling the trigger. Depending on how it is written, you could be violating the terms.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.