› Management Console › Data view

Data view

Use Data view to see database data for projects and to export data extracted by robots. Also use it to see database tables created from types using Design Studio or Management Console.

The list of schemas/catalogs available under each database in the navigation tree is controlled by the permissions of the user whose credentials are used in the cluster settings database configuration.

Display and select tables

To display one of the tables of the database mappings defined for a project, click Database navigation > Projects > Database mappings > Table.

When you click a database mapping name, the tree is expanded, and you see the various tables contained in the database. When you select a table, the type data is displayed in the right pane, including the names of types, robots associated with those types, and types attributes.

Copy data directly from the table. Also, select the columns to display for a database table using the menu icon on the right.

Once the data is loaded, a number of filters become available that work in the same way as the filters in the Log view. For example, you can filter by the following conditions: Contains, Not contains, One of, Starts with, and so on. Binary and longtext attributes are not filterable.

Table requirements

For a database mapping name to be active (expandable), a database connection must be established and the tables must exist for the database.

Tables can be selected in the Data view when the database tables contain the following RPA metadata fields:

  • ExecutionId

  • ExtractedInLastRun

  • FirstExtracted

  • LastExtracted

  • LastUpdated

  • ObjectKey

  • RobotName

These metadata fields are automatically generated when the database step is created in Design Studio.

Without the metadata fields, the tables appear but are read-only.

Export data

Above the data grid, in the Export to list, select the format to export data extracted by robots: XML, CSV, or Excel.

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.

To see previous exports and download them again, click Exports to open the Exports dialog box.

By default, the following information is displayed for each export.

Column

Description

Created Date when the export was created.
Table Name of the table that the export was created for.
Database Name of the database that the table belongs to.
Catalog Database catalog that the table belongs to, if applicable.
Download Click to download the export.

The exports are automatically deleted the next time the Management Console is started. The oldest exports are deleted when the number of exports exceeds 100.