Overview

The Dynamic Database Explorer is a unique feature of Andi that allows users to quickly begin exploring data and data relationships in a user friendly format, without having to write complicated SQL. The Dynamic Database Explorer can be used immediately after creating a Connection in Andi, however the database must have Referential Integrity to browse associated tables. If your database does not have Referential Integrity, the Database Explorer can be used to setup unique Views, but requires initial administration / setup.

Accessing the Dynamic Database Explorer

The Dynamic Database Explorer is located under the Tools menu in the upper left hand corner:

To begin using the Dynamic Database Explorer, select the desired row(s) from the Query Results, then select the Dynamic Database Explorer:

The Dynamic Database Explorer will appear, with the selected row(s) data:

Dynamic Database Explorer Filter

Andi provides dynamic sorting and filtering to help quickly narrow down to the desired results. The same dynamic Filter that can be applied to Query Results can also be applied within the Dynamic Database Explorer.

Note: To learn more about dynamic filtering of data, check out the Help Center article Filtering Query Results.

Show Related (Explore)

Dynamically exploring data and data relationships is what the Dynamic Database Explorer was created for! To begin exploring data relationships (without writing any SQL), simply select the row(s) of data from the Dynamic Database Explorer, and select Show Related:

Data Relationship Tabs

The Dynamic Database Explorer will now display data associated with the data relationships for the School Table. The tabs lining the bottom can be selected to display various information about the Schools (in this example, this includes Address, Class, Department, and Student Registry information). Each Tab can be selected to display, manipulate, filter, and even export the data if needed:

The below shows a visual of how these table relationships are working to pull data into the Dynamic Database Explorer. The tabs that line the bottom of the Dynamic Database Explorer relate to the table relationships coming to and from the table currently selected (in this example, the SCHOOL table)

Multiple Levels of Data Relationships

The Show Related option can continue to be used to create multiple levels of Data Relationships. As an example, a class has been selected from the ANDI.CLASS Tab, and then the Show Related button has been selected again:

The related data is displayed for this particular Academic Success class, which is the related School information for Glendale University College of Law:

Using the Dynamic Database Explorer users can easily navigate complex data relationships without ever writing a SQL statement!