Re: custom data warehouse in python vs. out-of-the-box ETL tool

2009-09-23 Thread snfctech
@Lemburg: Thanks for the suggestion. I'm sure you make a fine product, but my development platform is Linux, and I don't want any additional Windows servers to deal with (than the ones I'm already stuck with.) On Sep 23, 2:02 am, "M.-A. Lemburg" wrote: > snfctech

Re: custom data warehouse in python vs. out-of-the-box ETL tool

2009-09-23 Thread snfctech
- and then there's the whole thing about data marts vs. warehouses, Kimball vs. Inmon, star schemas, EAV tables, and so on. So I started to think that maybe I needed to get a little better read on the subject. On Sep 23, 3:15 am, "Martin P. Hellwig" wrote: > snfctech wrote: >

Re: custom data warehouse in python vs. out-of-the-box ETL tool

2009-09-22 Thread snfctech
python? Bill Inmon's "Building the Data Warehouse" is 17 years old, and I've been cautioned against Kimball. Thanks. On Sep 22, 3:40 pm, "Martin P. Hellwig" wrote: > snfctech wrote: > > Does anyone have experience building a data warehouse in python?  Any &g

custom data warehouse in python vs. out-of-the-box ETL tool

2009-09-22 Thread snfctech
Does anyone have experience building a data warehouse in python? Any thoughts on custom vs using an out-of-the-box product like Talend or Informatica? I have an integrated system Dashboard project that I was going to build using cross-vendor joins on existing DBs, but I keep hearing that a data w