From: | raghu ram <raghuchennuru(at)gmail(dot)com> |
---|---|
To: | sunpeng <bluevaley(at)gmail(dot)com> |
Cc: | PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL? |
Date: | 2013-10-09 09:39:31 |
Message-ID: | CALnrrJRnV482yYo+Y5X=wKOwsagvbqHrrNzmO05KrwcA+HuPEw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Oct 7, 2013 at 8:32 PM, sunpeng <bluevaley(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2013-10-09 10:05:33 | Re: Many, many materialised views - Performance? |
Previous Message | Albe Laurenz | 2013-10-09 09:32:18 | Re: Can checkpoint creation be parallel? |