Octopus is a simple Java-based Extraction, Transformation, and Loading (ETL) tool. It may connect to any JDBC data sources and perform transformations defined in an XML file.
DODS data models are supported by generating oid's for new objects. Natural keys can be used to insert/update existing data and create relationships with oid's.
A loadjob-generator is provided to generate Octopus loadjob skeletons (and even DODS DOML files !) from an existing database. Many different types of databases can be mixed (MSSQL, Oracle, DB2, QED, JDBC-ODBC with Excel and Access, MySQL, CSV-files, XML-files,...) Three special JDBC drivers come with Octopus to support JDBC access to CSV-files (CSV-JDBC), MS-SQL (FreeTDS) and XML.
Octopus supports Ant and JUnit to create a database / tables and extract /load data during a build or test process. Loadjobs can be executed during execution of an application installation (e.g. NSIS, Installshield,...)
Octopus support many different database vendors( PostgreSQL, MySQL, MSQL, Oracle, Sybase, ... ).
The new release has many improvements and features including full support for transformations - Java and JavaScript can be used to make transformation rules.
Octopus is an Open-source project under LGPL licence.
Octopus home page: http://octopus.objectweb.org/
-
ETL tool Enhydra Octopus 3.2.2 has been released (3 messages)
- Posted by: Zoran Milakovic
- Posted on: February 18 2005 08:27 EST
Threaded Messages (3)
- ETL tool Enhydra Octopus 3.2.2 has been released by George de la Torre on February 19 2005 16:01 EST
- ETL tool Enhydra Octopus 3.2.2 has been released by Mark N on March 08 2005 11:27 EST
- How does it compare to Solonde's product? by Mich Hagdishovich on June 20 2005 17:16 EDT
-
ETL tool Enhydra Octopus 3.2.2 has been released[ Go to top ]
- Posted by: George de la Torre
- Posted on: February 19 2005 16:01 EST
- in response to Zoran Milakovic
Wnat to take a look, but the web site is down. -
ETL tool Enhydra Octopus 3.2.2 has been released[ Go to top ]
- Posted by: Mark N
- Posted on: March 08 2005 11:27 EST
- in response to Zoran Milakovic
Usually speed or rather long running processes is a concern with ETL. How well does octopus work in the regard? -
How does it compare to Solonde's product?[ Go to top ]
- Posted by: Mich Hagdishovich
- Posted on: June 20 2005 17:16 EDT
- in response to Mark N
How does Octopus compare to Solonde's TransformOnDemand?
Any reviews will be helpful.
thanks,
Mich Hagdishovich
Weekly Genetics Newsletter http://www.kromonews.com