Like Altova ETL, the software can handle migrations and mappings of databases from practically any source to target. A graphical user interface is provided to assist the process, and it is stated to be easy to use.
It can map flat files, XML, CSV, databases, EDI and numerous other file formats. Additional tools are provided such as date and string formatting, alongside numerical conversions. It is stated that the software is flexible as to the types of data it can map from source to target.
The software works by using a web-based interface called "Design Studio," which has wizard functionality included to make the process easier. The actual validation, mapping process and any editing can all be automated using relevant scripts.
The ability to view mappings via the "preview" capability means that both source and target data can be viewed in real time as rules are changed on the fly. All the rules and source data file information is held in a central storage area, which includes all the rules and objects required for the designated mapping process.
The automated or manual process is handled by the “Run-Time Execution Engine," which takes as its input any incoming data files and rules to work by. For enterprises, the software complies with regulations by providing an audit report of activities. The software is commonly used in Service-Oriented Architecture (SOA) environments. One very useful feature is that the software can handle multiple sources of data at the same time to be mapped to a common target database.
The ETL suite is available at http://www.adeptia.com/products/data_transformation.html