From Data Manager

Current status (2009.03.08): progress is again slow due to lack of time for this project, but there has been much progress since this article was written.

The DataManager project is still under development and the project's primary goal is to become an easy-to-use ETL tool mainly targeted at small and medium sized businesses. DataManager is currently a spare-time project with only one developer, thus the goals may change and a time frame is not available at this moment.

ETL 

Extract, Transform, Load. The process of migrating or loading data into a database/data warehouse, including the necessary transformations from the source system(s).

Contents 1 Current goals 1.1 Editions 1.2 Interface 1.3 Transformation methods 1.4 Data types support 1.5 Features

Current goals

Editions

• DataManager Light Edition: select source and target, map data, setup transformations and execute!
• DataManager Standard Edition: In addition to the Light Edition interface, the Standard Edition also includes a powerful ETL editor based on actions/tasks, for your more complex ETL projects.

Interface

Must be easy to use for novices and ETL professionals alike, with a combination of "point and click" and powerful scripting capabilities.

Transformation methods

• SQL
• PHP
• Command line
• Lookup tables

Data types support

• XML, flat files (Fixed width, CSV, etc.) and other major file/directory types
• Native support for all major databases + ODBC
• Messaging
• HTML tables
• Potentially anything that holds tabular data

Features

• Collaboration
• Logging
• Triggers
• Compatible with common job schedulers (Cron, Windows Task Scheduler, etc.)
• Archiving/unpacking (zip, tar.gz, etc.)
• Email Notifications
• Pre-built projects for many common applications and solutions, such as e-commerce, accounting, CMS or ERP software