Re: Which data warehouse use?

I take the opposite approach. In my mind the data warehousing data is all reproducible from my production data. Therefore, I don't need the robustness (and extra cost) the i offers. I take all of my data to MySQL running on commodity hardware with Ubuntu. Low cost and really very fast. Users can hit this database with their reporting tool of choice all they want with no ill effects on the production systems.

As for data warehousing software, we don't do anything fancy. We write programs to generate all necessary standard reports to excel or pdf. Ad hoc is done using MS Access (yuck) by our end users or using SQL and programming as necessary when it gets too complicated for the end users.

Just my $.02

-Jim

On 10/1/2010 2:27 PM, Nathan Andelin wrote:

I think that managing disparate systems is the biggest challenge in IT, and the
biggest waste of time. If it were up to me, I'd migrate MS SQL Server and
PostgreSQL server data and applications to IBM i. And not surprisingly, I'd do
data warehousing under IBM i, too. I can't recommend any separate data
warehouse system. Just create SQL views of IBM i tables, and run queries
against them.

-Nathan



----- Original Message ----
From: Tomasz SkorÅa<t.skorza@xxxxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Sent: Fri, October 1, 2010 11:53:49 AM
Subject: Which data warehouse use?

Hi guys

I have one database on DB2-400, one on MS SQL Server and one on PostrgreSQL.
Which dedicated software for data warehouse you propose to use - best if open
source - and which

database use for warehouse?
Other DB2, MS SQL, Postgre or maybe mySQL?

I will be gracefull for any ideas and prompting

Regards

Tomek