Hi, Nausikaa. Thanks for your reply. Unfortunately, the legacy systems must remain in place until they are gradually (if ever) phased out. There's a whole bunch of functionality that I don't want to have to recreate in those systems (POS, inventory/accounting, products, etc.). I just want to build new functionality that accesses that data (like the example of an order entry form that creates new order/item data entities in a new DB with keys to entities in the other DBs or to their versions in the warehouse). Most of it should be read only.
I'm starting to hear that a data warehouse is the way to go - but then there's the question of data warehouse vs. data mart, Inmon vs. Kimball, and how I can get started building one in python. I'm not hearing many suggestions for the multi-db approach (which makes me wonder what the Django muli-db branch is for?) On Sep 22, 2:01 am, nausikaa <g.n.muel...@gmail.com> wrote: > Hi snfctech > > With warehouse I assume you mean keeping the datasources and periodic > transfer into a central db (the warehouse). > Why not migrate all your datasources into e.g. a PostgreDQL db? > It is easy to write forms and implement logins/access rights in > django so that your non-technical users can read or edit the > data. Besides you'd remove some (unnecessary) heterogenity and thereby > complexity from your system. > But since I don't know your system I might be missing the point > completely. > > Nausikaa > > On Sep 22, 3:10 am, snfctech <tschm...@sacfoodcoop.com> wrote: > > > I understand that there is a Django branch being actively worked on > > for connections to multiple DB vendors, or that Django + Elixir may be > > a good option. But I'm wondering if building a single data warehouse > > may still be a better way to go? > > > Here's an example of some of the relations I'm going to have to build > > for my project: > > > I've got order and order_item tables with their own data and relations > > to members (Access DB), products (flat file) and employees (MySQL). > > > I initially thought that the best way to manage this would be to > > create a new DB for the order and order_item tables, and then create > > cross-vendor joins in the ORM. But then I came across an unexpected > > advantage of having all the data in an updated warehouse - my semi- > > technical staff could still use products like OOBase, that are limited > > to a single vendor connection, to make reports and forms based on the > > warehouse data. > > > So now I'm wondering - are direct connections to multiple databases > > really the best way to go? Or are there more advantages to building a > > data warehouse (keeping in mind the complexities of the data > > replication, scripts for pushing and pulling data, etc.) > > > Thanks in advance for any tips. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
