Solved

How to Create Data warehouse Test Environment using Oracle, IBM DataStage & IBM Cognos OR Microsoft BI Stack

Posted on 2013-12-05
5
809 Views
Last Modified: 2014-04-03
Hi Guru
 
For some of you it might be a silly questions but I'd like to create, test & Reporting data warehouse environment(Database, ETL, Reporting) for learning purpose on my laptop, laptop is enough memory (8gb) to handle basic the Oracle Virtual machine environment, I've build Oracle 11g2 VM machine with IBM Cognos 8.4.1 on WinXP. Now I would like to know from here where I can start. OR Should I follow the Microsoft BI Stack? I just want to get my hands dirty with practically learn technologies in data warehousing, ETLs and Reporting.
 

I've skills in Oracle 10g2, 11g2, IBM Cognos (Report Studio, Framework manager, Transformer). Please advise/share your experience for my learning curve. It would be greatly appreciated.

Regards,
0
Comment
Question by:adnankh
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 12

Accepted Solution

by:
RWrigley earned 250 total points
ID: 39701726
Cognos is only a reporting software; building a data warehouse is something that needs to be done properly independently of the reporting solution.  You want to read up on Inmon and Kimball style data warehouses; both are suitable for use in Cognos, but Inmon requires more work to model (since you need to convert the 3rd normal form of the Inmon design to a star-schema within FM).  

Don't use transformer unless you have a specific need; that technology is going away, and isn't optimal for the newer Cognos 10 systems.  A properly implemented database/DMR in Cognos 8 can be migrated to the better performing Cognos 10 DQM easily if it's designed well, and if you need an OLAP solution, you can use the new Dynamic Cube to implement a ROLAP.  But first, make sure you understand the general differences and advantages/disadvantages between an OLAP solution vs. a Relational solution; one is not better then the other, they have to be used for the right reasons.

The Cognos Samples provide a good basic core for understanding how data can be put together and used, and it comes with Oracle backup files that can be imported.
0
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 39701787
Hi,
with your set of skills I would not go the route with MS SQL BI stack unless you have a specific requirement for it.

First of all if you really want to do fully MS BI you would need at least 32GB of RAM for hosting SQL and SharePoint (which is the reporting frontend). Second setting up MS BI stack requires a lot of knowledge in various MS products, SQL Server, Active Directory, SharePoint - so it would not be that easy learning curve.

I have built a couple of BI solutions and huge data warehouses but I have nearly no knowledge about Cognos and Datastage only some on Oracle (for importing data into SQL server using SSIS :-) - so I am a pure MS BI guy.

Just my 2ct.

HTH
Rainer
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 39703927
For a successful deployment of a data warehouse, you may need to read some of these:

Data warehouse

Best Practices for a Data Warehouse on Oracle Database 11g

Oracle® Warehouse Builder User's Guide
0
 

Author Comment

by:adnankh
ID: 39704135
Thank you RWrigley I really appreciate your advise,  RainerJ Thank you so much to give an idea about BI, I've little BAU experience SQL Server 2005 so hopefully it will help me in future.  MikeOM_DBA Thank a lot for these information.
0
 
LVL 42

Assisted Solution

by:Eugene Z
Eugene Z earned 250 total points
ID: 39704668
I think you have all what you need
just need to set some Schema -data
set connection for\ from Cognos and learn

for BI / Data warehouse -  can be used OLTP/OLAP/SSAS (sql server)

also you may read

Setting Up Your Data Warehouse System
from /Oracle® Database 2 Day + Data Warehousing Guide
 11g Release 2 (11.2)/
http://docs.oracle.com/cd/E11882_01/server.112/e25555/tdpdw_system.htm

and all book


Oracle® Database 2 Day + Data Warehousing Guide
 11g Release 2 (11.2)/
http://docs.oracle.com/cd/E11882_01/server.112/e25554/toc.htm
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question