I've also used Pentaho Data Integration (previously known as Kettle)
quite extensively, and can recommend it. It supports many different
databases and has fairly good documentation (although thin in some
areas). It has a GUI drag-and-drop tool that can be used to configure
transformations and is
Besides being easy to schedule and very flexible, manipulating data
with queries is extremely powerful and fairly easy to maintain
assuming you know a little SQL -- thanks to postgresql's huge array of
built in string manipulation functions. Your skills learned here will
pay off using the databas
On 1/26/07, Tomi N/A <[EMAIL PROTECTED]> wrote:
2007/1/23, Paul Lambert <[EMAIL PROTECTED]>:
> Is there an equivalent in Postgres to the DTS Packages available in M$
> SQL server.
what you're looking for exists in a number of variations.
You can use a good text editor with the postgres' COPY c
2007/1/23, Paul Lambert <[EMAIL PROTECTED]>:
G'day,
Is there an equivalent in Postgres to the DTS Packages available in M$
SQL server.
I use these in SQL server to pre-load data from CSV files prior to
enabling replication from my primary application. Any pointers on where
best to go for this
Sorry, posted this to the wrong list :(
Original Message
Subject:
[PORTS] M$ SQL server DTS package equivalent in Postgres
Date:
Tue, 23 Jan 2007 10:15:06 +0900
From:
Paul Lambert <[EMAIL PROTECTED]>
