Table of Contents

• Preface
  • Scope
  • Who Should Use This Document
  • Summary of Contents
• Introduction
• Installation and Execution
  • Launching the Data Catalog
• Introducing the Data Catalog
• Search
  • Metadata Search
    • Metadata Search in Index
  • Content Search
• Browse
  • Databases
  • Domains and Categories
  • Tags
• Databases
  • Summary of Databases
  • Requests of Databases
  • Associations of Databases
• Views
  • Summary of Views
  • Schema of Views
  • Query of Views
    • Building a Query
      • Fields
      • Relationship Fields
      • Output Columns
        • Add a Field
        • Set all Fields
        • Add a Derived Field
        • Add a Derived Field using Suggestions
        • Add an Aggregation Field
        • Edit a Field
        • Remove a Field
        • Reorder a Field
      • Filters
        • Add a Quick Filter
        • Add a Complex Filter
        • Add a Filter Using Suggestions
        • Edit a Filter
        • Remove a Filter
        • Reorder a Filter
      • Order By
        • Add a Sort
        • Change the Order
        • Remove a Sort
        • Reorder a sort
    • Executing a Query
    • Taking Advantage of Associations
      • Expanding To-One Associations
      • Navigating Through Associations
  • Data Preparation
    • Loading Data
      • Add Fields to Output Columns
      • Sort Fields
      • Reorder Fields in Output Columns
      • Remove Fields from Output Columns
    • Preparing Data
      • Apply a Filter
      • Apply a Filter from Expression
      • Apply suggested filters
      • Apply a Transformation
      • Apply a Transformation from Suggestions
      • Sort by Column
      • Create a New Column
      • Remove a Column
      • Reorder a Column
      • Rename a Column
      • Edit an Action
      • Remove an Action
      • Check the VQL of the Query
      • Save the Query
    • Executing the Query
  • Assisted Query
    • Generating a Query
    • Executing the Generated Query
      • Execution with Manual Execution Mode
      • Execution with Automatic Execution Mode
    • Other Options
    • Assisted Query Role
  • Associations of Views
  • Lineage of Views
  • Reference Lineage of Views
  • Requests of Views
  • Usage of Views
  • Data Profiling of Views
  • Search of Views
• Web Services
  • Summary of Web Services
  • Schema of Web Services
    • Schema of SOAP Web Services
    • Schema of REST Web Services
  • Query of Web Services
    • Building a Query
      • Fields
      • Relationship Fields
      • Output Columns
      • Filters
      • Order By
    • Executing a Query
    • Taking Advantage of Associations
  • Requests of Web Services
  • Usage of Web Services
• External Elements
  • Summary of External Elements
  • Reference Lineage of External Element
  • Requests of External Elements
• Workflow Requests
  • My Requests
  • Request Management
  • My Notifications
  • Administrator Notifications
  • Email Templates
• Queries
  • My Queries
    • Deploying Saved Queries
    • Sharing Saved Queries
    • Exporting and Importing Saved Queries
  • VQL Shell
• User Settings
  • Locale Configuration
    • Internationalize Results
    • Internationalize Field Descriptions
  • My Requests
  • My Notifications
  • Admin Notifications
  • Accessibility Mode
• Authentication
  • Authentication with Login and Password
  • Single Sign-On with Kerberos
  • Single Sign-On with an Identity Provider
  • Local Authentication
• Authorization
  • Privileges on the Data Catalog
    • Catalog Management
    • Administration
    • Collaboration
    • User
    • Request
    • External element
  • Roles with Predefined Privileges
    • data_catalog_editor
    • data_catalog_classifier
    • data_catalog_manager
    • data_catalog_content_admin
  • Roles with Implicit Privileges
    • data_catalog_exporter
    • data_catalog_data_preparation
    • data_catalog_assisted_query
    • data_catalog_admin
  • Users with Implicit Privileges
    • Data Catalog Local User
    • Denodo Global Administrator
• Administration
  • Server Set-Up
    • Configure the Virtual DataPort Servers
    • Configure the Connection Settings to the Virtual DataPort Servers
    • Enable Single Sign-On with Kerberos
    • Use an External Database for the Data Catalog
    • Configure the Permissions
    • Large Language Models (LLM) Configuration
      • Provider Configuration
        • Amazon Bedrock Provider
        • Azure OpenAI Service Provider
        • OpenAI Provider
        • Custom Provider
          • Custom Compatibility Mode
            • OpenAI
            • Azure OpenAI Service
      • HTTP Proxy Configuration
  • Search Engines
    • Index Servers
    • Content Search
    • Metadata Search
  • Personalization
    • Elements
    • Information
    • Export
      • Enabling Exports to Tableau
    • Connection
    • Usage Statistics
      • Steps to Configure the Gathering of Statistics
    • Data Preparation
    • Denodo Assistant
      • Assisted Query Configuration
    • Theme
  • Requests
  • External Tools
    • Register a Tableau External Tool Server
    • Register a Microsoft Power BI External Tool Server
    • Synchronization
  • Categories Management
    • Create Categories
    • Edit Categories
    • Remove Categories
    • Assign Categories
  • Tags Management
    • Create Tags
    • Edit Tags
    • Remove Tags
    • Assign Tags
  • Elements Management
  • Property Groups Management
    • Manage Property Groups
      • Create Property Groups
      • Edit Property Groups
      • Remove Property Groups
      • Sort Property Groups
    • Manage the Custom Properties of a Property Group
      • Create Custom Properties
      • Edit Custom Properties
      • Remove Custom Properties
      • Sort Custom Properties
    • Assign Property Groups
  • Import and Export Data Catalog Metadata
    • Export Metadata
    • Import Metadata
  • Synchronize with Virtual DataPort
• Appendix
  • Installing the Data Catalog on a Cluster: Sharing the Same Settings Across All the Nodes
    • Setting Up the Common Database
    • Configure the Data Catalog to Use the Common Database
  • REST API
    • HTTP Basic Authentication (stateless)
    • OAuth Token (stateless)
    • OAuth Token (Stateful)
    • CORS Configuration
  • Apache Lucene Search Syntax
    • Terms
    • Fields
    • Term Modifiers
    • Boolean Operators
    • Grouping
    • Field Grouping
    • Escaping Special Characters
  • Data Catalog Scripts
    • Change Password Script
    • Configure Export Key Script
    • Export Metadata Script
    • Import Metadata Script
    • Change Database Settings Script
  • Set Up External Tool Environment
    • Set Up Power BI
      • Register a Client Application in Microsoft Entra ID
      • Create a Security Group in Microsoft Entra ID
      • Assign Security Group and Role to Power BI Workspaces
      • Assign Workspaces to a Dedicated Capacity
      • Configure the Power BI Authentication Method
        • Username and Password Authentication
          • Assign Fabric Administrator Role in Microsoft 365
          • Assign Power BI API Permissions for Delegated User
          • Enable Admin API Settings for Delegated User
        • Service Principal Authentication
          • Assign Power BI API Permissions for Service Principal
          • Enable Admin API Settings for Service Principal
    • Set Up Tableau
      • Enable the Metadata API
      • Configure User Roles and Permissions
      • Configure the Tableau Authentication Method