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 -~----------~----~----~----~------~----~------~--~---
