Monday, September 2, 2013
Hi everyone, noob here.
-- I need to link together two databases, one a production system in Firebird (read only), and the other a scratchpad in MySQL. I have much of this running in VBA, but thats of little use to my remote users on their phones/tabs/etc. It's time to get with the 21st century anyway.
We have an order tracking system where the order goes through certain states. When it gets to one of these, we have to enter data into a 3rd party tracking system, which hands back a tracking number. You might split the order across several shipments. I'm finding our sales reps are finding it difficult to track what's going on once it gets to the shipping side.
So what I'd like to do is make a private web page (with logins) what the user can go to. It would display the list of orders in that shippable state, and any tracking numbers generated for them. Some of the users would be able to edit the tracking numbers as they are generated. This would be all manual, the 3rd party system is in MSSQL, but I don't have access to it (yet).
This *seems* like a suitable first-timer project. But the trick is linking two DBs that don't talk to each other, I assume that I'm going to have to loop over the results of the first query and do sub-queries to look up info in the scratchpad?
Can someone point me to an example using multiple DB's that I might bootstrap off of? All the examples I've seen are based solely on MySQL. There's a few hits in Google, but nothing for the noob.
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/67462e45-d36b-4107-943b-9cac0e468a72%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment