Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Data Explorer is the single-point of user interactions, which allows you to carry out different operations related to data analytics. Data Explorer allows you to search and view tables in the Data Access Layer (DAL) of WSO2 DAS, and browse their recordsYou can authorize and restrict users on the functions that they carry out using the Data Explorerby setting permissions on the user roles assigned to them as shown below.

Info

For instructions on setting the following permissions, see Adding and Managing Users and Roles.

 setting permissions of the message consoleImage Modified

Data Explorer functionRequired permissions
All functions
  • Analytics->Data Explorer
  • Analytics->Analytics Web Service
  • Analytics->Analytics Remote API
View records of a table
  • Analytics->Table-> List
  • Analytics->Records->Get
Search by date range
  • Analytics->Table-> List
  • Analytics->Records->Get
Search by primary key
  • Analytics->Table-> List
  • Analytics->Records->Get
Search by query
  • Analytics->Table-> List
  • Analytics->Records->Search
Schedule data purging
  • Analytics->Records->Delete

The Data Explorer user functions are explained below.

Table of Contents
maxLevel3

Viewing records of a table

Follow the steps below to view records of existing tables using the message consoleData Explorer.

  1. Log in to the WSO2 DAS Data Explorer using the following URL: https://<DAS_HOST>:<DAS_PORT>carbon/
  2. Click Main, and then click Data Explorer in the Interactive Analytics menu.
  3. Select the Table Name of which you want to view records.
  4. Click Search. You view the all records of the selected table as shown below.
    Image Modified

Searching for records of a table

...

Follow the steps below to search for records of an existing table based on a particular date range.

  1. Log in to the WSO2 DAS management console using the following URL, if you are not already logged in: : https://<DAS_HOST>:<DAS_PORT>carbon/
  2. Click Main, and then click Data Explorer in the Interactive Analytics menu.
  3. Select the Table Name of which you want to search and view records.
  4. Select By Date Range for Search.
  5. Enter the From and To dates to define the date range within which you want to search the records. 

    Info

    You can specify a time period within which you want to search and view records by selecting the start and end times in hours and minutes in 24 hours time standard.

  6. Click Search. You view the filtered records of the selected table as shown below.
    Image Modified

Searching by a primary key

Follow the steps below to search for records of an existing table using primary keys.

  1. Log in to the WSO2 DAS management console using the following URL, if you are not already logged in: : https://<DAS_HOST>:<DAS_PORT>carbon/
  2. Click Main, and then click Data Explorer in the Interactive Analytics menu.
  3. Select the Table Name of which you want to search and view records.
  4. Select By Primary Key for Search.
  5. Enter the values of the primary keys defined when you persisted the event stream, of which you want to search the records. 
  6. Click Search. You view the filtered records of the selected table as shown below. 

Searching by a query  

Follow the steps below to search for records of an existing table using an Apache Lucene query.

  1. Log in to the WSO2 DAS management console using the following URL, if you are not already logged in: : https://<DAS_HOST>:<DAS_PORT>carbon/
  2. Click Main, and then click Data Explorer in the Interactive Analytics menu.
  3. Select the Table Name of which you want to search and view records.
  4. Select By Query for Search.
  5. Enter the Apache Lucene query which defines the search criteria based on which you want to search the records for Search Query
  6. Click Search. You view the filtered records of the selected table as shown below. 

Searching by facets

Follow the steps below to search for records of an existing table using facets.

Info

For more information on facets, see Searching Data By Categories.

  1. Log in to the WSO2 DAS management console using the following URL, if you are not already logged in: : https://<DAS_HOST>:<DAS_PORT>carbon/
  2. Click Main, and then click Data Explorer in the Interactive Analytics menu.
  3. Select the Table Name of which you want to search and view records.
  4. Select By Query for Search.
  5. Select the values of the facets defined when you persisted the event stream, of which you want to search the records for Search

  6. Click Search. You view the filtered records of the selected table as shown below. 
Info
You can also perform searches with facets using combined Lucene queries in the message consoleData Explorer.

Scheduling data purging

You can schedule data purging tasks using the Data Explorer. For instructions on how to schedule data purging, see Purging Data.