Teiid Console

Teiid Console is a web based administrative and monitoring tool for Teiid. Teiid Console is extension of WildFly console that is built using GWT based technologies. The Teiid kit does not include files for Teiid Console. This is separate download you can download from Teiid Downloads.

Installation

Once you download the Teiid Console, unzip the contents over the WildFly root directory and all the required files will be overlayed correctly to install Teiid Console. The Teiid Console, by default is secured, so you would need a management realm user id and password to log in. In the <install>/bin directory, use

Adding a management user in linux
./add-user.sh
Adding a management user in Windows
add-user.bat

then follow the prompts to create Management Realm user. Once you have created a management user, you need to use these credentials to log in to the Teiid Console. If you have started your WildFly in default mode, then you can access the Teiid Console at http://localhost:9990/console/App.html. If you have altered the binding or port numbers then modify the address accordingly.

Profile View

Profile view is for configuration. Click on "profile" on top right hand corner of the main console screen, to go to Profile View. You can click on "Teiid" in left navigation tree to go to Teiid configuration. There you have three choices

  • Query Engine - view and configure core Teiid engine properties.

  • Translators - view, add and remove the Translators configured in Teiid.

  • Transports - view, add and remove transports to the Teiid engine.

webconsole2.png

Using this view you can change any configuration value of Teiid. Note that various different configuration properties are sub-divided into different tabs. You can click "Need Help" link on these pages to see the description of each field on the page.

Note
Server Restart - Note that some properties require you to restart the server before they can take effect.

Runtime View

Runtime view shows run time information about AS7 and Teiid subsystem. Runtime information about Teiid can be viewed by selecting "Virtual Databases" on left hand navigational tree.

webconsole1.png

Using this page user can view many different settings in the context a VDB. All the VDBs deployed in the server are shown in top level table. When you select and highlight a VDB, more details about that VDB are displayed in the sub-tabs below. Each of these sub-tabs are divided into grouping of the functionality.

Summary

This tab shows the description and any properties associated with VDB, along with any other VDBs this VDB imports. This tab is designed to give a quick overview of the VDB status.

Models

This panel shows all the models that are defined in a given VDB, and shows each models translator name and source connection JNDI name. It also shows the type of models and if it is multi-source or not. When a particular model is selected it will show all properties of that model that are defined and also shows any errors associated with the model. When your VDB is not deployed in the "active" status, you would need to verify these errors and fix to resolve any deployment issues.

The "DDL" button shows the schema for the given model. Note that this does not work for XML based models that are designed using Teiid Designer.

The tool lets the user edit the translator name or JNDI name by double clicking on them and modifying them. This useful if you would like to change the JNDI name in a given environment.

Overrides

If you have overridden any translators in the Teiid Designer, this panel will show the all the overridden translators and their properties.

Caching

Caching panel shows caching statistics of resultset cache as to how effectively the cache is being used. It also shows all the internal materialized views in the VDB and their load status as to when they were loaded. It also gives options to invalidate a specific view or all the views in a VDB, so that they can refresh/reload the contents from source.

This panel also provides a UI to flush the entire the resultset cache contents or prepared plan cache contents for the selected VDB.

Data Roles

Data Roles panel shows the all the policies that defined in the VDB using the Teiid Designer or hand coded in the vdb.xml file. For each selected policy, it will also list the "permissions" for that policy as to what kind of authorizations user has and shows the mapped enterprise role assignments to that policy. You can even add/remove a enterprise role to the policy using the this UI.

Requests

This panel shows all the current requests against the selected VDB at the time of VDB selection. You can click "refresh" to get a more up to date requests. The top table in the panel shows the user submitted requests to the teiid engine, when one of those requests are selected, then the bottom table shows all the source level queries that are submitted to the physical sources by Teiid engine.

Using this UI, user can also submit a "cancel" request to a user level query. Since "cancel" asynchronous operation, the operation is not guaranteed as query may already been finished, by the time cancel is submitted.

Sessions

This panel shows all the active sessions that are connected to the selected VDB. It shows their connection properties and also gives an option to terminate either a selected session or all the sessions.

FAQ

  • How to deploy a VDB in standalone mode?

In the Deployments view, click add and select the VDB to deploy. Also make sure you enable the VDB once it is deployed.

  • How to create Data source?

In the Configuration view, go to SubsystemDatasourcesXA/Non-XA, click add and follow the wizard to create JDBC data source.

If you trying to create connection to Teiid based File, Salesforce or WS based connections, select SubsystemResource Adaptors and click add.

  • How to add COMMAND Logging?

In the Configuration view, go to SubsystemLogging, click view, on Log Categories tab, click add org.teiid.COMMAND_LOG in DEBUG mode. The default log will be in the FILE handler. You can even add other handler if choose to do so.

  • Change Teiid JDBC Port in standalone mode?

In the Configuration view, go to Socket Binding click View, view the standard-sockets select teiid-jdbc and edit.

results matching ""

    No results matching ""