Data

The Data view allows you to view and export data extracted by Robots.

Data View

In the upper left-hand corner of the Data View, you can see the database navigation tree along with a cluster selector. You can view data from the databases for each cluster. So to view data from a given cluster, simply select it, and the databases defined in that cluster's settings will be shown in the database navigation tree. Next to the cluster selector is a refresh button for use when the cluster databases have changed in which case it will re-populate the database navigation tree to show the new information.

When you click a database name, the tree will open, and you will see the various schemas in the database. When you click a schema you will see the Kapow tables in that schema. When you click a table, the contents of that table will be loaded into the data grid on the right. Once the data is loaded, a number of filter will be visible underneath the database navigation tree. The filters work exactly like the filters on the Logging Tab. Binary and longtext attributes are not filterable.

If you click the Delete column, a window will open allowing you to delete one or more rows for the table. Double clicking a row will bring up a window with the content of that row, allowing you to copy the data.

Above the data grid, you see an Export bar, containing 4 buttons. The first 3 buttons allow you to export the table data to either Excel, XML, or CSV format. The fourth button allows you to see previous export, and download them again. The exports are automatically deleted the next time the Management Console is restarted, also the oldest exports are deleted when the number of exports exceeds 100. There is no limit to the number of rows you can export to CSV or XML, but Excel files are limited to 10000 records, to prevent the system from running out of memory.

The list of schemas/catalogs available under each database in the navigation tree, is controlled by the permissions of the user who's credentials are used (in the cluster settings database configuration).