This system allows you to extract data from multiple databases from multiple database types and either insert the new subset of data into another database or export it as an Excel or CSV file. Databases supported are: MS SQL, Access, Oracle, any ODBC connection, MySQL, PostgreSQL, Interbase, Firebird, Informix, Foxpro, ADO, Sybase, FrontBase, DB2, SAP DB, SQLite, Netezza, LDAP, and ODBTP.
Data manipulation is also possible, where columns can be added, subtracted, sum'ed, averaged, etc. Strings can also be joined, or split.
This module is used for complex data migration especially from multiple database systems.