| From: | Tony Theodore <tony(dot)theodore(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 12:09:45 |
| Message-ID: | 55C15F54-88CE-4EFD-A529-1F07565073E2@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 09/10/2013, at 11:03 PM, Tony Theodore <tony(dot)theodore(at)gmail(dot)com> wrote:
> On 09/10/2013, at 8:39 PM, raghu ram <raghuchennuru(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Willy-Bas Loos | 2013-10-09 12:24:59 | no syntax error on limit1 |
| Previous Message | Tony Theodore | 2013-10-09 12:03:47 | Re: Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL? |