I do not know. I can ask but I suspect the former.
On Sep 21, 6:54 pm, snfctech <tschm...@sacfoodcoop.com> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
