Thread: anyone have experience with using Talend ETL tool
Hi, I am looking around for an ETL tool to transfer data from one Postgres database to another periodically. I was wondering if anyone has used Talend's Open Studio or any other ETL tools and wouldn't mind sharing their thoughts. Thanks, Irina
Irina Connelly wrote: > Hi, > > I am looking around for an ETL tool to transfer data from one Postgres > database to another periodically. > I was wondering if anyone has used Talend's Open Studio or any other > ETL tools and wouldn't mind sharing their thoughts. > > Thanks, > Irina > I've been using Kettle (or Pentaho Data Integration, as they're calling it now) for a while now, and it has worked very well for me. The links: - Docs and info: http://www.pentaho.com/products/data_integration/ - Files: http://sf.net/project/showfiles.php?group_id=140317&package_id=186321
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
Attachment
> 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 handleType 1 and Type 2 dimensions, connect to disparate data sources, build fact tables, etc. Jon
Today, Talend can do a lot and can perform the data transfer you are talking about. Talend Open Studio is an open source ETL tool for data integration and migration experts. It's easy to learn for a non-technical user. What distinguishes Talend, when it comes to business users, is the tMap component. It allows the user to get a graphical and functional view of integration processes. For more information: http://www.talend.com/ Dimitri Fontaine-3 wrote: > > 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 > > > -- View this message in context: http://www.nabble.com/anyone-have-experience-with-using-Talend-ETL-tool-tp16433426p25530327.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.