Managing data coming out of the warehouse or ODS
Posted: Fri Jan 04, 2008 8:42 am
I've a general question that I thought many here might have already answered in their own environments.
Given that there are a number of feeds generating shared dimensions and fact tables in the warehouse (and that there will eventually be an ODS) and other groups desire access to the data in order to use it within another application.
We can grant controlled access to the warehouse/ODS via one or more logins that expose the desired tables/views and allow those other groups to build whatever feed they desire to pull the data into their application.
Or, we can reduce or eliminate direct access and build the feeds to push the data into their applications, thus controlling how the data is obtained and being able to manage the number of feeds since some requests can be consolidated into the same feed. Of course, this puts us into the mode of being the provider of all feeds.
Anyone desire to weigh in on this? Is there a best practice response for this question?
Thanks.
Given that there are a number of feeds generating shared dimensions and fact tables in the warehouse (and that there will eventually be an ODS) and other groups desire access to the data in order to use it within another application.
We can grant controlled access to the warehouse/ODS via one or more logins that expose the desired tables/views and allow those other groups to build whatever feed they desire to pull the data into their application.
Or, we can reduce or eliminate direct access and build the feeds to push the data into their applications, thus controlling how the data is obtained and being able to manage the number of feeds since some requests can be consolidated into the same feed. Of course, this puts us into the mode of being the provider of all feeds.
Anyone desire to weigh in on this? Is there a best practice response for this question?
Thanks.