Data Warehousing Community Forum

Data Warehousing => Data Warehousing Concepts => Topic started by: werder85 on April 01, 2010, 07:23:33 pm



Title: Basic question about DW
Post by: werder85 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!


Title: Re: Basic question about DW
Post by: Whoever 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 (http://en.wikipedia.org/wiki/Microsoft_SQL_Server), OLAP (http://en.wikipedia.org/wiki/SQL_Server_Analysis_Services), ETL (http://en.wikipedia.org/wiki/SQL_Server_Integration_Services) and Reporting (http://en.wikipedia.org/wiki/SQL_Server_Reporting_Services).
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. ;)


Title: Re: Basic question about DW
Post by: herbert11 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.