Aqua Data Studio

Register New Server

Toolbar menu:

Server -> Register Server

Or right-click on a Server Group.

In the Register Server window (or Edit Server window):

• Select the type of server

• Give the connection a name

• Enter credentials

• Enter host, port, database name

Click “Test Connection” to confirm the connection works.

Save

Sample queries

Sumarize all loans from each location by patron group:

select li.location_name, g.groupname, count(*)

from loans_item li

join loans l on li.loan_id = l.id

join users u on l.user_id = u.id

join groups g on u.patron_group_id = g.id

group by li.location_name, g.groupname

order by li.location_name, g.groupname

;

Export Results

Results can be saved to a variety of formats. From menu bar:

File -> Save Results

Then you can save in different data formats such as delimited text, HTML, XML, Excel, etc.:

Note that the results will need to fit into memory. This will not be suitable for a very large result set.

For large results, one might try generating and modifying and AquaScript. This is a JavaScript-like language (extension?) for ADS. I have not investigated, it is possible it has the features for spooling a large result set without accumulating it all in memory.