Solved

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

Posted on 2013-12-05
5
800 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
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:EugeneZ
EugeneZ 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VBScript Write Column Headers 3 38
T-SQL: "HAVING CASE" Clause 1 25
Find results from sql within a time span 11 31
How to use three values with DATEDIFF 3 24
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

772 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