This page provides an overview of data binding in AppDynamics.
The Data panel enables users to query and display data for a selected widget, along with the following:
Construct queries that span their environment.
Query using attributes and relationships that are important to them.
Quickly get to the data they need even if they don’t know the metric path.
Construct more sophisticated queries.
Query both metric and analytics data in the same query.
The Data panel is structured around queries. Each query follows a sentence-like format, starting with a selection of the data type of the query. Many fields in the Data panel support typeahead functionality.
Consider an example where a user wants to know errors per minute for the nodes in the ECommerce application:
- Choose a value from the Show me data for drop-down menu based on the data type you wish to display.
In this scenario we have selected Applications.
- The subsequent inputs shown in the Data panel are specific to the data type selected in the previous step. In this case, it is the Application drop-down menu which lets you select the application for which you want to drill down the data.
- In this case, the next drop-down menu is Metric; this changes depending on the data type. For instance, Node will have two more inputs before selecting the metric.
- Select the metric you wish to display on the widget. The more icon available on the right-corner of the Data Panel allows you to set the limit and baseline.
Once you have specified valid inputs for all fields in the query, the widget will be updated on the canvas to show the query's results.
ADQL (AppDynamics Data Query Language) Query is a metrics query available in the Data panel for dashboards created in Dash Studio. This query allows you to filter and create customized metrics for Analytics data.
ADQL Query data binding uses Analytics queries written in ADQL. After selecting the ADQL Query option from Show me data for dropdown, you can either type or paste in an ADQL query. See ADQL Reference for the syntax of these query statements.
You must enter a valid ADQL Query for series in order to see data reflected in the Time Series widget in Dash Studio. The ADQL query statement must include the 'series' expression, or else it does not display a series. ADQL Query is currently only available for the Time Series widget.
After you type or paste the query in the input field, moving the cursor away from the input field automatically validates the query. For a Valid ADQL Query, displayed in green as shown below, the data is displayed in the widget on the canvas. In case of an invalid query, an error message is displayed in red.
Variables in ADQL Queries
Variables in ADQL queries enable you to dynamically change the values passed into the queries.
Consider an example where a user wants to use a variable for an application within an ADQL query:
- Click + Add Variable under the Dashboard Variables panel.
- Enter a value in the Variable Name field and select the variable type in the Type drop-down menu.
- Select an application in the Application drop-down menu.
The subsequent inputs shown in the Dashboard Variables panel are specific to the data type selected in the previous step. In this case, it is the Initial Values drop-down menu which lets you select the business transaction for which you want to drill down the data.
Select the Show in View Mode checkbox after selecting the Initial Values.Click the widget to change Data Panel from variable data to widget data.
- Choose a value from the Show me data for drop-down menu.
In this case we select ADQL Query. After selecting ADQL Query, enter the query in the ADQL Query field as shown below:
On entering a valid query, the widget appears as displayed in the image below:
- Click View on the top-right of the screen and the subsequent dashboard screen allows you to change the application by clicking the $app drop-down.
Server Metrics, also known as the Server Infrastructure Monitoring (SIM) Metrics is a data binding option available in the Data panel of Dash Studio. This option allows you to filter and create customized metrics for server monitoring.
Follow the steps below to filter and create customized metrics for one or more servers:
- Click Show me data for drop-down menu and select Servers from the drop-down list.
Click Application drop-down menu and select the application for which you want to drill down the data.
- Click Select a Value and choose either of the following options:
All Servers: This option shows data across all applications. If you select this option, then the Application selected in the previous step becomes optional. If you select All Servers, the next input field in the Data panel automatically changes to Metric. Select the metric value you wish to display on the widget from the drop-down list or by manually entering a value in the input field.
If none of the applications are selected, then the widget displays data for only stand alone applications and not for the ones included in the application tree.
- Named: This option lets you specify individual servers known to the specific application that you chose in step 2. If you select Named, the next input field in the Data panel changes to Server. Select one or more servers from the Server drop-down list and the metric value from the Metric drop-down menu.
- Within: This option lets you select the tier or tiers of the server you wish to display in the server chart.
Database Metrics is a data binding option available in the Data panel of the Dash Studio. This option allows you to filter and create customized metrics for database monitoring.
Currently the Metric Number widget does not support Database metrics.
Consider an example where you want to monitor a specific database or multiple databases as follows:
- Click Show me data for drop-down menu and choose Databases from the drop-down list.
- Click Type and select the required database from the drop-down list to display the metrics on the widget.
- Click Select a Value and choose one of the following options:
All Databases: Displays data for all the databases.
- Named: Displays data for a specific database. The required database can be selected from the subsequent input field Database that appears on selecting Named.
Click Metric and choose the metric value. You can also enter a value in the input field manually.
The database metric chart appears as follows:
JMX (Java Management Extensions) is a data binding option available in the Data panel for dashboards created in the Dash Studio. This option allows you to filter the entities by nodes and monitor the JMX metrics for the given set of nodes.
Consider an example where you want to monitor JMX metrics of a node or multiple nodes:
- Click Show me data for drop-down menu and select JMX from the drop-down list.
The subsequent inputs shown in the Data panel are specific to the data type selected in this step.
- Click Application drop-down menu and select the application for which you want to drill down the data.
- Click Select a Value and select a node filter from the drop-down list.
- Select a JMX metric. You can either manually enter the name of the metric in the field or select from the drop-down list.
This list is dynamic.
- Entries are not displayed if the selected entry is not a Java application or if no JMX metrics are currently available on the selected application.
The metric selector parses the Java Application metric tree dynamically for all available JMX metrics and displays them as a flattened list.
Currently only the JMX metrics that are 2 levels deep from a JMX folder in the metric tree are available in the Dash Studio.