Windows version

The SQL Data Browser program, DASQLBrowser.exe, can be found in

C:\Program Files\RemObjects Software\Data Abstract (Common)\Bin

When you run DASQLBrowser you will be presented with a Server Connection dialog asking for a username and password.

If you click the OK button it will attempt to connection to a custom Data Abstract server instance running on the local machine. If you wish to change where you are attempting to connect to, or need to change the channel type and so on, then press the "Show advanced >>>" button.

The dialog is actually pre-configured for an instance of a custom Data Abstract server running on the local machine,

If you need to connect to a Relativity Server instance check the Relativity Server checkbox and you can then specify the Domain and Schema that you wish to connect to. When the Server details above are correct then the Domain Name and Schema Name drop boxes will list the available Domains and Schemas.

Fill in the details you need and then press OK.

You may be shown an empty main window. If that is the case then select the drop down box beside Data Service on the toolbar and choose the Service/Schema you are interested in, then go to the Query menu and click on Reload Schema (or use Shift+F5) and the Schema tables will appear on the left source list.

The SQL Browser window is broken up into 4 areas.

  • Left Side - This is the Source List which displays all the tables in the Schema/Data Service. If you expand a Table (click + sign) it shows the field names, their type and size.
  • The top right - Is a SQL Editor for entering SQL queries. It is automatically populated with an SQL query string when you double click on a table name.
  • The bottom right - Is a Results View, which displays the results of the executed SQL query.
  • Toolbar - Which has buttons to:
    • Connect/reconnect to the Server
    • Reload the Schema
    • Load a Query - loads a .daQuery file, which is a text file with an SQL query, from disk.
    • Save Query - saves the current SQL query to a file on disk with a name you supply.
    • Undo/Redo - The undo / redo buttons affect the SQL Editor.
    • Execute Query - executes the current SQL query.

To execute the SQL query, click on the green button on the Toolbar or click on Query->Execute or press the F5 key. If the SQL is correct the Results View will display the results. If the SQL is malformed you will get a "Query execution failed" error dialog.

The SQL Editor has a popup menu with the names of the tables and fields in the current schema. Note that you can only build SELECT statements, you will not be able to run UPDATE requests.