> 1. The department bought an application for preparing pharmaceutical > medication and this application only supports Firebird as its backend > database. > 2. The department also bought logistcal module and this application > only supports Progress as its backend database. > 3. The department also bought an electronic prescription system and > this application only supports a SQL-2005/2008 database. > > And at last I got the question to combine its data.
Okay. I agree that it looks a bit weird, but probably the total of all decisions still holds the most advantages for the entire enterprise while it might hold downsides for some. You should understand that from our point of view, using an application with Firebird as backend is not the worst you can do ;-). It's the most stable database even in chaotic environments and the most easy to scale up and/or down that I ever encountered. It offers the full range of SQL syntax and all types of connectivity. "Combining" the data in your case is not as complicated as it looks. But I would not necessarily use ODBC for it and so you probably should direct further questions to another list. You need to decide whether you want to just look at the data and analyse it, or if you also want to edit data, probably in all three applications and probably from only one application. In the first case you can have a look at basically any reporting tool. In the latter, personally, I'd try to use .net. to create a cockpit to the databases. It uses abstraction for all types of databases. Depending on the planned longevity of your project and its size, you can either try to use a RAD approach (drag-drop data items to forms) or go in much deeper and create a 3-tier-application with a data layer of its own. have fun! André ------------------------------------------------------------------------------ Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov _______________________________________________ Firebird-odbc-devel mailing list Firebird-odbc-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
