Table of Contents

• Preface
• Introduction to Upgrading the Denodo Platform
  • Major Steps in the Upgrade Process
  • Running Both Versions in the Same Computer
  • Upgrading from Denodo Platform 7.0 or Earlier
    • Upgrading from Denodo Platform 7.0, 6.0 and 5.5
    • Upgrading from Denodo Platform 5.0 or Earlier
• Preparing to Upgrade
  • Common to All Modules
    • Kerberos
  • Virtual DataPort
    • Virtual DataPort: Select a Catalog/Schema for the Cache Engine
    • Virtual DataPort: Create a Repository for Version Control
  • Data Catalog: Create a Catalog/Schema on the External Database
  • Scheduler: Create a Catalog/Schema on the External Database
  • Solution Manager
    • Solution Manager: Create a Git Repository or Branch for Version Control
    • Solution Manager: Create a Catalog/Schema on the External Database
• Pre-Upgrade Tasks for the New Installation
  • Common to All Modules
    • Copy the Encryption Key
    • Install the Latest Update
    • Enable SSL
    • Configure Windows Services
    • Kerberos: Copy Krb5 File
  • Virtual DataPort
    • Virtual DataPort: Enable the External Database
    • Virtual DataPort: JDBC Data Sources that Use the Bulk Data Load API
    • Virtual DataPort: Enable the Cache Engine
    • Virtual DataPort: Install Third-Party Connectors
    • Virtual DataPort: Other Third-Party Jar Files
    • Virtual DataPort: Version Control System
    • Virtual DataPort: Delete Unused Objects
    • Virtual DataPort: Delete Aracne and Google Search Data Sources
    • Virtual DataPort - Published Web Services: Customize Logo
    • Virtual DataPort - Denodo Monitor: Configure to Store the Information in a Database
  • Data Catalog: Enable the External Database
  • Scheduler: Enable the External Database
  • Solution Manager
    • Solution Manager: Enable the External Database
    • Solution Manager: High Availability
    • Solution Manager: Enable Git Support
    • Solution Manager: Configure Monitoring JDBC Appenders
• Upgrading from Denodo 6.0: Export the Settings and Metadata of the Current Installation
  • Transforming Views Automatically to Use the New Datetime Data Types
  • Configuration Properties of Virtual DataPort for Upgrades: “exportMigrationCompatibility” and “exportOnlyResources”
  • Alternatives for When You Cannot Install the Latest Update of Denodo 7.0
• Upgrading from Denodo 7.0: Export the Settings and Metadata of the Current Installation
  • Configuration Properties of Virtual DataPort for Upgrades: “exportMigrationCompatibility” and “exportOnlyResources”
  • Alternatives for When You Cannot Install the Latest Update of Denodo 7.0
• Upgrading from Denodo 8.0: Export the Settings and Metadata of the Current Installation
  • Configuration Properties of Virtual DataPort for Upgrades: “exportMigrationCompatibility” and “exportOnlyResources”
  • Alternatives for When You Cannot Install the Latest Update of Denodo 8.0
• Review the Virtual DataPort Metadata
• Import Settings and Metadata in to the New Installation
  • Common Errors when Importing the Metadata of Virtual DataPort to the New Version
• Post-Upgrade Tasks for the New Installation
  • Common to All Components
    • Configure the Connection to the Denodo Security Token Server
    • Review Memory Allocation In Production Servers
  • Virtual DataPort
    • Increase the Memory Allocated to the Tomcat of Denodo Platform
  • Design Studio
  • Virtual DataPort Administration Tool
  • Embedded MPP
  • Data Catalog
  • Scheduler
  • Scheduler Index
  • Solution Manager
  • External Applications: Upgrade the JDBC and ODBC Drivers
• Test the New Denodo Platform Installation
• Backward Compatibility
  • Changes in Denodo Platform 9
    • Features Removed from Denodo Platform 9
      • ITPilot
      • Virtual DataPort
        • Version Control Systems (VCS)
        • VQL Syntax
        • Widgets
      • Denodo Monitor: SNMP Traps
      • Scheduler
        • Elasticsearch 5.x and 6.x
        • VDPCache Incremental Load Processes
      • Denodo4Eclipse Plugin
    • Changes that Apply to All the Modules of the Denodo Platform and Solution Manager
    • Virtual DataPort
    • Design Studio
    • Scheduler
    • Solution Manager
    • Diagnostic & Monitoring Tool
    • User Manuals
  • Changes in Denodo Platform 8.0 GA
    • Changes Common to All the Modules of Denodo 8.0 GA
      • Installer
      • Supported Operating Systems
      • Web Container
        • The “Export” Endpoint is Disabled By Default
        • Change in Post-Installation Tasks
    • Changes in Virtual DataPort 8.0 GA
      • Memory
      • Connections Only Use One Port
      • JDBC Data Sources
        • JDBC Data Sources: Location of Drivers
        • JDBC Data Sources: Some Adapters Have Been Removed
        • JDBC Data Sources with Kerberos Authentication
      • Administration Tool
        • Queries Always Obtain the Execution Trace
      • Getting/Setting Configuration Properties
      • SQL Compatibility
        • UNION and UNION ALL
        • ORDER BY Without Projecting the Field
        • Removal of Leading and Trailing Spaces of Identifiers
      • Privileges
        • WEBCONTAINER SET
        • Roles for the Solution Manager and JMXAdmin
        • Column Privileges, Row Restrictions and Custom Policies Are Always Propagated
        • The Privilege WRITE no Longer Implies INSERT, UPDATE and DELETE
      • Web Services
        • XML Representation of Array-Type Values
        • XML And JSON Representation of Errors Has Changed
        • RESTful Web Service: Parameter $select Allows Expressions
      • Cache Module: PrestoDB/Trino
    • Changes in Solution Manager 8.0 GA
      • Launching Services
    • Features Removed from Aracne 8.0 GA
    • Features Removed from Virtual DataPort 8.0 GA
      • VQL Syntax
        • Contains, Containsand, Containsor and Iscontained Operators
        • Parameter QUERYPLAN of the CONTEXT Clause of SELECT Statements
      • Data Sources
        • JDBC Data Sources
        • JDBC Data Sources: Adapters
      • Privileges
      • JDBC Driver: Property reuseRegistrySockets
      • Administration Tool
        • Option “Internationalize query results”
        • Option “Execute with trace”
        • Removed “Query Capabilities” Panel
        • Removed Swapping Settings for Views and Databases
    • Features Removed from Scheduler 8.0 GA
      • Data Sources Removed
      • Jobs Removed
      • Other Elements Removed
    • Features Removed from Solution Manager 8.0 GA
      • Web Panel
  • Changes in Denodo Platform 7.0
    • Changes Common to All the Modules of Denodo 7.0
      • Extensions
      • API Documentation
      • Web Container (Tomcat)
        • SSL/TLS
        • Encoding Square Brackets in the URL
    • Changes in Virtual DataPort 7.0
      • Privileges
        • CONNECT Privilege
        • Privileges of Users with the Role “serveradmin”
      • Changes in VQL Syntax
      • Changes in Date Types
        • Search Fields that Use the Type Date
        • Subtracting “Date” Expressions Now Returns a Long
        • Backward Compatibility Properties
      • Changes in Stored Procedures
        • Procedure VIEW_DEPENDENCIES
        • Procedure GET_CATALOG_METADATA_WS
        • Procedures GET_ELEMENTS and GET_VIEWS
      • Changes in Cost Optimization
      • Subtype of DECIMAL Fields
      • JDBC Data Sources
        • Oracle
        • Apache Hive
        • Impala JDBC Drivers
      • DenodoConnect Component: Salesforce Wrapper
      • Denodo JDBC Driver Compiled with Java 8
    • Changes in the Privileges System in Virtual DataPort 7.0
      • Detailed Description
        • Privileges over Databases
        • Privileges over Data Sources
        • Privileges over Views
        • Privileges over Data Service (Web Services, Widgets and JMS Listeners)
        • Privileges over Stored Procedures
      • CATALOG_PERMISSIONS Procedure
      • Creating Internationalization Maps and Importing Jar Extensions
      • Restoring the Behavior of Prior Versions
    • Features Removed from Virtual DataPort 7.0
      • I18n Settings
        • I18n Settings of the Cache Engine
        • Databases and Cache Do not Have I18N
      • VQL Syntax
      • JDBC Data Source Dialog: Choose Automatically
      • ODBC Data Sources
      • JDBC/ODBC Source Configuration Properties
      • XMLA Connectors for SAP
      • Comparison of Strings: Case Sensitive
      • Published Web Services: “with LDAP” Authentication
      • Export Script
      • Denodo JDBC Driver
        • Basic Version
        • Internal Pool of Connections
        • Kerberos Constrained Delegation
      • Denodo ODBC Driver
      • Others
    • Changes Introduced in Aracne 7.0
      • The Aracne Module Has Been Deprecated
  • Changes in Denodo Platform 6.0
    • Changes Common to All the Modules of Denodo 6.0
      • Logging: Clearer Format for Dates
    • Changes in Virtual DataPort 6.0
      • Changes in VQL Syntax
      • Changes in VQL Statements
        • CREATE DATASOURCE JDBC
        • LIST FUNCTIONS CUSTOM
      • Dependencies to Develop Custom Elements (Functions, Wrappers…)
      • Importing Roles from an LDAP Server
      • JDBC Data Sources
        • Access to Teradata
        • Delegate SQL Sentence as Subquery
      • JDBC Driver
        • Location of the JDBC Driver
        • Metadata Returned by the JDBC Driver
        • JDBC Driver Compiled with Java 7
      • JMX
      • Memory Usage Options
      • ODBC Driver
        • New Denodo ODBC Driver
        • Date Values with Millisecond Precision
      • REST Web Services No Longer Return the HTTP Code 204 by Default
      • Stored Procedures
      • User Privileges
      • Version Control System Integration (VCS)
      • Windows Services
      • Features Deprecated in Denodo 6.0
        • VQL Syntax
        • Internal Pool of Connections of the JDBC Driver
        • Published Web Services: “with LDAP” Authentication
        • SQLFRAGMENT Clause
        • Stored Procedures API: getNumOfAffectedRows Method
        • Custom Wrappers API: Deprecated Methods
        • XMLA Connectors for SAP
        • JDBC Data Source Dialog: Choose Automatically
      • Features Removed in Denodo 6.0
        • Enumerated and Money Types
        • Generic SOAP Web Service Interface
        • Server Administration Mode
    • Changes in Scheduler 6.0
      • Counters for the Number of Documents and Errors Are Stored in a Long
    • Changes in the Embedded Web Container of Denodo 6.0
      • Location of the Log4j Configuration File
      • Changes in the Default Configuration of the Logging System
      • Configuration Changes
  • Changes in Denodo Platform 5.5
    • Changes in Virtual DataPort 5.5
      • Compliance with SQL Three-Valued Logic
      • Cache - Default Fetch Size
      • CAST Function
      • More Reserved Words
      • Prohibit Setting Incompatible Source Type Properties
    • Features Removed in Denodo 5.5
      • OpenAjax Widgets
  • Changes in Denodo Platform 5.0
    • Changes in Virtual DataPort 5.0
      • Some Elements are Now Case-Sensitive
      • Dependencies Between Elements
      • JMS Listeners
      • Stored Procedures
      • Web Services Published by Denodo
      • Exporting to a Repository of Files
• Features Deprecated in Denodo Platform
  • Virtual DataPort
    • Administration Tool
    • Data Type “Date”
    • VQL Syntax
      • SQLFRAGMENT Clause
      • Syntax ALTER TABLE <Base View Name> ADD SEARCHMETHOD
      • Parameters of the CONTEXT Clause of SELECT Statements
      • Deprecated Functions
      • Command QUERY WRAPPER
    • Data Sources
      • Deprecated JDBC Adapters
      • ODBC Data Sources
      • Decrypt Filter
    • Denodo Stored Procedures
    • Role JMXAdmin
    • Denodo Stored Procedures API: getNumOfAffectedRows Method
    • Denodo Custom Wrappers API: Deprecated Methods
    • Denodo JDBC Driver
    • Denodo Web Services
    • Version Control Systems (VCS)
    • Script Export: Deprecated Parameters
    • Launching Several Virtual DataPort Instances of the Same Installation
      • Resource Manager
  • Data Catalog
    • Roles “selfserviceadmin”, “selfserviceexporter”
  • Scheduler
    • Private Scheduler REST API
  • Solution Manager
    • REST API: Authentication Using Session