Chapter 5. Practical tutorial: Connecting to a data source This exercise is optional and relies on you having an external data source available to use. In the exercise, we are going to connect to an external data source via the Dashboard Builder. We are going to be largely covering the same ground as in the exercise above but we will be going into a little more detail to make you really familiar and comfortable with the technology. You can connect either to a JNDI data source, that is, a data source set up and accessible from the application container, or directly to the data source as a custom data source, if the application container has the correct JDBC driver deployed. Here is how you connect to an external data source: 5.1. Prerequisites Name Description Red Hat JBoss Data Virtualization Red Hat JBoss Data Virtualization must be installed and running. (Please refer back to the Getting Started Guide if you need a refresher on this.) Dashboard Builder Account and Password You must have a valid account and password. (You would have set this up during installation.) A data source You must have a data source to which you can connect. Make sure the data source is up and running and that the application server has access to the data source. (Check the driver, the log-in credentials,and so forth. In Red Hat JBoss EAP 6, you can do so in the Management Console under Subsystems Connector Datasources .) In Dashboard Builder, on the Tree Menu (by default located on the Showcase perspective), go to Administration External connections. On the displayed External Connection panel, click the New DataSource button. Select the data source type ( JNDI or Custom DataSource ) and provide the respective data source parameters. You must now create a new data source: To create a new data provider, do the following: In the Tree Menu (the panel in the lateral menu of the Showcase workspace), click Administration Data providers. In the Data Providers panel, click the Create new data provider button. In the updated Data Providers panel, select the type of the data provider (depending on the source you want the data provider to operate on) from the Type menu. Define the data provider parameters: Data provider over a CSV file Name: user-friendly name and its locale CSV file URL: the url of the file (for example, file:///home/me/example.csv ) Data separator: the symbol used as separator in the CSV file (the default value is semicolon; if using comma as the separator sign, make sure to adapt the number format if applicable) Quoting symbol: the symbol used for quotes (the default value is the double-quotes symbol; note that the symbol may vary depending on the locale) Escaping symbol: the symbol used for escaping the following symbol in order to keep its literal value Date format: date and time format Number format: the format of numbers as resolved to thousands and decimals Data provider over a database (SQL query) Name: user-friendly name and its locale Data source: the data source to query (the default value is local, which allows you to query the Dashboard Builder database) Query: query that returns the required data Click Attempt data load to verify the parameters are correct. Click Save . In the table with the detected data, define the data type and if necessary provide a user-friendly name for the data. Click Save. The data provider can now be visualized in an indicator on a page of your choice. , you must create a workspace again: Click the Create workspace button on the top menu. In the Create workspace table on the right, set the workspace parameters: Name: workspace name and its locale Title: workspace title and its locale Skin: skin to be applied on the workspace resources Envelope: envelope to be applied on the workspace resources Click Create workspace . Optionally, click the workspace name in the tree menu on the left and in the area with workspace properties on the right define additional workspace parameters: URL: the workspace URL User home search: the home page setting If set to Role assigned page, the home page as as in the page permissions is applied; that is, every role can have a different page displayed as its home page. If set to Current page, all users will use the current home page as their home page. To create a new page, do the following: Make sure you are in the correct workspace. to the Page dropdown box in the top menu, click the Create new page button. In the Create new page table on the right, set the page parameters: Name: page name and its locale Parent page: parent page of the new page Skin: skin to be applied on the page Envelope: envelope to be applied on the page Page layout: layout of the page Click Create new page . Optionally, click the page name in the tree menu on the left and in the area with workspace properties on the right define additional page parameters: URL: the page URL Visible page: visibility of the page Spacing between regions and panels Although users are usually authorized using the authorization method setup for the underlying application container (on Red Hat JBoss EAP, the other security domain by default), the Red Hat JBoss Dashboard Builder has its own role-based access control (RBAC) management tool to facilitate permission management on an individual page or multiple pages. To define permissions on a page or all workspace pages for a role, follow these steps: On the top menu, click the General configuration button. Under the Workspace node on the left, locate the Page or the Pages node. Under the Page or Pages node, click the Page permissions node. In the Page permissions area on the right, delete previously defined permission definition if applicable and define the rights for the required role: In the Permission assignation table, locate the Select role drop-down menu and pick the respective role. In the Actions column of the table, enable or disable individual permissions. Click Save . Although users are usually authorized using the authorization method setup for the underlying application container (on Red Hat JBoss EAP, the other security domain by default), the Red Hat JBoss Dashboard Builder has its own role-based access control (RBAC) management tool to facilitate permission management on an individual page or multiple pages. A panel is a GUI widget which can be placed on a page. There are three main types of panels: Dashboard panels are the primary business activity management panels and include the following: Data provider manager: a panel with a list of available data providers and data provider management options Filter and Drill-down: a panel that displays all KPIs and their values to facilitate filtering in indicators on the given page defined over a data provider HTML Editor panel: a panel with static content Key Performance Indicator (indicator): a panel that visualizes the data of a data provider Navigation panels are panels that provide navigation functions and include the following: Breadcrumb: a panel with the full page hierarchy pointing to the current page Language menu: a panel with available locales (by default in the top center) Logout panel: a panel with the name of the currently logged-in user and the logout button Page menu custom: a panel with vertically arranged links to all pages in the workspace (the list of pages can be adjusted) and general controls for the HTML source of the page Page menu vertical: a panel with vertically arranged links to all pages in the workspace (the list of pages can be adjusted) Page menu horizontal: a panel with horizontally arranged links to all pages in the workspace (the list of pages can be adjusted) Tree menu: a panel with the links to essential features such as Administration , Home (on the Home page of the Showcase workspace displayed on the left, in the lateral menu) Workspace menu custom: a panel with links to available workspaces (the list of workspaces can be adjusted) and general controls for the HTML source of the workspace Workspace menu horizontal: a horizontal panel with links to available workspaces (the list of workspaces can be adjusted) Workspace menu vertical: a vertical panel with links to available workspaces (the list of workspaces can be adjusted) System panels are panels that provide access to system setting and administration facilities and include the following: Data source manager: a panel for management of external data sources Export dashboards: a panel export of dashboards Export/Import workspaces: a panel for exporting and importing of workspaces We are now going to add a panel: Make sure the respective page is open (in the Page drop-down menu of the top menu select the page). In the top menu, click the Create a new panel in current page button. In the displayed dialog box, expand the panel type you want to add ( Dashboard , Navigation , or System ) and click the panel you wish to add. From the Components menu on the left, drag and drop the name of an existing panel instance or the Create panel item into the required location on the page. If inserting a new indicator, the Panel view with the graph settings will appear. Define the graph details and close the dialog. If adding an instance of an already existing indicator, you might not be able to use it, if it is linked to the KPIs on the particular original page. In such a case, create a new panel. If you need to, edit the content of the newly-added panel.

Commands: