Thanks for your reply, Massimo! Out of curiosity, are they using migration scripts to create/ update the warehouse DB, or a middle-ware product like Talend or Pervasive?
On Sep 21, 3:35 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > At the university where I work they run many different systems > including peoplesoft with oracle. Neverthess they find it convenient > to have a data warehouse and I think it is a good idea. This allows > other users to get access the data on a need to know bases and allows > them to manage permissions. Moreover if any of those systems gets > upgraded you only may need to change the query to move data to the > warehouse and not the third party programs that depend on those data. > > Even if you can connect to multiple databases your life will be easier > with a data warehouse. > > On Sep 21, 4:38 pm, snfctech <tschm...@sacfoodcoop.com> wrote: > > > The big reason I started investigating web2py was multi-db > > connectivity. > > > I've got a large dashboard application I'm about to start work on that > > has data on MSAccess, MySQL, Pervasive, FileMaker and flat file DB > > engines. This all needs to come under one roof and interaction needs > > to be seemless to the user. For example, I'll need to have an order > > creation form with relations to separate product, member and employee > > databases. > > > Before finding web2py, I was told the best way to do this would be to > > create a batch updated data warehouse. I initially thought that was > > an unnecessary step - why not just connect directly to all your data > > sources, if you have that option? > > > But then I found one possible advantage of the data warehouse - > > enabling "middle tier" development staff with tools like OOBase (which > > cannot make multiple connections). Table creation and write > > permissions would be managed for those users, of course. > > > So, what do you think? Any other reasons for creating a batch updated > > data warehouse with a unified schema? Or are direct connections to > > multiple DBs the way to go? > > > Thanks. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
