Re: Which data warehouse use?

[Jack Kingsley <iseriesflorida@xxxxxxxxx>]

Jim, what are you using to move the data between the I and your MYSQL
Server.

On Fri, Oct 1, 2010 at 4:17 PM, Jim Steil <jim@xxxxxxx> wrote:

>  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
>
> --
> Jim Steil
> VP of Information Technology
> Quality Liquid Feeds, Inc.
> 608.935.2345 office
> 608.341.9896 cell
>  --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.