Virtual DataPort Administration Guide¶
Table of Contents
- 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
- Primary Keys of Views
- Associations
- RESTful Web Service
- Denodo OData 4.0 Service
- Serving Metadata
- Querying Data: The Basics
- Navigating Associations
- Advanced Querying
- Pagination
- Configuration
- Entity Collection Streaming
- Debug Option
- Privilege Requirements
- Limitations
- Features
- 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
- Global Settings of REST Web Services
- 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
- VCS Configuration
- VCS Integration Features
- Scenarios and Recommended Uses
- Best Practices When Using the Integration with a VCS
- Uniqueness Detection
- LS Optimization for Subversion
- 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
- Using JavaTM VisualVM
- General Information on the Server
- Information on Data Sources
- Information on the Cache
- Information and Events on Catalog Access (DDL Statements)
- Information and Events on the Running of Statements
- Information and Events on Transactions
- Setting the User Agent of an Application
- Denodo Monitor
- Monitoring with a Java Management Extensions (JMX) Agent
- Cluster Architectures / Server Backup
- Bulk Data Load
- Optimizing Queries
- Optimizing DF Data Sources
- Optimizing Join Operations
- Automatic Simplification of Queries
- Cost-Based Optimization
- Enabling the Cost-Based Optimization
- Gathering the Statistics of Views
- Tuning the Cost-Based Optimization Process
- Estimating the Cost of Queries on Data Sources
- Estimating Post-Processing Costs
- Specifying Indexes
- Tuning the Imported Indexes Information for Oracle
- Tuning the Imported Indexes Information for MySQL
- Tuning the Imported Indexes Information for Informix
- Tuning the Imported Indexes Information for Teradata
- Tuning the Imported Indexes Information for Netezza
- Tuning the Imported Indexes Information for Redshift
- Tuning the Imported Indexes Information for Greenplum
- Tuning the Imported Indexes Information for Hive
- Tuning the Imported Indexes Information for Other Data Sources
- Data Source I/O Parameters
- Current Limitations of the Cost-Based Optimization Process
- Data Movement
- Parallel Processing
- 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