Summary of Views

The Summary tab contains all the basic information about the current view.

The Summary tab shows the basic information about the view

The Summary tab shows the basic information about the view

This information consists of:

  • The database where you can find the view in Virtual DataPort.

  • A description about the view. At first, it is obtained from Virtual DataPort. However, if you have the proper permissions, you will see a edit icon next to the description. Click it and define a new description, which will be specific to the Data Catalog.

    Dialog to edit the description of a view

    The Data Catalog can have its own description for a view, in plain text or HTML

  • The categories the view belong to. If you are allowed to assign catagories you will see the Add Category button in the toolbar. Click it to edit the categories.

    Dialog to edit the categories of a view

    In the dialog to edit the categories the current list is highlighted in blue

  • The tags that describe the view. If you are allowed to assign tags you will see the Add Tag button in the toolbar. Click it to edit the tags.

    Dialog to edit the tags of a view

    In the dialog to edit the tags the current list is highlighted in blue

  • The people who endorsed this view. Since Data Catalog 8.0, users can write comments on views to show their support. Next to the Endorsed by label you have the number of endorsements on this view and their authors. Move the mouse over an author to see her comment. Click the number of endorsements and check all the comments at once.

    Dialog with all the endorsements of a view

    In the dialog with all the endorsements you can edit your own comment. Depending on your permissions, you may also be able to edit other people’s comments.

    If you are allowed to create endorsements, you will see the option Collaboration > Endorse in the toolbar. Click it and write your comment. Take into account that you can only endorse a view once. If you write a new comment, the previous endorsement will be replaced.

  • The people who warned against this view. In the same way that users can support views writing endorsements, they can advise against them writing warnings. Next to the Warnings by label you have the number of warnings on this view and their authors. If you are allowed to write warnings, you will see the option Collaboration > Warn. Remember that you can only write one warning against a view.

  • A sign of deprecation. Besides endorsements or warnings, users can write deprecation notes, where they inform that a view is obsolete and should not be used anymore. If the view is deprecated you will see the deprecated icon in the toolbar and a notification will appear every time you access the view.

    Notification with the deprecation messages of a view

    The notification with the deprecation messages has a Show details button. Click it to check all deprecations or edit them if you are allowed to.

    If you are allowed to write deprecations, you will see the option Collaboration > Deprecate. Remember that you can only write one deprecation about a view.

    Note

    The endorsements, warnings and deprecation notes are only available with the Semantics Feature Pack. To find out the subscription bundle you have, open the About dialog of the Data Catalog.

  • The connection URLs to access this view. In the toolbar you will find the Connection URLs button. Click it and obtain the URLs to connect to this view through all the available APIs: JDBC, ODBC, REST and OData.

    URLs to connect to a view of Virtual DataPort through all the available APIs

    Click the copy icon next to each URL to copy it to the clipboard

    Note

    The Connection URLs button may have been disabled by the administrator of the Data Catalog.

  • The data source for Tableau. If you have privileges to execute this view, you will find the Tableau button in the toolbar. Click it to download a data source file (with .tds extension). Load this file in Tableau Desktop 10.5.0 or later. It will establish a connection to query this view using the named connector for Denodo in Tableau.

    Note

    The Tableau button may have been disabled by the administrator of the Data Catalog.

In addition, an administrator of the Data Catalog can add custom properties to the view to improve the information you have about it. If they are configured to appear in the Summary tab, you will see a collapsible section for each group of custom properties. With the proper permissions, you will find a edit icon next to each custom property to edit it.