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