Data Warehousing Community Forum
February 09, 2012, 01:25:36 pm

Pages: [1]   Go Down
  Print  
Author Topic: Basic question about DW  (Read 1272 times)
werder85
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 2


View Profile
« on: April 01, 2010, 07:23:33 pm »

'm really new to DW...I know classical databases pretty good (for operational applications).
I've read a bit about the concepts of DW.

I don't really know now, which software package I should use.
What do you suggest as to be the best or easiest solution: mysql, ms sql server, etc.

Please help me out, as I don't want to start this wrong and lose a lot of time for nothing.
Thanks a lot!
Logged
Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« Reply #1 on: April 01, 2010, 09:55:06 pm »

A Data warehouse comprises several components (DB, ETL, OLAP, Reporting), each one of which can be implemented using one of various software tools available.

In fact, this forum itself is broken down into different sections based on the components and software packages.

DB - Oracle, MS SQL server, DB2, Teradata etc.
ETL - Informatica, MS SSIS, Ab Initio, Oracle Warehouse Builder, Data stage etc.
Reporting - Business Objects, Cognos, MS SSRS, Hyperion, Brio etc.

Most vendors specialize in one field - Oracle and MS are probably the only two which provide you with more than one component.
And MS SQL Server is probably the only one which includes all of them in one license - DB, OLAP, ETL and Reporting.
Oracle too, has products for each component of a data warehouse, although I'm not sure of their licensing policy.

That said, if you've got the basics "down", you can find your way around any software package with relative ease.
In my last job, I've worked on Unix/Oracle/Informatica. In my current job I work with MS SQL server. Wink
Logged

If most people said what’s on their minds, they’d be speechless.
herbert11
DW Apprentice
**

Reputation: +4/-0
Offline Offline

Posts: 25


View Profile
« Reply #2 on: September 07, 2011, 01:36:25 pm »

To choose best database software package various things matter. The operating system on your system, the license on which you are working, drivers installed on the system, ODBC, JDBC, ADO.net drivers availability, etc. so you should analyze all of these things before deciding the best option for you.
Logged
Pages: [1]   Go Up
  Print  
 
Jump to: