DataGrabber
Introduction
DataGrabber is a simple yet powerful query tool for Windows that supports many SQL databases.
Connection topology:
- FireDAC
External dependencies and references:
- Spring4D
- DSharp
- DDuce
- Virtual treeview
- TzObjectInspector
- JsonDataObjects
- Chinook database
- SQLite
- SynEdit
- TChromeTabs
- KControls
Commercial components (optional):
- DevExpress cxGrid
Main form
Grouping of columns
Merging of columns
Data export
+----------+--------+---------+-------------------+---------+----------+----------+---------------------------+
|EmployeeId|LastName|FirstName|Title |ReportsTo|BirthDate |HireDate |Address |
+----------+--------+---------+-------------------+---------+----------+----------+---------------------------+
|1 |Adams |Andrew |General Manager | |18/02/1962|14/08/2002|11120 Jasper Ave NW |
|2 |Edwards |Nancy |Sales Manager |1 |8/12/1958 |1/05/2002 |825 8 Ave SW |
|3 |Peacock |Jane |Sales Support Agent|2 |29/08/1973|1/04/2002 |1111 6 Ave SW |
|4 |Park |Margaret |Sales Support Agent|2 |19/09/1947|3/05/2003 |683 10 Street SW |
|5 |Johnson |Steve |Sales Support Agent|2 |3/03/1965 |17/10/2003|7727B 41 Ave |
|6 |Mitchell|Michael |IT Manager |1 |1/07/1973 |17/10/2003|5827 Bowness Road NW |
|7 |King |Robert |IT Staff |6 |29/05/1970|2/01/2004 |590 Columbia Boulevard West|
|8 |Callahan|Laura |IT Staff |6 |9/01/1968 |4/03/2004 |923 7 ST NW |
+----------+--------+---------+-------------------+---------+----------+----------+---------------------------+
| EmployeeId | LastName | FirstName | Title | ReportsTo | BirthDate | HireDate | Address |
|---|---|---|---|---|---|---|---|
| 1 | Adams | Andrew | General Manager | 18/02/1962 | 14/08/2002 | 11120 Jasper Ave NW | |
| 2 | Edwards | Nancy | Sales Manager | 1 | 8/12/1958 | 1/05/2002 | 825 8 Ave SW |
| 3 | Peacock | Jane | Sales Support Agent | 2 | 29/08/1973 | 1/04/2002 | 1111 6 Ave SW |
| 4 | Park | Margaret | Sales Support Agent | 2 | 19/09/1947 | 3/05/2003 | 683 10 Street SW |
| 5 | Johnson | Steve | Sales Support Agent | 2 | 3/03/1965 | 17/10/2003 | 7727B 41 Ave |
| 6 | Mitchell | Michael | IT Manager | 1 | 1/07/1973 | 17/10/2003 | 5827 Bowness Road NW |
| 7 | King | Robert | IT Staff | 6 | 29/05/1970 | 2/01/2004 | 590 Columbia Boulevard West |
| 8 | Callahan | Laura | IT Staff | 6 | 9/01/1968 | 4/03/2004 | 923 7 ST NW |
Multiple resultsets
DataGrabber supports multi-resultset outputs, which can be displayed horizontally, vertically or as seperate tabs.
Settings
Connection settings for multiple databases are configured in connection profiles.
Settings are stored in JSON format, and can also be changed by editing the file directly.
Field inspector
