Skip to main content

Data Explorer

Data Explorer UI tutorials

Use Data Explorer to manage FairCom databases and explore JSON APIs

Overview

The following sections provide a visual overview of the various tabs available in Data Explorer.

With the FairCom server running, open the browser-based menu (https://localhost:8443/) to access the FairCom graphical user interfaces.

Open Data Explorer and use the API Explorer to access the various JSON APIs.

API Explorer

api_explorer.png

Create table

Create a table and define the columns, one at a time. The pop-up builds the create table statement and then executes it once the user is done building it through the UI. This pop-up is accessed by right clicking on the left sidebar Tables node and selecting Create Table.

create_table.png

Query builder

Visually define a SELECT statement, field-by-field, without having to build a statement from scratch in the SQL query or scripts tab. This also allows for building join queries.

querybuilder.png

SQL queries

Run simple SELECT statements only, showing the results in a text area below.

sqlqueries.png

SQL scripts

Execute more complex, multi-statement scripts, such as creating a table, inserting a record, and selecting them for display all in one operation.

sqlscripts.png

Tables details

View the metadata for a table, which includes the table's field names, data types, and constraints.

tables_details.png

Table records

View the records for a selected table. This functionality also enables the user to select a single record to view and update/insert/delete if desired. This record viewer also allows users to open a binary editor and view the contents of a binary payload.

tables_tablerecords.png

how to use the Data explorer UI to manage databases and explore JSON APIs

how to use data explorerdata explorer uimanage databaseexplore JSON APIsAPI explorercreate tablequery buildersql queriessql scriptstables details