May 27, 2010 at 3:12 pm
Hello -
I have been reading so much on data warehousing that I feel like I should know this but here I go. How does it get installed? Am I missing something when I run the sql install?
Any insight would be great. Sorry for being such a newbie to this.
Regards,
David
May 27, 2010 at 3:51 pm
I'm lost, what are you looking for here?
May 28, 2010 at 5:21 am
Hi -
Well when you install SQL you can choose to install SSRS or SSIS etc... But I do not see a choice for Data Warehouse. Where or what is that part of during the install?
Thanks,
David
May 28, 2010 at 7:41 am
There isn't a datawarehouse component per se. It looks like what you looking for is Analysis Services, SSAS. This can be used in developing a datawarehouse.
May 28, 2010 at 7:45 am
Actually I'll be needing to install Reporting Services then. This is for Operations Manager from MS. So when I install Reporting Services I then from within there would config the data warehouse?
Thank you for all the replies this is helping me get a better picture.
May 28, 2010 at 8:10 am
david.ostrander (5/28/2010)
Actually I'll be needing to install Reporting Services then. This is for Operations Manager from MS. So when I install Reporting Services I then from within there would config the data warehouse?Thank you for all the replies this is helping me get a better picture.
Still lost, what data warehouse?
May 28, 2010 at 8:31 am
If you've done a regular install of Operations Manager, Reporting Services was installed as a component. It has to be there.
As far as getting at the datawarehouse, again, you have to have configured that to be on a specific server somewhere in your organization as part of the OM install. To get custom reports out of it (good luck on reading the structures, I can't help you there, I just feel my way), simply connect to that server from reporting services.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 28, 2010 at 9:27 am
A data warehouse is not something you install.
Adventure Works has a transactional data base and a data warehouse model.
Exploring this, and possibly some sample labs, might be helpful.
On a high level, a data warehouse based off a transactional data base, is designed more for optimizing reporting needs.
You may only load once a day, cleansing transactions at times as they go through an ETL process, and summarzie at a daily level.
I wish it was just something to just install - it would make my job much easier.
Greg E
May 28, 2010 at 10:15 am
Greg Edwards-268690 (5/28/2010)
A data warehouse is not something you install.Adventure Works has a transactional data base and a data warehouse model.
Exploring this, and possibly some sample labs, might be helpful.
On a high level, a data warehouse based off a transactional data base, is designed more for optimizing reporting needs.
You may only load once a day, cleansing transactions at times as they go through an ETL process, and summarzie at a daily level.
I wish it was just something to just install - it would make my job much easier.
Greg E
In this case, it actually is something you install. Microsoft System Center Operations Manager has a long term storage & a short term storage. The long term storage is called the Data Warehouse. It isn't really A data warehouse, but it is THE Data Warehouse. I'm pretty sure that's what we're talking about here.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 28, 2010 at 1:52 pm
Got it - the SCOM version -they use Reporting Services against this SCOM database. One of several I think that are in the normal install.
Almost seems like confusion on SQL Server install vs. SCOM product install.
See if this overview helps.
http://technet.microsoft.com/en-us/library/bb432145.aspx
Then ask more specific questions. I don't do much with SCOM, but could run something by the admin if it's a bit more specific.
I just remember at one time they wanted to 'share' an instance of Reporting Services with us, but his setup seemed very tied in specifically to SCOM and conflicted with the setup we needed.
Greg E
May 28, 2010 at 1:56 pm
david.ostrander (5/27/2010)
I have been reading so much on data warehousing that I feel like I should know this but here I go. How does it get installed?
"Data Warehouse" is a term that defines a database designed to handle large volumes of data and support DSS in a way that makes easier to do reporting - or the way we call it now - to do Business Intelligence and Data Minning - as opposed to support OLTP.
As other posters already answered you do not install data warehouse, you design a data warehouse database and related auxiliary processes like ETL and Archiving.
Hope this helps.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 28, 2010 at 1:57 pm
if you mean the onepoint and systemcenterreporting databases (MOM 2005) and whatever the equivalents are called in SCOM there is no special SQL components you need, just the database engine, SSIS and SSRS if you want to run reports against the 'warehouse' component, which is really more of a reporting (MI) database.
The MOM/SCOM install will create the databases, jobs and packages for you. Configure SSRS just as you would any other SSRS install, nothing special about it.
---------------------------------------------------------------------
May 30, 2010 at 5:44 am
PaulB-TheOneAndOnly (5/28/2010)
david.ostrander (5/27/2010)
I have been reading so much on data warehousing that I feel like I should know this but here I go. How does it get installed?"Data Warehouse" is a term that defines a database designed to handle large volumes of data and support DSS in a way that makes easier to do reporting - or the way we call it now - to do Business Intelligence and Data Minning - as opposed to support OLTP.
As other posters already answered you do not install data warehouse, you design a data warehouse database and related auxiliary processes like ETL and Archiving.
Hope this helps.
You're right, but you have to understand, he's just repeating what the MS documentation says about the long term storage facility within SCOM. It calls it the datawarehouse.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 1, 2010 at 11:50 am
Grant Fritchey (5/30/2010)
... he's just repeating what the MS documentation says about the long term storage facility within SCOM. It calls it the datawarehouse.
You are right - Thank you for pointing that out.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 2, 2010 at 6:25 am
Thank you to everyone for all the responses. I now have a good understanding of what we need to do. :-):-)
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply