The gadget generation tool is a step by step wizard that allows you to generate gadgets for your dashboard in a few simple steps. These steps are:
To explain these steps, let's create a sample gadget out of some summarized data off the KPI Definition sample.
You need to have run the KPI Definition sample to get the sample data used in this page.
Enter the necessary details, for your datasource. If you are using any other datasource other than H2 (mysql, oracle, mssql, etc.), the relevant driver needs to be placed in $BAM_HOME/repository/components/lib and the server should be restarted.
The details entered here are:
To check whether the details are correct, you can click on "Validate Connection". If the connection is successful you will get a success message and a failure message if the connection cannot be made. Now, click "Next".
In this step, you need to enter the SQL that will fetch the required data for your gadget. You can click the "Preview SQL Results" button, to preview the results returned by the SQL Query.
Here the SQL statement used is : select * from brandSummary. The image below shows the results returned from this query. Now, click "Next".
This step allows you to pick the UI element for visualizing your data. Bar graphs and Tables are supported for this release. All options you pick are instantly reflected in the preview area.
The bar graph gives you some configuration options to customize the view of the generated gadget. These are:
The table give you a configuration option:
Let's create a bar graph with options shown in the bar graph image for this sample. Click "Next".
We are at the final stage of the gadget generation. We need to enter the following details:
A refresh rate, specially a high one (A smaller number of seconds) can slow down performance, when a large number of gadgets are present in the dashboard.
Now, click "Generate!".
Now, the gadget has been generated. Copy the location of the gadget displayed in the screen.
Next, click "View Portal" from the left hand side menu.
Click on add gadget on the left hand side of the portal page.
Expand the "Enter Gadget Location" section on the right hand side and paste the gadget location. Then, click on "Add Gadget".
Now, the gadget will be shown in the dashboard as shown in the screen below.