Using the Database Explorer in Aginity Team

The Database Explorer panel in Aginity Team can be toggled by using the Database Explorer and Catalog tabs on the left hand pane of the application as show below. The Database Explorer is used to navigate database objects based on the Connections defined in Aginity Team. The Catalog browser is used to navigate SQL Analytics that you have personally stored.

Below is a quick start video of using the Database Explorer in Aginity Team


Viewing the Database Data Dictionary

Once you have established a connection to a database you can browse the database dictionary catalogs. You can toggle to the Database Explorer browser by clicking on the tab as shown below. The database data dictionaries typically contains the tables, columns, views and other database objects available to query from the query panel.

Browse the Database Catalog

Once you have selected the Database Explorer tab you can drill into each connection as shown below.

Browse the Database Catalog

Database Object Support by Platform

The following image details what objects are visible from the browser for all of our currently supported platforms. We do releases every two weeks with Aginity Team so if there is a feature you need please contact us at support@aginity.com.

Browse the Database Catalog

Quick Actions from Explorer

Currently you can do the following quick actions from the Database Explorer

SQL Statement Generation

To generate typical SQL statements from tables or views you can right click on the object, navigate to scripts and choose the appropriate script as shown below.

Browse the Database Catalog

Selective SQL Generation on a Set of Columns

To generate SQL statements based on a selection of columns within a Table or View, multi-select the columns by holding Ctrl (Windows) or Command (Mac) and selecting the columns as shown below. Then generate the SQL statement.

Browse the Database Catalog

Hint

Make sure you don’t have the table name selected and column names at the same time. If you do it will generate the SQL for the whole table.

Drag and Drop Capabilities

You can drag and drop any object from the DB Explorer into the Query Panel

Note

Double-clicking expands the DB Explorer tree

Copy JDBC Connection String

If you select any Connection (Top level of the tree) and select “Copy Connection string to Clipboard” you will get the full JDBC URI which is helpful for debugging. See this Knowledge Base Article for help with debugging your Aginity Team connections.

Browse the Database Catalog