24 August 2007

Oracle database development and testing tool. GPL

GTKO 2.16
Its features include a schema browser, multiple SQL work areas, SQL syntax highlighting, bind variable entry widgets in the command window, and SQL*Plus-style command scripting. For SQL statement analysis and tuning there is a tree-style SQL statement "explain plan" facility and the ability to load SQL statements from the runtime cursor cache (V$SQL table), Oracle Statspack repository, the Oracle Automatic Workload Repository in Oracle version 10g, and full AWR reports.

Collection of scripts to ease the daily maintenance work of Oracle database administrators. GPL

DBAHelper 0.2.0
Examples are moving objects between tablespaces, analyzing schemata, and rebuilding invalid indices. Also included is a little framework to simplify the use of RMAN (this framework depends on the use of Oracle 10g with the Recovery Area enabled and properly sized, so all backups go there).

21 August 2007

ETL (Extract, Transform, and Load) tool. GPL

Talend Open Studio 2.2.0M1 can perform jobs that range from datawarehouse feeding to database synchronization, as well as file format transformations. Its graphical interface is made with Eclipse RCP, and data related scripts are generated in Perl. The application was designed to be extended with components written by users.