Re: anyone have experience with using Talend ETL tool

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: 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-01 20:17:17
Message-ID: 200804012217.20273.dfontaine@hi-media.com
Views: Raw Message | Whole Thread | 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.

> I was wondering if anyone has used Talend's Open Studio or any other
> ETL tools and wouldn't mind sharing their thoughts.

Or you could use pgloader, which I use in production for this kind of purpose
(except the CSV data do not come from another PG database).
http://pgloader.projects.postgresql.org/

Regards,
--
dim

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2008-04-01 20:25:24 Re: Using tables in other PostGreSQL database
Previous Message Jeff Wigal (Referee Assistant) 2008-04-01 20:15:38 Connection reset by peer / broken pipe