| From: | "Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com> |
|---|---|
| To: | "Dimitri Fontaine" <dfontaine(at)hi-media(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Cc: | "Irina Connelly" <irina(dot)connelly(at)gmail(dot)com> |
| Subject: | Re: anyone have experience with using Talend ETL tool |
| Date: | 2008-04-02 14:38:12 |
| Message-ID: | 1A6E6D554222284AB25ABE3229A92762E9A095@nrtexcus702.int.asurion.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> Hi,
>
> Le Tuesday 01 April 2008 22:00:11 Irina Connelly, vous avez écrit :
> > I am looking around for an ETL tool to transfer data from one Postgres
> > database to another periodically.
>
> You could simply rely on COPY for this, as data coming out of PG could be
> trusted to be able to get in the other database without much hassle.
>
COPY does a great job on the LOAD part of ETL but it doesn't do anything for EXTRACT or TRANSFORM. An ETL should handle Type 1 and Type 2 dimensions, connect to disparate data sources, build fact tables, etc.
Jon
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mark | 2008-04-02 14:42:06 | Re: simple update queries take a long time - postgres 8.3.1 |
| Previous Message | Roberts, Jon | 2008-04-02 14:33:56 | Re: dblink ,dblink_exec not participating in a Transaction?? |