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