Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL?

http://lmgtfy.com/?q=postgres+ETL+tools

On Mon, Oct 7, 2013 at 11:02 AM, sunpeng <bluevaley@gmail.com> wrote:

Talend?
http://talend.com/
But usually all major ETL tools do work with any database including PostgreSQL

On Monday 07 October 2013 17:54:36 Vick Khera wrote:

http://lmgtfy.com/?q=postgres+ETL+tools

On Mon, Oct 7, 2013 at 11:02 AM, sunpeng <bluevaley@gmail.com> wrote:

Hi, Friends, are there any ETL tools (free or commercial) available for
PostgreSQL?
Thanks!
peng

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Talend?
http://talend.com/
But usually all major ETL tools do work with any database including PostgreSQL

On Monday 07 October 2013 17:54:36 Vick Khera wrote:

http://lmgtfy.com/?q=postgres+ETL+tools

On Mon, Oct 7, 2013 at 11:02 AM, sunpeng <bluevaley@gmail.com> wrote:

Hi, Friends, are there any ETL tools (free or commercial) available for
PostgreSQL?
Thanks!
peng

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

http://kettle.pentaho.com/ works pretty good to.

On Mon, Oct 7, 2013 at 11:39 AM, Michal TOMA <info@webmining-systems.com>wrote:

On Mon, Oct 7, 2013 at 8:32 PM, sunpeng <bluevaley@gmail.com> wrote:

Hi, Friends, are there any ETL tools (free or commercial) available for
PostgreSQL?

*ETL Tools for PostgreSQL::*

Definition: An ETL process data to load into the database from a flat file

A. Extract
B. Transform
C. Load

1. PGLoader - Load .csv file
2. Benetl 1.8 - Load .txt or .csv or .xls file
3. Talend Open Studio => http://www.talend.com/index.php
4. Pentaho Kettle => http://kettle.pentaho.com/
5. Visual Importer => Data can be imported from flat files,Excel.MS
Access,Oracle.Mysql.Interbase,PostgreSQL,oleDB,ODBC and DBF files.
6. CloverETL => http://en.wikipedia.org/wiki/CloverETL

Both [3 &4] of these ETL solutions have a lot of the same types of features:

- Both are Java based and run on Linux and Windows (Talend is
Eclipse-based)
- Visual designers for creating the transformations
- Connectivity for a myriad of databases, including all the big DBs,
text formats, etc.
- Supports distributing jobs across multiple servers if you are doing
serious lifting
- Excellent error handling and error notification systems
- Active and helpful forums (Kettle is older and seems to have a larger
community however)
- Free and open source
- They are complex enough to handle a lot of tasks, but not so much as
to kill you
- There are versions of both (GeoKettle and Spatial Data Integrator)
that are tailored for GIS

Thanks & Regards
Raghu Ram

On 09/10/2013, at 8:39 PM, raghu ram <raghuchennuru@gmail.com> wrote:

On Mon, Oct 7, 2013 at 8:32 PM, sunpeng <bluevaley@gmail.com> wrote:
Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL?

ETL Tools for PostgreSQL::

Definition: An ETL process data to load into the database from a flat file

A. Extract
B. Transform
C. Load

1. PGLoader - Load .csv file
2. Benetl 1.8 - Load .txt or .csv or .xls file
3. Talend Open Studio => http://www.talend.com/index.php
4. Pentaho Kettle => http://kettle.pentaho.com/
5. Visual Importer => Data can be imported from flat files,Excel.MS Access,Oracle.Mysql.Interbase,PostgreSQL,oleDB,ODBC and DBF files.
6. CloverETL => http://en.wikipedia.org/wiki/CloverETL

Both [3 &4] of these ETL solutions have a lot of the same types of features:

Both are Java based and run on Linux and Windows (Talend is Eclipse-based)
Visual designers for creating the transformations
Connectivity for a myriad of databases, including all the big DBs, text formats, etc.
Supports distributing jobs across multiple servers if you are doing serious lifting
Excellent error handling and error notification systems
Active and helpful forums (Kettle is older and seems to have a larger community however)
Free and open source
They are complex enough to handle a lot of tasks, but not so much as to kill you
There are versions of both (GeoKettle and Spatial Data Integrator) that are tailored for GIS

Not exactly an ETL tool, but I've recently felt a sense of liberation since switching to make/python/psql/wget... for my ETL needs. Make is probably the cornerstone as it handles dependencies (think foreign key ordering with schema introspection) and parallel loading in a very intuitive way.

Cheers,

Tony

On 09/10/2013, at 11:03 PM, Tony Theodore <tony.theodore@gmail.com> wrote:

On 09/10/2013, at 8:39 PM, raghu ram <raghuchennuru@gmail.com> wrote:

ETL Tools for PostgreSQL::

Definition: An ETL process data to load into the database from a flat file

A. Extract
B. Transform
C. Load

Not exactly an ETL tool, but I've recently felt a sense of liberation since switching to make/python/psql/wget... for my ETL needs. Make is probably the cornerstone as it handles dependencies (think foreign key ordering with schema introspection) and parallel loading in a very intuitive way.

Forgot to mention that I do something more like ELT. Postgres itself is the best Transform tool.

Cheers,

Tony