GM - Data Reorganizer

Move, copy, modify, restructure, reorganize information inside and between multiple ODBC databases. [Screenshots] [Release Notes]

Features:

• Unlimited number of ODBC connections to work on.
• Each ODBC connection can be used as a source, a destination or both.
• Schema tree view of connected databases.
• Cut, copy, paste and drag and drop supported inside the reorganization definition tree.
• Subtrees of the reorganization definition can be disabled by one click.
• Connection schemata can be stored into reorganization definition to be able to continue working on a reorganization definition when the DB-connections are temporarily not available.
• Multiple data modifiyng functions can be applied before assigning the value to the destination field.
• plug-in concept for value modifying functions.
• New data may be inserted or existing data may be found by flexible kriteria and updated.
• Complete Desktop remembered at application start.
• Comprehensive problem reports.
• Operation order sort by table foreign key dependencies possible.
• Direct data editing supported.
• Two reorganization definition file formats implemented.
1. A binary format operating very fast and allowing very large reorganization definition files.
2. A slower textual format with a size limitation of about 4 MB. But this can be edited with any text editor for manual modifications.
• Binary application runs on naked installations of windows 98/ME/NT/2000/XP/Vista/Win7/Win8 32 or 64 Bit. No DAO, ADO, .Net, Gdi+ or other additional libraries needed.
• Example included importing flat geonames text data into a normalized world database.
• Complete source code included.
• Source code compiles with all Delphi versions (Delphi 5.0 or higher).
• Note: To enable ODBC 64-Bit Integer support compile the source code with Delphi-6.0 or higher (The binary application in the setup has been compiled with Delphi-6.0 and therefore supports ODBC 64-Bit integers).
• No third party units or components are needed to compile the source code.
• Only Delphi Standard/Personal edition required to compile the source code.

Why using ODBC for DB-Access with the Data Reorganizer?

1. ODBC is a wide spread standard.
2. There is no relevant DB-System without an ODBC Driver.
3. ODBC does not require additional installations except for the driver.
4. A naked Windows installation already has ODBC drivers for MS-Access, MS-Excel, DBase, Paradox and Text-Files installed.
5. ODBC is right on top of the driver without additional Layers between them.
6. There are ODBC drivers for almost all kinds of data files too e.g. *.csv *.xml *.json files.
7. When it gets exotic, other DB-Access methods like ADO/MDAC or JDBC use ODBC by themself for the reasons given above.