Data Marketplace Guide

Table of Contents

• Preface
  • Scope
  • Who Should Use This Document
  • Summary of Contents
• Introduction
• Installation and Execution
  • Launching the Data Marketplace
• Introducing the Data Marketplace
  • Search Data Assets or Query Their Content
    • Role and permission needed
• Search
  • Metadata Search
    • Metadata Search in Index
  • Content Search
• Denodo Assistant Chatbot
  • Accessing the Chatbot
    • Using the Search Bar
    • Using the Floating Button
  • Panel Controls
  • Interacting with the Assistant
    • Sending Questions and Managing Responses
    • Filtering Context
    • Follow-up Questions
  • Tools
    • Metadata
    • Data
      • Data Visualization
    • Deep Query
      • When to use the Deep Query tool
      • Submitting Deep Query Questions
      • Deep Query Report
    • Direct Answer
• 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
    • Practical Scenario
    • Filters Definition
    • Transformation Definition
      • Common
      • Text
      • Number
      • Date
      • Aggregation
  • Assisted Query
    • Generating a Query
      • Improving Query Accuracy
        • Sample Data
        • Descriptions
    • Executing the Generated Query
      • Execution with Manual Execution Mode
      • Execution with Automatic Execution Mode
    • Other Options
    • Examples
      • Semantic Understanding
      • Aggregations
      • Filtering
      • Input clarity
      • Sample data
      • Relationships
    • Assisted Query Role
    • Log Assisted Query HTTP information
      • Amazon Bedrock is set as the LLM provider
      • Other LLM providers
        • Virtual DataPort Server and the Web Administration Tools Are on the Same Installation
        • Virtual DataPort Server and the Web Administration Tools Are not on the Same Installation
  • 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
  • Language and Region Settings
    • Internationalize Results
    • Internationalize Field Descriptions
    • User Interface Language
  • Denodo Assistant Settings
  • My Requests
  • My Notifications
  • Admin Notifications
  • Accessibility Mode
  • Change theme
• 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 Marketplace
    • Marketplace Management
    • Administration
    • Collaboration
    • User
    • Request
    • External element
    • Denodo Assistant
  • 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 Marketplace 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 Marketplace
    • Configure the Permissions
    • Large Language Models (LLM) Configuration
      • Provider Configuration
        • Amazon Bedrock (Anthropic Claude) Provider
        • Azure OpenAI Service Provider
        • OpenAI Provider
        • Other (OpenAI API Compatible)
      • Thinking Provider Configuration
        • Amazon Bedrock (Anthropic Claude) Thinking Provider
        • Azure OpenAI / OpenAI Thinking Provider
      • HTTP Proxy Configuration
      • Custom Headers Configuration
    • Vector Database Configuration
      • Connection Configuration
        • PostgreSQL (PGVector)
        • GCP Cloud SQL for PostgreSQL
        • Amazon Aurora (PostgreSQL)
        • Oracle 26ai and higher
        • SQL Server 2025 or higher
        • Azure SQL Managed Instance
      • Embedding Model Configuration
        • Amazon Bedrock (Titan)
        • Azure OpenAI Service
        • OpenAI
        • Other (OpenAI API Compatible)
      • Index Configuration
      • Servers Configuration
  • Search Engines
    • Index Servers
    • Content Search
    • Metadata Search
  • Personalization
    • Elements
    • Information
    • Export
      • Enabling Exports to Tableau
    • Connection
    • Usage Statistics
      • Configure the Denodo Monitor to Store the Requests Log in a Database
      • Configure Virtual DataPort to Read, Process and Cache the Requests Data From Database
      • Enable Usage Statistics in Data Marketplace
      • Compute Usage Statistics
    • Data Preparation
    • Denodo Assistant
      • Assisted Query Configuration
      • Chatbot Configuration
    • Theme
    • Language and Region
    • Accessibility
  • Requests
    • Configuration
  • 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 Marketplace Metadata
    • Export Metadata
    • Import Metadata
  • Synchronize with Virtual DataPort
• Appendix
  • Installing the Data Marketplace on a Cluster: Sharing the Same Settings Across All the Nodes
    • Setting Up the Common Database
    • Configure the Data Marketplace 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 Marketplace 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 Tenant Settings for Delegated User
        • Service Principal Authentication
          • Assign Power BI API Permissions for Service Principal
          • Enable Tenant Settings for Service Principal
    • Set Up Tableau
      • Enable the Metadata API
      • Configure User Roles and Permissions
      • Configure the Tableau Authentication Method