"Information is data in action", and, consequently, having good quality data is essential. The AESTEL package contains two highly configurable applications for data management: A dataloader and a reporting application, i.e. DataLoader and AEREA, respectively. The dataloader application applies user-defined instructions to validate, process and load data.
pg_bulkload is a high speed data loading utility for PostgreSQL.
pg_bulkload is designed to load huge amount of data to a database.
You can load data to table bypassing PostgreSQL shared buffers.
pg_bulkload also has some ETL features; input data validation and data transformation.
----------
pg_bulkload was located in pgfoundry, but has been moved to here temporally.
************************************
2015.07.03 Now, we are moving to GitHub....
FasterZip PostgreSQL Loader - ETL for postgresql FasterZip PostgreSQL
FasterZip PostgreSQL Loader - ETL for postgresql FasterZip PostgreSQL
This is a Java application that lets you filter the information into a file before loading using a copy (psql does not require). Use a configuration file for the data connection to the db, source file and special parameters. You can make SQL (using HSQL) the source file, allowing the transformation of data prior to loading.
Connect to DB2, Oracle, MS SQL and Mysql database.
Add, edit and remove connections.
Multiple connections simultaneously.
Load/execute SQL.
Export table/data as SQL/CSV/html.
Import data from delimited/fixed length file.
Loader with advanced option