Export Data Using Hub Central

You can export the Explore document list to a CSV file. All pages of the document list are included.

Note: In Data Hub 5.5, object and array datatype properties cannot be exported. If the selected dataset includes objects and arrays, a preview of the CSV is shown before the export is completed.

If you do not have the required privileges to view, filter, or export a specific document, you will not be able to perform that action on that document. For example, if you are permitted to view the document but not export it, it is included in the displayed document list but it is excluded from the exported list.

Before you begin

You need:

  • Security role(s):
    • To view PII data: pii-reader
    • To view all other data: any Hub Central role
    • To save and run queries: Hub Central Explorer or Hub Central Operator
    • To export data: Hub Central Explorer or Hub Central Operator
    Or any role that inherits the required role. See Users and Roles.

Procedure

  1. Go to the Explore area of Hub Central.
    Learn how.
    1. Go to your Hub Central endpoint.
    2. In the icon bar, click the Explore icon (h).
      Hub Central - icon bar - Explore

  2. At the Explore portal, choose the data you see and how you view it, or run a predefined query.

    Hub Central - explore - portal

    • To filter your data, select from the entity type dropdown and/or enter text to search for.
    • Choose the Table view.
      Note: Export is available only in the Table view.
    • To run a predefined query, select from the query dropdown.
  3. Click Explore to view your data.
  4. (Optional) Choose what to export.

    Only the items in the document list are exported. To define what is included in the document list, you can perform any combination of the following:

  5. Click the Export icon ().

    Hub Central - explore - Export

    Note: The icon does not appear if All Entities is selected.
  6. (Optional) In the Export dialog, specify the number of rows (documents or records) to export or choose All.

    The documents are exported in the selected sort order. If you specify n as the number of rows to export, the first n documents, according to the sort order, are exported.