- Denodo Platform Installation Guide
- Legal Note
- Preface
- Introduction
- Preinstallation Tasks
- Using the Graphical Installation Wizard
- Using the Command Line Installer
- Unattended Installation of the Denodo Platform
- Post-Installation Tasks
- Install the Latest Update
- Change the Host Name in the Virtual DataPort Server
- Register the Denodo Servers in the License Manager
- Enable SSL/TLS in the Denodo Platform
- Configure Windows Services
- Post-Installation Tasks: Virtual DataPort
- Change the Default Passwords
- Setting-up Kerberos Authentication
- Setting-up Kerberos Authentication in the Data Catalog
- Enabling the Support for ODBC Sources When the Virtual DataPort Server Runs on Linux
- Installing the Connector for Oracle Essbase
- Installing the SAP JCo Connector
- Installing the Microsoft Access Driver
- Installing the JMS Connectors to Create JMS Listeners and Web Services with SOAP Over JMS
- Configuring the VCS Clients
- Importing the Certificates of Data Sources (SSL/TLS Connections)
- Increasing the Maximum Simultaneous Requests
- Resource Manager: Modify the Priority of a Query Dynamically
- Preparing the Connection to Databases
- Grant Privileges in SAP BW to the Virtual DataPort User Account
- Grant Privileges on SAP for BAPI Sources
- Enable XMLA on Microsoft SQL Server Analysis Services (Multidimensional Sources)
- Post-Installation Tasks: ITPilot
- Checking that the Generation Environment Has Been Installed
- Configuration of Microsoft Internet Explorer
- Enabling Internet Explorer Sequence Generation Toolbar in Microsoft Windows Server 2008
- Disabling Internet Explorer Enhanced Security Configuration in Microsoft Windows 2008
- Disabling Internet Explorer Enhanced Security Configuration in Microsoft Windows Server 2012
- Manual Configuration of Adobe Acrobat Professional
- Automatic Verification Database
- Launching the Wrapper Generator Tool in High DPI Displays
- Post-Installation Tasks: Scheduler
- Post-Installation Tasks: Web Container
- Upgrading from a Previous Version
- Installing Updates and Hotfixes
- Denodo Platform Control Center
- Appendix
- Default Ports Used by the Denodo Platform Modules
- Limitations of the Denodo Express License
- Using Kerberos Authentication in Virtual DataPort Without Joining a Kerberos Realm
- Using Kerberos Authentication in the Data Catalog Without Joining a Kerberos Realm
- Using Kerberos Authentication in Scheduler Without Joining a Kerberos Realm
- How to Debug Kerberos in Web Applications
- Providing a Krb5 File for Kerberos Authentication
- Launching the Denodo Standalone Applications in High DPI Displays
- Deploying the Web Administration Tool in an External Web Container
- Troubleshooting the Denodo Platform Installer
- Transparent Metadata Encryption
- Denodo Platform Migration Guide
- Preface
- Outline of the Migration Process
- Before Beginning the Migration
- Export the Metadata of the Current Installation
- Modify the Virtual DataPort Metadata
- Import the Metadata to the New Installation
- After Importing the Metadata into the New Installation
- Test the New Denodo Platform Installation
- Backward Compatibility
- Features Deprecated in Virtual DataPort 7.0
- Data Type “Date”
- VQL Syntax
- Data Sources: Decrypt Filter
- Aracne Data Sources
- Google Search
- Denodo Stored Procedures
- Denodo Stored Procedures API: getNumOfAffectedRows Method
- Denodo Custom Wrappers API: Deprecated Methods
- Denodo JDBC Driver
- Denodo Web Services
- Widgets
- Script Export
- Data Catalog: Roles “selfserviceadmin”, “selfserviceexporter”
- Features Deprecated in Scheduler 7.0
- Features Deprecated in Solution Manager 7.0
- Denodo Platform New Features Guide
- Preface
- What Is New in Denodo 7.0 Update 20200310
- What Is New in Denodo 7.0 Update 20190903
- 7.0 GA: New Features Common to All Modules
- 7.0 GA: New Features of the Installer
- 7.0 GA: New Features of Virtual DataPort
- 7.0 GA: New Features of Scheduler
- 7.0 GA: New Features of the Embedded Web Container
- Virtual DataPort Administration Guide
- Preface
- Introduction
- General Architecture
- Installation and Execution
- Creating Data Sources and Base Views
- JDBC Sources
- ODBC Sources
- SOAP Web Service Sources
- Multidimensional Database Sources
- Path Types in Virtual DataPort
- XML Sources
- JSON Sources
- Delimited File Sources
- Excel Sources
- Web Sources (WWW)
- Google Search Sources
- Aracne Sources
- LDAP Sources
- BAPI Sources
- Salesforce Sources
- Custom Sources
- Viewing the Schema of a Base View
- Data Source Configuration Properties
- Source Refresh
- Working with Blob Fields of Base Views
- Creating Derived Views
- Creating Union Views
- Creating Join Views
- Creating Selection Views
- Creating Flatten Views
- Creating Intersection Views
- Creating Minus Views
- Creating Interface Views
- Viewing the Schema of a Derived View
- Tree View
- Data Lineage
- Advanced Configuration of Views
- Materialized Tables
- Temporary Tables
- Querying Views
- Editing / Replacing a View
- Stored Procedures
- Publication of Web Services
- Publication of Views as Widgets
- RESTful Architecture
- JMS Listeners
- Remote Tables
- Server Administration - Configuring the Server
- Server Connectivity
- Threads Pool
- Configuring the Cache
- Limiting the Number of Concurrent Requests
- Default Configuration of HTTP Proxy
- Configuring the Memory Usage and Swapping Policy
- Queries Optimization
- Configuring Runtime Parameters for Stored Procedures
- Configuring the Default Internationalization
- Identifiers Charset
- Kerberos Authentication
- OAuth Authentication
- SAML Authentication
- Privileges
- Memory Management
- Resource Manager
- Exporting and Importing the Server Metadata
- Importing Extensions
- Cache Module
- Version Control Systems Integration
- Databases, Users and Access Rights in Virtual DataPort
- Monitoring the Virtual DataPort Server
- Cluster Architectures / Server Backup
- Bulk Data Load
- Optimizing Queries
- Appendix
- Supported JDBC Data Sources
- Backward Compatibility Between the Virtual DataPort Server and Its Clients
- Mapping Multidimensional Data to a Relational Model
- Considerations When Configuring Data Sources with Pass-Through Credentials
- Configuring the Logging System
- Configuring the Network Interface Restriction in Virtual DataPort
- Installing the Denodo Solution for Microsoft SharePoint
- Customizing Events and Public Render Parameters of JSR-286 Portlets
- Transforming Incoming/Outgoing Soap/Rest Messages with XSLT Stylesheets
- JMS Connection Details: JNDI Properties
- Execution Trace Information
- Web Services Created with Previous Versions of the Denodo Platform
- Publishing Web Services
- XSLT Transformations of Web Services Created with Previous Versions
- SOAP Over JMS on Web Services Created with Previous Versions of the Denodo Platform
- Authentication in Web Services Created with Previous Versions
- Types Conversion Table for REST / SOAP Web Services Created with Previous Versions
- Invoking Web Services Created with Previous Versions
- Useful Tools to Debug Issues with Active Directory or Other LDAP Servers
- Single User Mode
- Resource Manager: Available Fields to Evaluate a Rule
- Values of the Attribute “Access Interface”
- Avoiding SQL Injections
- Enabling the Support for ODBC Sources When an External JRE is Used
- Virtual DataPort Developer Guide
- Preface
- Introduction
- Access Through JDBC
- Access Through ODBC
- Access Through an ADO.NET Data Provider
- Access Through OLE DB
- Developing Extensions
- Custom Policies
- Appendix
- Virtual DataPort VQL Guide
- Preface
- Introduction
- General Overview of Virtual DataPort
- Language for Defining and Processing Data: VQL
- Generating Wrappers and Data Sources
- Creating Data Sources
- JDBC Data Sources
- ODBC Data Sources
- Multidimensional Data Sources
- Data Sources for Web Services
- XML Data Sources
- JSON Sources
- DF Data Sources
- Denodo Aracne Data Sources
- Google Search Data Sources
- LDAP Data Sources
- BAPI Data Sources
- Salesforce Data Sources
- Custom Data Sources
- Data Source Configuration Properties
- Specifying Paths in Virtual DataPort
- Creating Wrappers
- Execution Context and Interpolation Strings
- Wrapper Metadata
- JDBC Wrappers
- Multidimensional Databases Wrappers
- ODBC Wrappers
- WWW Wrappers
- Web Services Wrappers
- XML Wrappers
- JSON Wrappers
- DF Wrappers
- Denodo Aracne Wrappers
- Google Search Wrappers
- LDAP Wrappers
- BAPI Wrappers
- Salesforce Wrappers
- CUSTOM Wrappers
- Wrapper Configuration Properties
- Valid Conversions Between Types in Wrappers and VDP Types
- QUERY WRAPPER Statements
- Creating Data Sources
- Creating a Base View
- Queries: SELECT Statement
- Defining a Derived View
- Defining the Statistics of a View
- Materialized Tables
- Temporary Tables
- Remote Tables
- Inserts, Updates and Deletes Over Views
- Refreshing Views
- Transactions in Virtual DataPort
- Stored Procedures
- Importing a Stored Procedure
- Use of Stored Procedures
- Predefined Stored Procedures
- CACHE_CONTENT
- CATALOG_ELEMENTS
- CATALOG_FKS
- CATALOG_METADATA_VIEWS
- CATALOG_PERMISSIONS
- CATALOG_PKS
- CATALOG_VDP_METADATA_VIEWS
- CATALOG_VIEWS
- CLEAN_CACHE_DATABASE
- COLUMN_DEPENDENCIES
- COMPACT_HADOOP_CACHE
- COMPACT_METADATA_TABLES
- CREATE_REMOTE_TABLE
- DROP_REMOTE_TABLE
- DUAL
- GENERATE_SMART_STATS_FOR_FIELDS
- GENERATE_SMART_STATS_FOR_FIELDS_BY_TABLENAME
- GENERATE_STATS
- GENERATE_STATS_FOR_FIELDS
- GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW
- GET_ACTIVE_LOGGERS
- GET_ASSOCIATIONS
- GET_CACHE_COLUMNS
- GET_CACHE_CONFIGURATION
- GET_CACHE_TABLE
- GET_CATALOG_EFFECTIVE_PERMISSIONS
- GET_CATALOG_METADATA_WS
- GET_DELEGATED_SQLSENTENCE
- GET_ELEMENTS
- GET_EXPORTED_KEYS
- GET_FOREIGN_KEYS
- GET_JDBC_DATASOURCE_TABLES
- GET_PRIMARY_KEYS
- GET_PROCEDURE_COLUMNS
- GET_SERVER_CONNECTIVITY
- GET_SESSIONS
- GET_SOURCE_CHANGES
- GET_SOURCE_COLUMNS
- GET_SOURCE_TABLE
- GET_TYPE_ATTRIBUTES
- GET_USER_DEFINED_TYPES
- GET_VIEW_COLUMNS
- GET_VIEW_INDEXES
- GET_VIEW_STATISTICS
- GET_VIEWS
- LIST_JDBC_DATASOURCE_TABLES
- LOGCONTROLLER
- MIGRATE_DATE_TYPES
- PING_DATA_SOURCE
- SOURCE_CHANGES
- VIEW_DEPENDENCIES
- WAIT
- WEBCONTAINER_ELEMENTS
- WEBCONTAINER_ELEMENT_STATUS
- WRITELOGERROR
- WRITELOGINFO
- Defining Other Elements of the Catalog
- Creating Databases, Users, Roles and Access Privileges
- Describing Catalog Elements
- Listing Elements in the Catalog
- Removing Elements from the Catalog
- Publication of Web Services
- Publication of Widgets
- RESTful Architecture
- Help Command
- Version Control Systems Integration Commands
- Resource Manager
- Advanced Characteristics
- Management of Compound Values
- Changing Settings of Virtual DataPort and the Web Container
- Dynamic Choice of Join Strategy
- Using the Cache
- Configuring Swapping Policies
- Managing Internationalization Configurations
- Execution Context of a Query and Interpolation Strings
- Adding Variables to Selection Conditions (GETVAR and SETVAR)
- Appendix
- Data Catalog Guide
- Preface
- Introduction
- Installation and Execution
- Authentication and Authorization
- Administration
- Configuration
- Browse
- Saved Queries
- Search
- Appendix
- Diagnostic & Monitoring Tool Guide
- Virtual DataPort API Javadoc
- Scheduler Administration Guide
- Preface
- Introduction
- General Architecture
- Installation and Execution
- Administration
- Creating and Scheduling Jobs
- Jobs
- Data Sources
- Filter Sequences
- Configuring New Jobs
- General Structure of a Job
- Aracne-type Job Extraction Section
- VDP Extraction Section
- ITP Extraction Section
- JDBC Extraction Section
- VDPCache Extraction Section
- VDPIndexer Extraction Section
- Data Schema Generated by the Different Types of Extraction Jobs
- Jobs for Maintaining Aracne Indexes
- Postprocessing Section (Exporters)
- Retry Section
- Handler Section
- Time-based Job Scheduling Section
- Dependencies Among Jobs
- Developer API
- Appendix
- Scheduler API Javadoc
- ITPilot User Guide
- Preface
- Introduction
- Distribution of Environments
- Installation and Initial Configuration
- Execution
- Web Administration Tool
- Verification Server Graphical Configuration and Monitoring Tool
- Wrapper Execution Trace Logs
- ITPilot Generation Environment Guide
- Preface
- Introduction
- Installation and Execution
- Generation Environment Tools - Part I
- Generation Environment Tools - Part II
- Extracting Multipaginated Data
- Access to Details Pages
- Access to the Details Page: Using Extractor Sequence
- Individual Test of Extractor Sequence, Next Interval Iterator and Form Iterator Components
- Specifying the Structure of the Detail Page Information
- Generating the Access Specification to the Details Page
- Iteration on the Details Page Structures and Creation of the Output Record
- Generation Tool Global Preferences
- Tagsets and Scanners
- Generating the Data Extraction Specifications Manually
- Using the Sequence Debugger
- Saving a Flow as a Custom Component
- Wrapper Advanced Options: Specific Browser Pool and Locale
- Migrating Wrappers Between Generation Environments: Import and Export
- Managing Extensions
- Generating Navigation Sequences
- Appendix A: ITPilot Operators
- Appendix B: ITPilot Functions
- Appendix C: Catalog of Components
- Add Record To List
- Condition
- Using the Conditions Editor
- Create List
- Create Persistent Browser
- Diff
- Execute JavaScript
- Expression
- Extractor
- Extractor Sequence
- Filter
- Form Iterator
- Get Page
- INIT
- Iterator
- JDBC Extractor
- Loop
- Next Interval Iterator
- Output
- Record Constructor
- Release Persistent Browser
- Repeat
- SaveFile
- Script
- Sequence
- Appendix D: Constraints of the Simplified DOM
- Appendix E: List of Reserved Words
- ITPilot Developer Guide
- ITPilot DEXTL Guide
- Preface
- Introduction
- An Overview of DEXTL
- Basic Syntax
- Advanced Syntax
- DEXTL Quick Reference Sheets
- Putting All Together
- ITPilot NSEQL Guide
- Preface
- Introduction
- Basic Concepts of NSEQL
- List of NSEQL Commands
- Usual Parameters
- Error Parameters
- Navigation Commands
- Commands for Processing Links
- Commands for Selecting Forms
- Commands for Executing Actions on Elements of a Form
- Frame Selection Commands
- Commands for Selecting Elements
- Commands for Executing on Actions on Elements
- Commands for Handling Windows
- Commands for Handling Pop-Up Dialogs
- Commands for Editing the Browser Properties
- Informative Commands
- Conversion Commands
- Commands for Saving Files
- Commands for Executing Code
- Commands for Clearing Browser Data
- Util Functions
- ITPilot API Javadoc
- Solution Manager Installation Guide
- Preface
- Preinstallation Tasks
- Using the Graphical Installation Wizard
- Using the Command Line Installer
- Unattended Installation of the Solution Manager
- Post-Installation Tasks
- Install the Latest Update
- Change the Default Passwords
- Install the License
- Enable SSL/TLS in the Solution Manager
- Configure Windows Services
- Installing the Solution Manager Web Applications as Windows Services
- Post-Installation Tasks: Virtual DataPort
- High Availability
- Disable “Export” Endpoint of the Web Container
- Denodo Platform Control Center
- Appendix
- Default Ports Used by the Solution Manager Modules
- Using Kerberos Authentication in Virtual DataPort Without Joining a Kerberos Realm
- Using Kerberos Authentication in Solution Manager Without Joining a Kerberos Realm
- Providing a Krb5 File for Kerberos Authentication
- Launching the Denodo Standalone Applications in High DPI Displays
- Troubleshooting the Solution Manager Installer
- Transparent Metadata Encryption in the Solution Manager
- Configuring the Network Interface Restriction in the Solution Manager
- Solution Manager Administration Guide
- Preface
- Introduction
- Launching the Solution Manager Components
- Introducing the Solution Manager Administration Tool
- Authentication and Authorization
- Environments
- Clusters
- Servers
- Load Balancing Variables
- Promotions
- License Management
- Monitoring
- Configuration
- Import and Export Catalog
- Appendix
- REST API
- Get the List of Environments
- Create an Environment
- Get the List of Licenses Available
- Update an Environment
- Delete an Environment
- Get the List of Virtual DataPort Properties Associated to an Environment
- Create and Delete Environment Properties
- Get the List of Clusters
- Create a Cluster
- Get a Cluster
- Update a Cluster
- Delete a Cluster
- Get the List of Scheduler Properties Associated to a Cluster
- Create and Delete Cluster Properties
- Get the List of Servers
- Create a server
- Get a Server
- Update a Server
- Delete a Server
- Get the List of Revisions
- Create a Revision from a VQL file
- Get the List of Deployments
- Start a New Deployment from a List of Revisions
- Get the Progress of a Deployment
- Free License Usage
- Ping License Manager Server
- Ping to Solution Manager Server
- Best Practices: Deployment of Updates Across Your Organization
- Solution Manager Compatibility with the Denodo Platform Servers
- How To Initialize a Git Repository
- REST API
- Web Panel Guide
- Denodo4E User Guide
-
DenodoConnect Components
- Custom Handler Email Exported Files - User Manual
- Denodo Cloud Cache Load Bypass Stored Procedure - User Manual
- Denodo Custom Wrapper for IBM Cognos TM1 - User Manual
- Denodo Custom Wrapper for SAS - User Manual
- Denodo Distributed File System Custom Wrapper - User Manual
- Denodo Dynamics 365 Business Central Templates - Quick Use Guide
- Denodo Dynamics 365 Customer Engagement Templates - Quick Use Guide
- Denodo FileSystem CustomWrapper - User Manual
- Denodo GeoJSON Service - User Manual
- Denodo Google Sheets Custom Wrapper - User Manual
- Denodo Google Sheets Tool - User Manual
- Denodo Governance Bridge - User Manual
- Denodo GraphQL Service - User Manual
- Denodo HBase CustomWrapper - User Manual
- Denodo Hibernate Dialect - User Manual
- Denodo Incremental Cache Load Stored Procedure - User Manual
- Denodo Kafka Custom Wrapper - User Manual
- Denodo Log Custom Wrapper - User Manual
- Denodo Model Bridge - User Manual
- Denodo MongoDB Custom Wrapper - User Manual
- Denodo Monitor Reports - User Manual
- Denodo OData 2.0 Service - User Manual
- Denodo OData2 Custom Wrapper - User Manual
- Denodo OData4 Custom Wrapper - User Manual
- Denodo Power BI Custom Connector - User Manual
- Denodo RFCReadTable Custom Wrapper - User Manual
- Denodo Replicator - User Manual
- Denodo SFTP Exported Files Custom Handler - User Manual
- Denodo SSH Custom Wrapper - User Manual
- Denodo SalesForce REST Custom Wrapper - User Manual
- Denodo ServiceNow Templates - Quick guide
- Denodo Tableau Exporter - User Manual
- Denodo Templates for Twitter - Quick Use Guide
- Denodo Testing Tool - User Manual
- Denodo XSLT Mapper - User Manual
- Denodo XtraFuncs - User Manual
- Generic XML Exporter - User Manual
- Denodo Express Quick Start Guide
- Denodo Platform Container QuickStart Guide
- Denodo Platform for AWS Free Trial BYOL Quick Start Guide
- Denodo Platform for AWS Quick Start Guide
- Denodo Platform for Azure BYOL Quick Start Guide
- Denodo Platform for Azure Free Trial BYOL Quick Start Guide
- Denodo Platform for Azure Quick Start Guide
- Denodo Platform for GCP Free Trial BYOL Quick Start Guide
- Denodo Platform for GCP Quick Start Guide
community
Denodo Platform 7.0
- User Manuals /
- ITPilot Generation Environment Guide /
- Generation Environment Tools - Part I /
- Wrapper Generation, Tests and Exporting