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. As VDP tags are read-only, only the tags defined in Data Catalog will be available to select in the dialog.

    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 FeaturePack. 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 Open in menu to open this view in third-party applications. If you have privileges to execute this view, you will find the Open in menu in the toolbar.

    The following third-party applications are supported:

    • Power BI: Click this button to download a data source file (with .pbids extension). Load this file in Power BI Desktop. Supported since the May 2022 release. It will establish a connection to query this view using the Denodo for Power BI connector.

    • Tableau: Click this button 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

    Third-party application buttons may have been disabled by the administrator of the Data Catalog.

    Note

    If there is only one third-party application enabled, the application button will be shown directly instead of the Open in menu.

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.