GM - Data Reorganizer

Move, copy, modify, restructure, reorganize information inside and between multiple ODBC databases. Screenshots Release Notes Download Windows x86 32-Bit

Features:

• Fast, stable, optimized native code
• 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 modifying 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.
• Runs on all Windows systems NT | 2000 | XP | Vista | 7 | 8 | 10 | 11 or Windows Server 2000 | 2003 | 2008 | 2012 | 2016 | 2019 | 2022 32-Bit or 64-Bit (No dependencies to other software like .Net, Gdi+, C++ runtimes, java, nodeJS etc.).
• 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. Every relevant programing language has ODBC libraries.
8. When it gets exotic, other DB-Access methods like ADO/MDAC/OLEDB or JDBC use ODBC by themself for the reasons given above.