community

Q&A
KB
USER MANUALS
VIDEOS
TUTORIALS
EXPRESS
DRIVERS
- Overview
- JDBC
- ODBC
FREE TRIAL

SIGN IN

community

Denodo Platform 6.0

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 and Its Updates
- Postinstallation Tasks
- Installing Updates and Hotfixes
  - Installing an Update or Hotfix Graphically
  - Installing an Update or Hotfix from the Command Line
- Denodo Platform Control Center
- Appendix
Denodo Platform Migration Guide
- Preface
  - Scope
  - Who Should Use This Document
- Outline of the Migration Process
- Before Installing a New Version of the Denodo Platform
- 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
Denodo Platform New Features Guide
- Preface
  - Scope
  - Audience
- Installer
- Common to All Modules
- Virtual DataPort
- Embedded Web Container
  - New Version of the Web Container: Apache Tomcat 8
  - Tomcat Uses One More Port
Virtual DataPort Administration Guide
- Preface
  - Scope
  - Who Should Use This Document
  - Summary of Contents
- Introduction
- General Architecture
  - Physical Layer
  - Logical Layer
    - Data Module: Cache
  - User Layer
- Installation and Execution
  - Launching the Virtual DataPort Server
  - Launching the Virtual DataPort Administration Tool
- Creating Views
  - Access to the Graphic Administration Tool
  - Importing Data Sources and Creating Base Views
  - Creating Derived Views
  - Materialized Tables
  - Temporary Tables
  - Querying Views
    - Execution Trace of a Statement
  - Editing / Replacing a View
    - Views Affected by Modifications
  - Advanced Configuration of Views
- Stored Procedures
  - Importing Stored Procedures
  - Executing Stored Procedures
  - Use of Stored Procedures in Creating Views
- Publication of Web Services
  - Publishing SOAP Web Services
  - Publishing REST Web Services
  - XSLT Transformations
  - Web Services Authentication
  - How Web Services Query the Virtual DataPort Server
  - Connection from the Web Services to the Server
  - Web Service Container Status Table
  - Invoking the Exported Web Services
    - Invoking Web Services with SAML Authentication
    - Types Conversion Table for REST / SOAP Published Web Services
- Publication of Views as Widgets
  - Publish a View as a Widget
  - Auxiliary Web Services
  - Export to JSR-168 or JSR-286 Portlet
  - Export as Microsoft Web Part
  - Deployment of a Microsoft Web Part
- RESTful Architecture
  - Primary Keys of Views
  - Associations
  - RESTful Web Service
- JMS Listeners
  - Creating a New JMS Listener
  - Who Can Create JMS Listeners
- 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
    - Restricted Mode
    - Unicode Mode
  - Kerberos Authentication
  - SAML Authentication
  - Privileges: Global Settings
    - The FILE Privilege
    - Privileges of Users with the Role “serveradmin”
- Memory Management
  - Streaming Vs Non-Streaming Operators
  - Swapping Parameters
  - Limit the Maximum Amount of Memory of a Query
  - Edge Cases in Streaming Operation
  - Cache Load Processes
- Resource Manager
  - Defining a Plan
  - Defining a Rule
- Exporting and Importing the Server Metadata
  - Exporting the Server Metadata
  - Exporting and Importing Elements Across Different Environments
    - Exporting Environment-Dependent and Independent Elements to Different Files
    - Export to a File with Properties
  - Importing Metadata into a Server
- Importing Extensions
- Cache Module
  - Generic Support for Other Databases
  - Cache Modes
  - Cache Maintenance Task
    - Maintaining the Underlying Database
- Version Control Systems Integration
  - VCS Configuration
  - VCS Integration Features
  - Scenarios And Recommended Uses
  - Best Practices When Using the Integration with a VCS
    - Tagging and Branching Releases
    - Recommendations for the Testing Environment
  - Uniqueness Detection
    - Enabling Uniqueness Detection
    - Examples
  - LS Optimization for Subversion
    - Activating the LS Optimization
    - Tested Environments
- Databases, Users and Access Rights in Virtual DataPort
  - Databases in Virtual DataPort
  - User and Access Right in Virtual DataPort
  - Administration of Databases, Users, Roles and Their Access Rights
- Monitoring the Virtual DataPort Server
  - Monitoring with a Java Management Extensions (JMX) Agent
  - Denodo Monitor
- Cluster Architectures / Server Backup
  - Denodo Tools
  - How to Check If a Virtual DataPort Server Is Alive
  - Using the Import/Export Scripts for Backup And/or Replication
    - Export Script
    - Import Script
  - Configuring Several Instances of a Virtual DataPort Server
    - How to Configure the Slave Instances
- Bulk Data Load
  - Amazon Redshift
  - DB2
  - Impala
  - Oracle
  - Snowflake
  - Microsoft SQL Server
  - Teradata
  - Settings of the Generation of the Temporary Files
- Optimizing Queries
  - Optimizing DF Data Sources
  - Optimizing Join Operations
  - Automatic Simplification of Queries
  - Cost-Based Optimization
  - Data Movement
- Appendix
  - Supported JDBC Data Sources
  - Mapping Multidimensional Data to a Relational Model
  - Considerations When Configuring Data Sources with Pass-Through Credentials
  - Configuring the Logging Engine
  - 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
  - Allow URIs with Slash and Backslash in Apache Tomcat
  - Useful Tools to Debug Issues with Active Directory or Other LDAP Servers
  - Single User Mode
    - Explicit Single User Mode
    - Automatic Single User Mode
  - Resource Manager: Available Fields to Evaluate a Rule
    - Examples of Resource Manager Rules
  - Values of the Attribute “Access Interface”
  - Avoiding SQL Injections
Virtual DataPort Developer Guide
- Preface
- Introduction
  - Examples
- Access Through JDBC
- Access Through ODBC
- Access Through an ADO.NET Data Provider
  - Using Kerberos Authentication
- Access Through OLE DB
- Developing Extensions
- Custom Policies
  - Developing a Custom Policy
- Appendix
Virtual DataPort VQL Guide
- Preface
  - Scope
  - Who Should Use This Document
  - Summary of Contents
- Introduction
- General Overview of Virtual DataPort
  - Creating or Defining Data
  - Executing Statements
- Language for Defining and Processing Data: VQL
  - Data Types
    - Internationalization
  - Statements
  - Unicode Identifiers
  - Logical Operators
  - Comparison Operators
    - Comparing Literals
    - Three-valued Logic
  - Functions for Conditions and Derived Attributes
  - Syntax Conventions
    - Syntax of Functions and Condition Values
  - Comments
- Creating a Base View
  - Query Capabilities: Search Methods and Wrappers
  - Modifying a Base View
- Queries: SELECT Statement
  - FROM Clause
  - WITH Clause
  - SELECT Clause
    - Derived Attributes
  - WHERE Clause
    - Conditions with Compound Values
  - Group BY Clause
    - Use of Aggregation Functions
  - HAVING Clause
  - UNION Clause
    - Specifying Projections in UNION Queries
  - ORDER BY Clause
  - OFFSET, FETCH and LIMIT
  - CONTEXT Clause
  - TRACE Clause
  - CASE Clause
- Defining a Derived View
  - Modifying a Derived View
  - Defining an Interface View
- Defining the Statistics of a View
- Materialized Tables
  - Creating Materialized Tables
  - Inserting Data Into Materialized Tables
- Temporary Tables
  - Creating Temporary Tables
- Inserts, Updates and Deletes Over Views
  - INSERT Statement
  - UPDATE Statement
  - DELETE Statement
  - Return Modified Rows
    - Limitations
  - Use of WITH CHECK OPTION
- Transactions in Virtual DataPort
- Stored Procedures
  - Importing a Stored Procedure
  - Use of Stored Procedures
  - Predefined Stored Procedures
- Defining Other Elements of the Catalog
  - Creating Folders
  - Defining a Data Type
  - Defining a Map
  - Defining JAR Extensions
  - Definining JMS Listeners
- Creating Databases, Users, Roles and Access Privileges
  - Creating and Modifying Virtual DataPort Databases
  - Creating Users
- Describing Catalog Elements
  - Exporting Metadata
  - Importing Metadata
- Listing Elements in the Catalog
- Removing Elements from the Catalog
- Publication of Web Services
  - Creating New SOAP Web Services
  - Creating New REST Web Services
  - Connection Parameters
  - Web Services Authentication
    - Basic and Digest
    - Basic LDAP
    - SAML
    - VDP
    - WSS
  - Embedded Web Container Management
  - Deploying and Exporting SOAP and REST Web Services
- Publication of Widgets
  - Create New Widgets
  - Export a Widget
  - Deployment and Export of Auxiliary Web Services
- RESTful Architecture
  - Associations
  - Navigational Queries
- Help Command
- Generating Wrappers and Data Sources
  - Valid Conversions Between Types in Wrappers and VDP Types
    - Native-type Conversions of a Wrapper to Java Types
    - Filters
  - Creating Data Sources
  - Creating Wrappers
  - Query WRAPPER Statements
- Version Control Systems Integration Commands
  - Statements to Work with Centralized Version Control Systems
    - VCSCOMMIT
    - VCSUPDATE
    - VCSCONTENTS
    - VCSSHOW
    - REVISIONS
  - Statements to Work with GIT
  - Commands for Environment Management
  - Other Version Control Commands
    - VCSDISCARD
- Resource Manager
  - Managing the Plans of the Resource Manager
  - Managing the Rules of the Resource Manager
- Advanced Characteristics
  - Management of Compound Values
    - Processing of Compound Types: Example
  - Dynamic Choice of Join Strategy
  - Using the Cache
    - Cache Invalidation
    - Displaying the Contents of the Cache
  - Configuring Swapping Policies
  - Managing Internationalization Configurations
    - Replacing an I18n Map
    - Deleting an I18n Map
  - Execution Context of a Query and Interpolation Strings
  - Adding Variables to Selection Conditions (GETVAR and SETVAR)
- Appendix
  - Syntax of Condition Functions
  - Syntax of Search Expressions for the Contains Operator
  - Support for the Contains Operator of Each Source Type
    - Aracne
    - Google Search
  - CASE Clause Examples
  - Date and Time Pattern Strings
  - Web Services Created with Previous Versions of the Denodo Platform
Information Self-Service Tool Guide
- Preface
- Introduction
- Installation and Execution
  - Launching the Information Self-Service Tool
- Authentication And Authorization
- Configuration
- Databases
- Saved Queries
  - Deploying Saved Queries
  - Copying Saved Queries
- Appendix
  - Installing the Information Self-Service Tool on a Cluster: Sharing the Same Settings Across All the Nodes
    - Setting Up the Common Database
    - Configure the Information Self-Service Tool to Use the Common Database
Diagnostic & Monitoring Tool Guide
- Preface
- Introduction
- Installation and Execution
  - Launching the Monitoring and Diagnostic Tool
- Architecture
- Authentication and Authorization
  - Kerberos Authentication
- Creating Servers and Environments
  - Creating Servers
  - Creating Environments
- Monitoring
- Creating Diagnostics and Diagnostic Intervals
  - Creating Diagnostics
  - Creating Diagnostic Intervals
- Diagnosing
- Export and Import
  - Export
  - Import
- Configuration
Virtual DataPort API Javadoc
Scheduler Administration Guide
- Preface
- Introduction
- General Architecture
- Installation and Execution
- Administration
- Creating and Scheduling Jobs
- Developer API
  - Scheduler Client API
  - Extensions (Plugins)
- Appendix
Scheduler API Javadoc
Aracne Administration Guide
- Preface
- Introduction
- General Architecture
- Installation and Execution
- Administration
- Denodo Aracne API - Search/Indexing
  - Most Relevant Terms of a Document
  - Extensions
    - Creating New Functions for Regular Expressions
- Appendix
  - Apache Lucene Search Syntax
  - Use of the Import/Export Scripts for Backup
Aracne API Javadoc
ITPilot User Guide
- Preface
- Introduction
  - Denodo ITPilot Environments
- 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
  - Presentation
  - Development of Component-Based Wrappers
- Installation and Execution
  - Introduction to the Tools
- Generation Environment Tools - Part I
- Generation Envirtonment Tools - Part II
- Generating Navigation Sequences
- Appendix A: ITPilot Operators
  - Logical Operators
  - Comparison Operators
- Appendix B: ITPilot Functions
- Appendix C: Catalog of Components
- Appendix D: Constraints of the Simplified DOM
- Appendix E: List of Reserved Words
ITPilot Developer Guide
- Preface
- Introduction
- ITPilot Development API
- Connecting to the Server
- Creating Custom ITPilot Functions
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
- Util Functions
  - EncodeSEQ
ITPilot API Javadoc
Denodo4E User Guide
- Preface
- Installing Denodo4E
- VDP/ITP Server Tutorial
- Wrapper Generation Tool Tutorial
- Reference of the Dialogs of the Denodo4E Plugin
Denodo Connects Manuals
- Custom Handler Email Exported Files - User Manual
- Denodo Cloud Cache Load Bypass Stored Procedure - User Manual
- Denodo Dashboard - User Manual
- Denodo Distributed File System Custom Wrapper - User Manual
- Denodo Domino Reader 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 Tool - User Manual
- Denodo Governance Bridge - 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 MapReduce 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 OData 4.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 Scheduler 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 for AWS Quick Start Guide
Denodo Platform for Azure Quick Start Guide

To see the latest version of the document click here

User Manuals »
Denodo SalesForce REST Custom Wrapper - User Manual

Denodo SalesForce REST Custom Wrapper - User Manual

Denodo Site
Support Site
Partner Portal
Contact Us
Terms of Use
Privacy & Cookies Policy
© Denodo Technologies