Preface
Additional Information and Support
Introducing Software AG Presto
Real-Time Intelligence
How Does Presto Meet This Challenge?
Presto Artifacts: A 'Black Box' View of the Flow of Information
Presto Core Components
Tools and Users for Presto Hub and the AppDepot
Presto Hub
Presto Enterprise AppDepot
Presto Server
Presto Repository
Presto Analytics In-Memory Stores
Presto APIs, Specifications and Extension Points
Enterprise Mashup Markup Language: The Mashup Domain Language
Real-Time Analytics Query Language
View API and Framework
Presto Add-Ons
Presto Real-Time Analytics Add-On with Terracotta BigMemory
Presto Mobile
Presto Add-On for SharePoint
Presto Add-On for Excel
Presto Add-On for Portals
Presto concepts
What is ...? Why can't I?
Wires concepts
View concepts
Mashboard concepts
Working in Presto Hub
Presto Hub Features
Your Presto Hub Profile
Manage Your Presto User Attributes
Manage Your Locale and Account Information
Reset Your Password
Find and Open Mashables, Mashups and Apps in Presto Hub
Common Tasks for Mashables, Mashups and Apps
Add Feedback
Add or Update Meta Data: Description, Category, Provider and Tags
Add or Update Custom Attributes
Add a Thumbnail
Change the Artifact Name
Change an Artifact’s Locale
Change the Status
Feature or Unfeature
Add to Favorites or Bookmark
Delete
Review Dependencies
Share With Other Users
Export Results to CSV
Update Mashables, Mashups or Apps in Bulk
Find and Select Multiple Artifacts for Update
Find and Select Artifact Dependencies
Add To or Remove Multiple Artifacts From Favorites
Update the Category, Provider or Tags in Bulk
Change the Status of Multiple Artifacts
Delete Multiple Artifacts
Update Run Permissions for Multiple Artifacts
Update Caching for Multiple Mashables or Mashups
Feature or Unfeature Multiple Artifacts
Descriptions, Providers, Categories and Tags for Artifacts
Category
Description
Provider
Tags
Grant Permission to Run Mashables, Mashups and Apps
Grant Run Permissions for One Artifact
Find Users and Groups for Permissions
Choose Presto Built-In Groups for Permissions
Grant Run Permissions to an Artifact’s Dependencies
Grant Run Permissions to Published Apps in the AppDepot
Mashables
Types of Mashable Information Sources
Database Mashables
Database Mashable Support and Limitations
Database Mashable Names versus Database Names
Database Mashable Name Changes
Database Characters and Names That Are Not Supported
Default Operations Available for Database Mashables
Arbitrary SQL Queries for Database Mashables
Built-in Finders for Arbitrary Queries
Custom Queries
Database Mashables Responses
MashZone Feeds
REST Web Services
GET-Based REST Web Services
POST-Based REST Web Services
Snapshot Mashables
Spreadsheet Mashables
Valid Labels and Values for Spreadsheet/CSV Mashables
Syndicated Feeds (RSS/Atom)
Normalization and Presto Support for RSS/Atom Formats
WSDL Web Services
WSDLs for SOAP Web Services
Security Policies and Configuration
WSDL Web Service Responses
Web Services Security (WSS) for WSDL Services
Built-in WSS Support for Policies and Policy Attachments
Built-in WSS Support for Policy Assertions and Tokens
Built-in WSS Support for Certificates and Encryption
Connect Information Sources as Mashables
Register Syndicated Feeds (RSS/Atom)
Register REST Web Services
REST Web Service URLs with Parameters
REST Web Services with Input Documents
Specify HTTP Request Headers
Register WSDL Web Services
Register Spreadsheets as Mashables
Register an Excel Worksheet File from Presto Hub
Register an Excel Worksheet With a URL from Presto Hub
Register XML Mashables
Register CSV Mashables
Register Basic Database Mashables
Register Custom Database Mashables
Enabling/Disabling Data Alteration Operations and Other Security Considerations
Viewing Details for Tables, Views or Stored Procedures
Removing Tables, Views or Stored Procedures from the Mashable
Removing Columns for Table or View Operations
Changing Column Names or Datatypes for Tables or Views
Removing Table or View Finders
Changing Finders for Tables or Views
Adding Finders for Tables or Views
Register SharePoint Lists
Register a Snapshot as a Mashable
Subscribe to Events from the Event Bus or Apama
Create or Edit MashZone Feeds
Edit an Existing MashZone Feed
Create a New MashZone Feed
Mashable Authentication with Security Profiles
HTTP Basic Authentication
CAS2 Authentication
NTLM Authentication
SSL Authentication
SSO Authentication
Custom Security Profiles
Using Presto Global or User Attributes in Security Profiles
Configure Secure Connections for Mashables
Implement a Custom Security Profile Client
Register a Custom Security Profile
Configure HTTP Request Headers
REST Web Services
GET-Based REST Web Services
POST-Based REST Web Services
Running Mashables or Mashups and Other Tasks
Run and Preview Mashable/Mashup Data
Valid Date Formats for Presto Mashables and Mashups
Update Mashable Endpoints
Update Mashable Security Profiles
Setting a Character Encoding for a Mashable
Take, View or Delete Snapshots
Take a Snapshot
Find and View Snapshots
View Snapshot Results in XML or JSON
Delete a Snapshot
Schedule Snapshots
Schedule Snapshot Jobs
Delete Snapshot Scheduled Jobs
Freeform Dashbording
Display dashboards in Presto Freeform
Use interactive filter in Freeform dashboard
Manage dashboards in Presto Freeform
Create a dashboard
Edit a dashboard
Edit dashboard properties
Delete a dashboard
Manage dashboard permissions
Change dashboard style template
Create dashboard style templates
Edit style templates of Presto Freeform
Configure dashboard views in Presto Freeform
Add views in a dashboard
Delete views in a dashboard
Configure dashboard views
Configure dashboard components in Presto Freeform
Insert components in a dashboard
Insert Line Charts in a dashboard
Insert Column Charts in a dashboard
Insert Pie Charts in a dashboard
Insert Table in a dashboard
Insert Speedometer Charts in a dashboard
Insert Drop-down box in a dashboard
Insert Input field in a dashboard
Insert Presto Apps in a dashboard
Insert Presto Mashups in a dashboard
Insert Image in a dashboard
Insert Label in a dashboard
Assign data sources to dashboard components
Assign data sources to Line chart
Assign data sources to Column chart
Assign data sources to Pie chart
Assign data sources to Grid
Assign data sources to Speedometer chart
Assign data sources to Presto App
Assign data sources to Presto Views
Assign data sources to Combobox
Assign data sources to Label
Create Input Parameters
Move components to front or back
Hide component header and border
Resize dashboard components
Copy and past components in dashboard
Define filters for dashboard components
Delete components from dashboard
Customize desktop in Presto Freeform
Set display size
Set grid lines
Exporting Dashboards
Importing Dashboards
Mashups in Presto Wires
Wires Features
Creating Mashups in Wires
Add a Mashup or Mashable as an Information Source
Add a Web Information Source with DirectInvoke
Add SharePoint Information Sources
Add a SharePoint List or List View to a Mashup
Add Results from a SharePoint Search or FAST Search to a Mashup
Add a Mashup or Mashable in a Loop
Preview Results
About Results in Wires
Stop Running a Block
Add Actions or Other Blocks
Aggregate Statistics
Add Input Fields Directly to Block Properties
Average Results
Count Results
Connecting Input Blocks to Block Properties in the Wires Canvas
Selecting Existing Input Blocks for Block Properties
Format Results as CSV
Decorate or Transform Data
Build Dates
Create a Document for Input
Add Fields or Structure Nodes
Map Other Results to the Output
Enter or Calculate Data
Adapt Results as a SharePoint External Content Type
Create an ECT-Enabled Mashup
Supported SharePoint Operations
Data Requirements for the Results of ECT-Enabled Mashups
ECT Block Properties
Updates to the Mashup’s Results
Extract Partial Results
Filter Results
Filtering Techniques
Group Results
Set Conditions to Filter Items to Include in Groups
Add Calculations for the Group
Group Configuration Example
Add Input Parameters
Automatically Add Input Fields for Block Properties
Select an Existing Input Block for Block Properties
Manually Add and Connect Input Blocks to Block Properties
Join Results
Fine Tune the Joined Result
Upgrading Mashups with Join Blocks from Previous Versions
Map Results to Known Structures
Enter or Calculate Data
Merge Results
Properties for Web Feed Sources
Properties for Sources That Are Not Web Feeds
Merge SharePoint Lists
Strip Namespaces
Run Several Blocks Simultaneously
Pivot Data
Analyze Datasets with RAQL Queries
Dynamic RAQL Queries in Wires
Select Fields
Add an Item to a SharePoint List
Run a SQL Statement
Using Input Parameters as SQL Query Parameters
Build Strings
Sort Results
Transform Results
Drag Input Nodes to Add Nodes to the Output
Manually Add Fields or Structure Nodes
Map Input Nodes to the Output
Enter or Calculate Data
Built-in Functions for Decorator, Mapper and Transformer Blocks
Absolute
Add
Add to Date
Ceiling
Concatenate
Currency Value
Date Formatter
Date from Days
Date from Seconds
Distance Between Geo Points
Divide
Encode URI
Floor
Join With
Multiply
Not
Round
Set Decimal Places
String Matches
String Replace
Substring
Substring After
Substring Before
Subtract
Subtract from Date
To Boolean
To Camel-Case
To Date
To Datetime
To Decimal
To Integer
To Lower-case
To Number
To String
To Title-Case
To Upper-case
Build URLs
Copy and Update a URL
Provide the Complete URL Dynamically
Build a URL from Components
Select Fields or Paths for Block Properties with the Path Selector
Use Presto Global or User Attributes in Block Properties
Changing Mashup Input Parameter Names
Valid Input Parameter Names
Add If/Else Conditions
Set Execution Conditions
Execution Condition Limitations
If/Else Examples
Add HTTP Headers to a Mashup
Advanced Properties: Controlling Blocks
Define Error Handling
Handle Empty Fields for WSDL Web Services
Use a Security Profile with DirectInvoke
Customizing the Selection XPath for Merge
Connect Mashup Blocks
Advanced Updates with the Output Block
Quickly Set All Inputs for the Mashup
Change the Mashup Result Character Encoding
Symbols to Escape in Block Properties
Date and Time Formats, Math and Sorting in Wires
Date/Times As Inputs to Mashables or Mashups
Converting Other Formats to Datetime
Date/Times For Date Math
Date/Times For Sorting
Manage Mashups in Wires
Quickly Find Mashables, Mashups or Other Blocks
Edit a Mashup
Save a Mashup
Turn Mashups On or Off
View Mashup or Mashable Details
View Custom Block EMML Code
Open the Mashup Artifact Page to Create Apps, Add Views or Take Snapshots
Edit Mashup XPath Expressions in Advanced Mode
Customizing Wires
Adding Custom Blocks to Presto Wires Using Macros
Use Domains to Organize Custom Blocks
Define Inputs and Output for 'Wiring' the Macro
Loop Through a Well-Known Input
Make Macros Generic for Custom Blocks
Use or Construct XPath Expressions for Generic Macros
Configure Properties for Custom Blocks
Update Labels and Icons for Custom Blocks in Wires
Block Labels
Property Labels
Block Icons
Add Tooltips and Help in Custom Blocks
Tooltips
Add a Help Button and Help Topic
Make Custom Block Properties Required
Configure Field and Line Sizes for Custom Block Properties
Configure Strings, Numbers, Dates or Boolean Properties in Custom Blocks
Passwords
URLs
Integer Numbers
Decimal Numbers
Boolean Choices
Pick and Format Dates or Times
Configure Dynamic Path Choices and Results for Custom Blocks
Limit Dynamic Choices and Forbid Literal Entries
Get the Chosen Path as Text
Limit Custom Block User Entries to a List of Values
Literal List Values
Dynamic List Values from a Macro Input Parameter
Dynamic List Values from a Known Source
Advanced Custom Block and Property Configuration
Additional Configuration for Blocks
Additional Configuration for Block Property Fields
Mashups in EMML
Writing Mashups in EMML
Creating, Testing, Saving and Publishing Mashups
Creating a Mashup Script with EMML
<mashup>
EMML Namespaces
<operation>
Declaring Mashup and Macro Variables and Parameters
Valid Names for Variables and Parameters
Datatypes for Variables and Parameters
Default and Constructed Values
Variable and Parameter Scopes
Referencing Parameters and Variables
Working Samples
<input>
<output>
Commonly Supported Output Character Encodings
<variables>
<variable>
Declaring Namespaces
Declaring Data Sources
Named Datasources versus the Default Datasource
Explicitly Defining the Connection
Dynamic Connections
Working Samples
<datasource>
Configuring Datasource Drivers
Invoking Component Mashups and Mashables
<invoke>
<invoke> Examples
<directinvoke>
securityprofile
param
directinvoke Examples
Controlling Component Mashup/Mashable Invocation at Runtime
Issuing SQL Statements Directly to a Datasource
<sql>
<sql> Examples>
<sqlUpdate>
<sqlUpdate> Examples
<sqlcall>
Transforming Intermediate Results
Using XPath Functions to Transform Data
<assign>
<assign> Examples
<filter>
<filter> Examples
<group>
<group> Examples
<sort>
<sort> Examples
<annotate>
<annotate> Examples
<script>
Adding User-Defined Scripting Code to Mashups
Scripting Languages
Import Script Libraries
Include Scripts Directly
Access to Mashup Variables
Access to Java Classes
Working Samples
Adding User-Defined or Third-Party Java Classes for JavaScript Access
Installing and Configuring JRuby for Mashups
Deploying Groovy or JavaScript Scripts in Presto
<xslt>
Known Limitations
Deploy the Stylesheet and Related Resources
Custom XPath Functions and other XSLT Extensions
Combining Component Mashable or Mashup Results
<join>
<select>
<join> Examples
<merge>
<merge> Examples
Constructing the Mashup Result, Inputs or Intermediate Variables
Literal XML Structures with Literal or Dynamic Data
<constructor>
<constructor> Examples
<appendresult>
<appendresult> Examples
<select>
<columns>
<column>
<select> Example
Controlling Mashup Processing Flow
<if>
<elseif>
<else>
<if> Examples
<for>
<for> Example
<foreach>
<fuse>
<foreach> Examples
<while>
<while> Example
<break>
<break> Example and Working Samples
Concurrent Mashup Processing Flows
<parallel>
<sequence>
Working Samples
Database Mashable Transactions
<presto:beginTransaction>
<presto:commitTransaction>
<presto:rollbackTransaction>
SQL Transactions
<sqlBeginTransaction>
<sqlCommit>
<sqlRollback>
Handling or Throwing Exceptions
<try>
<catch>
Examples
<throw>
<return>
Lightweight Error Handling for Component Mashups and Mashables
Supporting Debugging
<display>
<display> Examples
<assert>
<assert> Examples
Adding Metadata to Mashups
<emml-meta>
<presto:macro-meta>
<block>
<label>
<help>
<icon>
<uiconfig>
<parameters>
<parameter>
<required>
<type>
<datetimefield>
<list>
<values>
<option>
<xpath>
<presto:presto-meta>
<user-meta>
Migrating Mashups to a New EMML Version
Migrating Mashups to Use a New Feature or Namespace
Expressions for Mashups
A Brief Introduction to XPath 2.0
XML Escaping in URLs and Expressions
Defining Custom XPath Functions
Write a Custom XPath Function Class
Add the Function to the Classpath for the Presto Server
Add the Function to a Mashup Script or Macro
Using XQuery Expressions in Construction Statements
Dynamic Mashup Expressions
Dynamic Expressions in Literal XML
Dynamic Expressions in XPath Expressions
Dynamic XPath or Other Syntax in Mashups
Advanced Mashup Techniques
Adding HTTP Headers to the Mashup Result
Adding Authentication Headers for Component Mashables
Construct Mashable Authentication Headers
Invoke the Mashable with Authentication Headers
Normalizing Data for Joins, Grouping or Filtering
Use the Custom XPath Function in Your Mashup or Macro
Converting and Working with Dates and Times
Using the ISODateFormatExt Custom XPath Function
ISODateFormatExt(dateText, fromFormat, toFormat)
Converting Numbers in Floating Point Notation
Adding Special Characters to Data
XML Character Entities
Using Presto Attributes in Mashups
Presto Global and User Attributes
Presto Session Attributes
Using Presto Attributes in Mashup Statements
Removing Duplicates With Filtering
XPath Axes
Setting the Mashup Response Character Encoding
Setting the HTTP Content Type Header in the Response
Setting the Character Encoding in the Response XML Declaration
Wrapping Results or Variables in CDATA Sections
Web Clipping with a Mashup Script
Handling HTML Responses
Handling JSON Responses or Inputs
Convert JSON to XML
Post JSON to a Web Service Using <directinvoke>
Accept JSON as Input and Modify with <script>
Wrapping POJO Classes with Mashups
Using Java Classes in a <script> Statement
Wrapping WSDL Web Services That Return HTML Results
Pre-Processing/Post-Processing Mashables with Mashups
Pre-processing Mashup
Post-processing Mashup
Self-Joins with a Single Dataset
Using XQuery for Outer Joins
Sample Mashable Results
Constructing the Join
Defining and Using Custom Mashup Statements with Macros
<macro>
<macro> Examples
Creating and Registering Macros
Create an Individual Reusable Macro
Create a Reusable Macro Library
<macros>
Including Macro Domains in Mashup Scripts or Macros
<include>
Calling a Macro
Macro Reference Namespace
Macro Domains
Passing Input Parameters to the Macro
Receiving Macro Results
Calling Macros From Another Macro
<macro:custom-macro-name>
Making Mashup Scripts Dynamic
Dynamic Mashup Syntax
Use Parameters/Variables in Attributes
Define XPath or Other Syntax Using <template>
Escape XML Delimiters Inside <template> Expressions
Use Dynamic Mashup Expressions Inside XPath Expressions
Create Generic Mashup Scripts
<template>
Generating Mashup Scripts Dynamically
<macro:externalDynamicEMML>
Using the Built-in Mashup Query Web Service
User Metadata Queries
Presto Metadata Queries
Mashable Dependency Queries
Mashup Samples
Mashup Utilities
Testing Mashup Scripts from the Command Line
Publishing Mashup Scripts from a Command Line
Updating Mashup Scripts from the Command Line
Publishing and Managing Macros from the Command Line
Profiling Mashup Performance
Configuring Profiling Logging
Mashup Profile Logs
EMML Reference
Declarations Group
Macroincludes Group
Statements Group
Variables Group
Working in the Mashup Editor
Editing Short Cuts and Tips
Automatically Generating <invoke> Statements in Mashup Editor
Adding Macro Calls Automatically in the Mashup Editor
Editing a Mashup in the Mashup Editor
Test Mashup Scripts or Macros in Mashup Editor
Publish a Mashup Script in the Mashup Editor
Presto Analytics
What is Presto Analytics?
Getting Started with Presto Analytics
A Basic RAQL Query
Structure, Format and Access to Datasets with RAQL
The RAQL Query Syntax
Load Data with <directinvoke> and Filter Rows
Use Plain Functions to Update, Select or Sort Rows
Datatype Information for Loaded Datasets
The Stream/Document Boundary
Use an In-Memory Store to Store and Load Datasets for Presto Analytics
Group and Analyze Rows
Group and Analyze Rows with Row Detail
Where to Go Next
RAQL Queries
Techniques to Load Data
Select Techniques
Over Techniques
From Techniques
Where Techniques
Group By Techniques
Having Techniques
Order By Techniques
Multi-DataSet Operations
Explore RAQL with the Presto RAQL Explorer
Open the Presto RAQL Explorer
Load Data and Run Queries
Save Queries as Mashups
Open/Manage Query Mashups
Escape Characters for RAQL Queries
Load Data with <sql>
Add a Datasource to Presto to Connect to the Database
Stream the Database Results and Query with RAQL
Query and Store to the Presto Analytics In-Memory Stores
Load Data with <invoke>
Load Snapshot Data with <snapshot> or <raql>
Snapshot Queries
Load Snapshots in a Named Variable
Load Snapshots Anonymously
Choose Snapshots by a Time Period
Choose Snapshots for a Scheduled Job
Select Distinct Values
Alias Names for Columns or Calculations
Use Alias Names in Other Clauses
Use Alias Names to Handle HTML Column Content
Plain Functions on Select Columns
Dataset Paths, Names and Datatypes
Adding Paths to Clarify RAQL Row Detection
Providing Dataset Path and Datatype Information in a Schema
Valid Names for Datasets, Columns, Aliases, Paths and Functions
RAQL Reserved Keywords
From Subqueries
Limit the Rows Returned
Where Complex Conditions
Multiple Required Conditions
Combining Logical Conditions
Comparing Dates or Numbers
Calculations in Conditions
Negative Comparisons
Where Text Like Patterns
Where in Sets
Where Between a Range
Parameters in Where Clauses
Literal Values in Conditions or Expressions
Plain Functions in Where
Sort Directions and Multi-Level Sorts
Plain Functions in Sorts
Multi-Level Group Calculations
Having Clause to Filter Groups
Partitions and Windows
Running Aggregates
Number or Rank Rows
Analytic Functions for Partitions and Windows
Joins and Other Multiple-Dataset Operations
Join: Merge Columns for Dataset Rows
Union: Append Like Datasets
Intersect: Find Common Dataset Members
Except or Minus: Find All Less the Intersection
Creating Dynamic RAQL Queries
Migrate RAQL Queries from Version 3.7 to 3.8
RAQL Datatypes and Data Formats
Supported Data Formats for RAQL
Valid RAQL Datatypes
RAQL Operators
Built-In RAQL Functions
Built-In Plain Functions
Built-In Analytic Functions: Aggregate and Window
Create and Add User-Defined Functions for RAQL Queries
Set Up Your Development Environment
Write Plain Functions for RAQL
Configure, Compile, Deploy and Test User-Defined Functions
Write Window Analytic Functions for RAQL
Write Aggregate Analytic Functions for RAQL
Use a Factory for Function Overloading
Statistics and Analytics Third-Party Libraries
RAQL Query Syntax Reference
Working with Presto Analytics In-Memory Stores
Declared Versus Dynamic In-Memory Stores
External versus Internal Datasets
About BigMemory and the Presto Analytics In-Memory Stores
Initial Memory Configuration and Performance
In-Memory Dataset Management
Memory Management and Configuration
BigMemory Configuration, Cache Sizing and Pinning
Store Data in Presto Analytics In-Memory Stores
Store Data in Declared In-Memory Stores
Set Unique Keys for Dataset Rows
Append Query Results Repeatedly
Clear Existing Data from In-Memory Stores
Manage Memory for Dynamic In-Memory Stores
Load Data from the Presto Analytics In-Memory Stores
RAQL Extension to EMML Statements for Mashups
<loadfrom>
<raql>
<snapshot>
<storeto>
RAQL Extensions to EMML Statements for Streaming
Data Access as Documents with No Streaming
Data Access as Streaming Datasets
Stream Partitions
RAQL Extensions to <variable> for File Data Sources
RAQL Extensions for Dataset Schemas
RAQL Samples
Views for Mashups and Mashables
Built-in Presto Views
Add Views to Mashables and Mashups
About Desktop and Mobile View Compatibility
Manage Views
Common Chart Techniques
Change Series Labels
Change the Series Plot to Column, Line or Area
Add a Target Line
Include Dynamic Content in Captions and Labels
Dial Gauge
Characteristics
Configure This View
Add a Gauge to This View
Configure a Dial Gauge
Area Chart
Characteristics
Configure This View
Bar Chart
Characteristics
Configure This View
Bubble Chart
Characteristics
Configure This View
Bulb Gauge
Characteristics
Configure This View
Add a Gauge to This View
Configure the Bulb Gauge
Bullet Gauge
Characteristics
Configure This View
Add a Gauge to This View
Configure a Bullet Gauge
Candlestick Chart
Characteristics
Configure This View
Column Chart
Characteristics
Configure This View
Cylinder Gauge
Characteristics
Configure This View
Add a Gauge to This View
Configure the Cylinder Gauge
Doughnut Chart
Characteristics
Configure This View
Feed Reader
Characteristics
Funnel Chart
Characteristics
Configure This View
Gantt Chart
Characteristics
Configure This View
Visual Effects of Optional Data Configuration for Gantt Charts
Gauges
Geo Map
Characteristics
Configure This View
ISO 3166-1 Alpha 2 Country Codes
Google Map
Characteristics
Configure This View
Grid and KPIs View
Characteristics
Configure This View
Move or Remove Columns
Add Columns and Assign Values
Change Column Headings, Width and Text Formatting
Show As: Change the Column Format for Different Types Data
Number Formatter
Spark Charts, Bullet Graphs and Percentages
Use Templates to Combine Data, Add Literal Text or Add HTML Tags
Add Key Performance Indicators (KPI)
Precedence for Column Settings and KPI Rules
Intensity Map
Characteristics
Configure This View
ISO 3166-1 Alpha 2 Country Codes
Kagi Chart
Characteristics
Configure This View
LED Gauge
Characteristics
Configure This View
Add a Gauge to This View
Configure the LED Gauge
Line Chart
Characteristics
Configure This View
Real-Time Line Chart
Characteristics
Configure a Real-Time Line Chart
Linear Gauge
Characteristics
Configure This View
Add a Gauge to This View
Configure the Linear Gauge
Marimekko Chart
Characteristics
Configure This View
Pareto Chart
Characteristics
Configure This View
Pie Chart
Characteristics
Configure This View
Record Details View
Characteristics
Configure This View
Pyramid Chart
Characteristics
Configure This View
Radar Chart
Characteristics
Configure This View
Scatter Chart
Characteristics
Configure This View
Sparkline
Characteristics
Configure This View
Sparkline Column
Characteristics
Configure This View
Sparkline win_loss
Characteristics
Configure This View
Spline Area Chart
Characteristics
Configure This View
Spline Line Chart
Characteristics
Configure This View
Step Line
Characteristics
Configure This View
Template View
Create a Custom View
Map Result Fields to the Template
Map Results Fields That Contain HTML Markup
Iterate Through Repeating Results
Add Conditional Logic
Use CSS in Template Code
Use Images in Template Code
Use JavaScript in Template Code
Examples
Thermometer Gauge
Characteristics
Configure This View
Add a Gauge to This View
Configure the Thermometer Gauge
Zoom Line Chart
Characteristics
Configure This View
Advanced Configuration Properties
Background
Canvas
Text Formatting
Layout
Labels
Advanced
More Properties
Creating Pluggable Views or Libraries
Views and Libraries in Presto
Implement and Add a Pluggable Library or View
Implement a Pluggable View Class
A Hello World Pluggable View Class
Pluggable View Classes: Using Mashable/Mashup Data
Selecting Columns for View Configuration
Formatting and Rendering Response Data
Pluggable View Classes: Triggering and Handling Events
Register and Trigger View-Specific Events in Pluggable Views
Support DataTable Row Selection Events in Pluggable Views
Example: Complete D3 Pie with View-Specific and DataTable Events
CSS Styles, Help and Thumbnails for Pluggable Views
Configuration Properties for Pluggable Views or Libraries
Import Pluggable Views and Libraries
Library Projects Folders and Configuration Files
Ant Tasks and Sample Build File to Import Pluggable Views or Libraries
Import Pluggable Library/View Examples
Managing Updates and Library Versions
Library Versions and Dependencies
Handle Minor Library Updates
Handle New Library Releases or Major Updates
Apps and Workspaces
Create a Basic App
Configure App Input Parameters
Select and Arrange Views
Preview and Finalize the Presentation
Save the App
Publishing, Managing, Sharing and Using Apps
Embed an App in HTML Pages
Publish an App in SharePoint
Edit App Properties
Input Parameters
Layouts
Themes
Pagination and Miscellaneous Properties
Sorting and Filtering Properties
Device Compatibility and General Properties
Edit Properties for Custom or Workspace Apps
About Desktop and Mobile Compatibility for Apps
Title Bars and Toolbar Buttons in Apps
Buttons in the Default Title Bars
Publish Apps to the AppDepot
Create Workspace Apps with Mashboard
Working in Mashboard
Find Views, Apps or Workspaces in Mashboard
Finding Views
Views Added Directly to a Workspace
Basic App Wrapper for Views
Automatic Interactions and Shared Properties for Multiple Views Directly Added to a Workspace
Edit Workspaces
Move, Cut, Copy, Paste or Remove Apps or Views in Workspaces
Copy a Workspace
Control Title Bars and Borders
Set Input Parameters, Pagination, Isolation or Auto-refresh
Set Data Share or Sort and Filter Tools for Views
Grant Run Permissions to a Workspace
Add or Delete Rows and Columns to a Layout
Adding Columns or Rows
Deleting Columns or Rows
Increasing the Maximum Number of Columns or Rows
Set Size, Spanning and Padding in Column or Table Layouts
Initial Widths and Heights for Column or Table Layouts
Control Padding for Column or Table Layouts
Resize Apps in Column or Desktop Layouts
Change Cell Width or Height with Spanning in Table Layouts
Fixed Row Heights for Table Layouts
Add, Delete, Arrange or Configure Tabs or Pages in Layouts
Add Tabs or Pages
Delete Tabs or Pages
Change Tab or Page Names
Change the Order of Pages
Set Other Tab or Page Configuration
Set Desktop Layout Colors and Properties
Web Page Layout for Tabs or Pages
Add a Real-Time Line Chart
Configure the Real-Time Line Chart
Add a PPM Chart to a Workspace
Additional PPM Chart Options
Update a PPM Chart
Update the PPM Chart Favorite
Update PPM Chart Selection Properties
Control User Jumps to PPM
Wire Selection and Filter Events for PPM Charts
Set Filter Properties for Wiring PPM Charts
Add a Dimension or Key Indicator Criteria
Add Additional Criteria for an Existing Dimension or Key Indicator
Filter Wiring Example for a PPM Chart App
About PPM Filters
Add a Drill Down App in a Workspace
Add a Filter for Apps in a Workspace
Edit or Delete Filter Controls
Add an Input Form for All Apps In a Workspace
Edit a Workspace Form
Workspace Form Fields
Title Block
Input Block
Text Area Block
Select Block
Radio Block
Add Google Gadgets to a Workspace
Add an HTML Widget to a Workspace
Add Other Media as Objects to a Workspace
Add Web Pages to a Workspace
Add Gadgets With JavaScript to a Workspace
Wiring App Interactions in a Workspace
Events and Topics for Wiring Basic and Custom Apps
Publish Topic Messages for Events in Basic Apps
Subscription Topics for Basic Apps
Hiding Input Forms for Apps in a Workspace
Synchronizing Wired Apps When a Workspace Loads
Update Input Parameters on Workspace Load
Synchronize Row Selection on Workspace Load
Manage App Interaction Wiring in Workspaces
Toggle Wiring Subscriptions Off or On
Edit Subscription Property Mappings
Working in the Presto Enterprise AppDepot
AppDepot Tabs and Toolbars
Managing Pending Apps in the AppDepot
About Presto Mobile
Installing Presto Mobile Apps in Mobile Devices
Login and Get Started in Presto Mobile
Working in Presto Mobile Apps
Presto Mobile App Features
Custom Apps
Working in the App Editor
Find and Open an App
Edit and Test an Open App
Download an App
Update an App
Customize a Basic App or View
Customize Themes for Basic Apps and Views
CSS Selectors for Themes
Customize the Layout for Basic Apps
Including Built-in Tools in a Custom Layout
Layout Roles
Customize Built-In Chart Attributes
Create Fully Custom Apps in the App Editor
Create Custom Apps from the Base App Package
Declare, Get and Set Properties in Custom Apps
Get Properties or Property Values
Set Property Values
App Dimensions and Resizing
Set App Dimensions
Support Resizing in Custom Apps
Handle Resize Events
Enable User-Initiated or Automatic Refreshes
User-Initiated App Refreshes
Automatic App Refreshes
Handle Exceptions
Wiring App Interactions
Tightly-Coupled and Loosely-Coupled Interactions
Tightly Coupled Interaction for Custom Apps
Publisher App for Tightly Coupled Interactions
Subscriber App for Tightly Coupled Interactions
Embedding Tightly Coupled Apps
Wildcard Subscriptions for Tightly-Coupled Interactions
Enable Loosely-Coupled Interactions in Custom Apps
Publisher App for Loosely-Coupled Interactions
Subscriber App for Loosely-Coupled Interactions
Basic App Support for Loosely-Coupled Interactions
The Completed Sample Apps
Declare App Topics and Payloads
Registering Sample Mashables or Mashups
Register Samples Mashables
Register Sample Mashups
Override Browser Caches for Updates to App Resources
The Structure of a Presto App
Parameters for App URLs
App Specification Reference
<app>
<authors> or <author>
<authors>
<author>
<dependson>
<resource>
<description>
<help>
<icons> or <icon>
<icons>
<icon>
<presto-meta>
App Layout
App Themes
Charts Theme
Device Compatibility Flags
Toolbar Button Flags
View Configuration
<properties> or <property>
<properties>
<property>
<content>
<requires> or <require>
<requires>
<require>
<title>
<topics> or <topic>
<topics>
<topic>
App Packages and App Files
Presto Add-Ons
The Presto Add-On for Excel
Install the Presto Toolbar in Excel
Before You Start
Installation
Presto Toolbar for Excel
The Presto Toolbar Add-On Configuration File
Configuring the Connection to Presto
Work with Presto Mashup and Mashable Results in Excel
Import Presto Mashup or Mashable Results
Selecting the Result Nodes to Import
Change Parameters for an Imported Mashup or Mashable
Changing Imported Mashup or Mashable Data
Refresh Presto Mashup or Mashable Results
Remove an Imported Mashup or Mashable
Export Excel Worksheets or CSV Files as Mashables in Presto
Register a Worksheet as a Spreadsheet Mashable in Presto
Valid Spreadsheet Content
Manual or Automatic Updates to Spreadsheet Content
Register a Range of Cells From the Current Worksheet
Register a Worksheet From an Excel File in Excel
Register a CSV File as a Mashable
Valid Spreadsheet Mashables
Update Mashables Manually from Worksheets
Remove an Excel Mashable from Presto
The Presto Add-On for Portals
Installing the Presto Add-On for Portals
Download the Presto Add-On for Portals
Download and Install Presto
Add the Presto Add-On for Portals to Your Portal
Update Configuration for the Presto Add-On for Portals
Login and Get Started
Presto Add-On for Portals Architecture
Migrating to New Versions of the Presto Add-On for Portals
Download the New Presto Add-On for Portals Release
Upgrade Presto to the Matching Release
Backup Portal Configuration
Install the New Presto Add-On for Portals Release
Clear the Portlet Cache in the Portal
Adding Presto Mashups to Portal Pages
Adding Presto Apps to Portal Pages
Managing and Updating Mashups or Apps in Portal Pages
Portlet Preferences
Change the Display Size for a Mashup or App
Change Mashup or App Input Parameters
Enable the App Forms for Input Parameters, Sorting and Filtering
Show the App Title Bar
Change the Portlet Title
Update the Mashup Layout for Views
Update Mashup or App Pagination Settings
Update App Theme
Update App Portlet Performance Preferences
Presto Add-On for SharePoint (P4S)
An Introduction to the Presto Add-On for SharePoint
Maximize the Potential of Information
Empower SharePoint Users with Powerful Visual Tools
Maximize SharePoint ROI
Presto Add-On for SharePoint in Action
Presto Add-On for SharePoint Features
Getting Started
Installing Presto Add-On for SharePoint
Installing the Presto Add-On for SharePoint Solution
Before Your Start
Install the P4S Solution
What is Installed
Troubleshooting Installation for the P4S Solution
Upgrading to New Releases of P4SP
Install or Upgrade Presto Servers for P4S
P4S Configuration and Administration, SharePoint 2010
Planning Authentication for P4S 2010
User Authentication Experiences for P4S 2010
Authentication Designs for P4S 2010
SSO + Token Authentication
SSO + Cookie Authentication
No SSO, Manual Authentication
Configuring Presto Add-On for SharePoint 2010
Activate P4S 2010 Features
Enabling P4S Features in Farms
Enabling P4S Web Parts for Site Collections
Manually Enabling P4S Features for a Site
Configure Authentication for P4S 2010
Configure the Secure Store Service
Create Secure Store Target Applications
Create or Manage SSO Token Server Names
Disable Cookie Forwarding for Presto Server Overrides
Configure Presto Server Connections in SharePoint 2010
Add a Presto Server Connection to SharePoint
Edit a Presto Server Connection
Duplicate Connections to Presto Servers
Complete Miscellaneous Configuration for P4S 2010
Set the Scope of Apps in the App Gallery
Set the Default Sandbox Mode for apps
P4S Farm and Site Administration, SharePoint 2010
P4S Configuration and Administration, SharePoint 2007
Planning Authentication for P4S 2007
User Experiences for P4S 2007
Authentication Designs for P4S 2007
SSO + Token Authentication
SSO + Cookie Authentication
No SSO, Manual Authentication
Configuring Presto Add-On for SharePoint 2007
Activate P4S Features for SharePoint 2007
Enable P4S Features in Farms
Enable P4S Web Parts for Site Collections
Activate Custom P4S Actions for Site Collections
Activate the Presto Administration Feature for Site Collections
Configure Authentication for P4S 2007
Configure the SSO Service in Windows
Configure the SSO Service in SharePoint
Create SSO Applications for P4S
Configure SSO Token Server Names for P4S
Disable Cookie Forwarding for Presto Server Overrides for Sites
Configure Presto Server Connections in SharePoint 2007
Add a Presto Server Connection to SharePoint 2007
Edit a Presto Server Connection
Duplicate Connections to Presto Servers
Complete Miscellaneous Configuration for P4S 2007
Set the Scope of Apps in the App Gallery
Set the Default Sandbox Mode for Apps
Farm and Site Administration for P4S 2007
SharePoint Credentials for Mashables and Mashups
Add or Manage SharePoint Credentials in Your Presto Hub Profile
Add a Global Attribute for Agent-Based SSO Authentication with SharePoint
Presto Add-On for SharePoint User Guide
Publishing Apps and Mashups to Web Parts
Other Tasks
Create a Web Part Page
Add a Mashup Web Part to a Web Part Page
Publish a Mashup to a Mashup Web Part
Mashup Web Part Toolbar
Update Mashup Web Part Properties
Change the Web Part Title
Change the Mashup Server Connection for a Mashup Web Part
Change the Mashup ID
Publish Mashup Results as Native SharePoint Lists
Publish Mashup Results as External SharePoint Lists
Requirements and Limitations
The Mashup-to-External-List Process
Create an External Content Type for a Mashup
Create an External Content List from a Mashup
Troubleshooting URL Loading Problems
Register a SharePoint List as a Presto Mashable
Update Mashup or App Input Parameters
Add an App Web Part to the Web Part Page
Publish an App to an App Web Part
App Web Part Toolbar
Update App Web Part Properties
Change the Web Part Title
Hide or Show App or View Titles and Toolbars
Change Pagination or Themes
Enable Anonymous Access
Change the Mashup Server Connection for an App Web Part
Change the App ID
Presto Add-On for SharePoint User Guide
Publishing Apps and Mashups to Web Parts
Other Tasks
Create a Web Part Page
Add a Mashup Web Part to a Web Part Page
Publish a Mashup to a Mashup Web Part
Mashup Web Part Toolbar
Update Mashup Web Part Properties
Change the Web Part Title
Change the Mashup Server Connection for a Mashup Web Part
Change the Mashup ID
Publish Mashup Results as Native SharePoint Lists
Publish Mashup Results as External SharePoint Lists
Requirements and Limitations
The Mashup-to-External-List Process
Create an External Content Type for a Mashup
Create an External Content List from a Mashup
Troubleshooting URL Loading Problems
Register a SharePoint List as a Presto Mashable
Update Mashup or App Input Parameters
Add an App Web Part to the Web Part Page
Publish an App to an App Web Part
App Web Part Toolbar
Update App Web Part Properties
Change the Web Part Title
Hide or Show App or View Titles and Toolbars
Change Pagination or Themes
Enable Anonymous Access
Change the Mashup Server Connection for an App Web Part
Change the App ID
Presto Development and APIs
Features of the Presto REST or Presto Connect APIs
Working with the Presto REST API
Get the Mashable/Mashup Specification
Login or Set Guess Access
Build and Send the Request
Cross Domain Requests
Session Management
Use Presto Connect for Javascript
Use PC4JS in Custom Apps
Use PC4JS in Other Web Applications or Web Sites
Guest or Authenticated Access with PC4JS
Use Mashable/Mashup Technical Specs
Paginate Mashable or Mashup Responses
Presto Headers Used in Pagination
Pagination Using the Presto DataTable API
Map Presto Attributes to Artifact Input Parameters
Presto Attribute Mapping Expressions
Define Presto Session Attributes
Presto APIs
Presto REST APIs and Presto Connect
Pluggable Views, Custom Apps and Common JavaScript Client Libraries
Miscellaneous Extension APIs
Presto REST API
Handle Authentication
Invoke Mashables or Mashups
Presto Headers/Parameters
Presto Request Headers/Parameters
Presto Response Headers
Obsolete JUMP Headers
Presto Snapshot API
Take or Delete Snapshot Methods
Take a Snapshot Immediately
Take a Temporary Snapshot and Save Separately
Delete Snapshots
Get Snapshot Methods
Get Snapshot Collections By Criteria
Get One Snapshot By ID
Schedule Snapshot Job Methods
Manage Scheduled Snapshot Job Methods
Find Jobs
Suspend Jobs
Resume Jobs
Delete Jobs
About DataTable Events
DataTable Events for Views and Apps
Presto Platform API Console
Presto Platform Services
The JackBe Universal Message Protocol (JUMP)
JUMP Requests
JUMP Responses
Input Parameters for JUMP Requests
Parameter Values
Adding Headers for Mashables to JUMP Requests
Namespaces and Namespace Prefixes
Presto APIs
Presto REST APIs and Presto Connect
Pluggable Views, Custom Apps and Common JavaScript Client Libraries
Miscellaneous Extension APIs
Presto REST API
Handle Authentication
Invoke Mashables or Mashups
Presto Headers/Parameters
Presto Request Headers/Parameters
Presto Response Headers
Obsolete JUMP Headers
Presto Snapshot API
Take or Delete Snapshot Methods
Take a Snapshot Immediately
Take a Temporary Snapshot and Save Separately
Delete Snapshots
Get Snapshot Methods
Get Snapshot Collections By Criteria
Get One Snapshot By ID
Schedule Snapshot Job Methods
Manage Scheduled Snapshot Job Methods
Find Jobs
Suspend Jobs
Resume Jobs
Delete Jobs
About DataTable Events
DataTable Events for Views and Apps
Presto Platform API Console
Presto Platform Services
Presto Administration
Getting Started with the Presto Server
Additional Presto System and Software Requirements
Additional Recommendations for Presto
Recommendations for Presto Add-On for SharePoint (P4S)
Recommendations for the Presto Add-On for Excel
Recommendations for the Presto Add-On for Portals
Requirements for Optional Views
Presto Browser and Mobile Device Compatibility
Presto and MashZone Database Compatibility
What is Installed with Presto
Presto Installation Folders
Start and Stop the Presto Server
Start the Presto Server
Startup Account for the Presto Server With Presto Add-On for SharePoint
Stop the Presto Server
Startup Considerations
Manage Licenses for Presto, Universal Messaging and BigMemory
Move the Presto and MashZone Repositories to a Robust Database Solution
Troubleshooting Connections to the Presto Repository
Move Presto and MashZone Repositories to Microsoft SQL Server
Move the Presto and MashZone Repositories to MySQL
Move the Presto and MashZone Repositories to Oracle
Move the Presto and MashZone Repositories to PostGres
Integrate Your LDAP Directory with Presto
Defining LDAP Connection Configuration
Defining the Authentication Scheme
Defining the Authorization Scheme
Enabling Presto Application Queries for All LDAP Users or Groups for Permissions
Use the Default Presto User Repository
Manage Users
Create Users
Edit, Grant Permissions and other User Management Tasks
Manage User Groups
Automatically Assign New Users to Groups
What’s Next
Presto Security
Change technical user password
Authentication and Guest Access
User Authentication
Valid Credentials
Sessions and Timeouts
Enabling Guest Access
Default User Accounts
Authentication with Single Sign-On Solutions
Configuration for Agent-Based SSO Solutions
Configuration for the CAS SSO Solution
Implementing a Custom SSO Filter
Authentication with Digital Certificates/SSL
Configure the Presto REST API to Use Certificate Authentication
Configure Alternate User ID Extraction
Configure Dynamic User Support
Configure Additional Certificate Validation
Authorization Policies and Permissions
Grant User Access to Presto with Built-in Groups
Built-In Presto User Groups and Permissions
Access Policies Using Presto Built-In Groups
Artifact Permissions for Users with Run Permissions
Automatically Grant Run Permissions to Users and Groups
Set View Permissions with a Search Filter
Enable or Disable Authorization
Presto Server Configuration
Memory Configuration for the Presto Server
Configuration When Presto Uses Only Heap Memory
Configuration When Presto Uses Heap and Off-Heap Memory
Support International Character Sets and Locales
Presto Repository Encoding and Timezone
Mashable, Mashup and App Encodings and Locales
Date, Time and Numeric Display Options
Message Log and Default Locales
Update Help or Use Offline Help for Presto
Change the Presto HubTheme
Set the default chart theme
Configure the Presto Server with Custom Ports
Change Presto Server Ports
Change Presto Repository Ports
TomEE Application Server Port
Configure the Presto Server to Work with a Proxy Server
Define a Proxy Server Whitelist for Presto
Using Regular Expressions in a Whitelist
Configure Presto for SSL and Digital Certificates
The Certificate Store and Certificates
Configure Mutual SSL Between Users and Presto
Configure Mutual SSL Between Presto and Mashable Information Sources
One-Way SSL to Presto
One-Way SSL to Mashable Information Sources
One-Way SSL to Information Sources Using <directinvoke> in Mashups
Configure HTTPS and Certficate Stores in the Application Server
Configure Certificate Stores in Presto
Update SSL Configuration for Java
Presto Logging
Configure Logging for the Presto Server
Turn Audit Logging On or Off
Presto Notifications
Configuring a Mail Server for Presto
Update the User Email Attribute from LDAP
Configure Presto Connections to SharePoint
Connection Patterns Between Presto Servers and SharePoint
Add SharePoint Connections to the Presto Server
BigMemory for Caching, Connections and Presto Analytics
Caching for the Presto Server
Configure BigMemory Servers for Presto Caching and In-Memory Stores
Declare BigMemory Stores for Presto Analytics
Declare a New In-Memory Store
Modify a Declared In-Memory Store
View Details for Declared In-Memory Stores
Manage Dynamic BigMemory Stores for Presto Analytics
Add an External Dynamic In-Memory Store Connection
Delete External Dynamic In-Memory Store Connections
Configuring Mashable/Mashup Response Caching
Enable and Configure Response Caching
Cache Responses by Default and Disable Exceptions
Cache Responses for Exceptions Only
Controlling Response Cache Entries Dynamically
Response Caching Example
Manage Data Sources and Drivers
Add a Data Source
Edit, Test or Remove Data Sources
Add or Manage JDBC Drivers
Configure the Default Operations Generated for Database Mashable
Manage Categories for Mashups, Mashables and Apps
Manage Providers for Mashups, Mashables and Apps
Work With Presto Attributes
Manage Presto Global Attributes
Expose User Attributes from the User Repository in Presto
Manage Artifact Attributes
Add an Artifact Attribute Definition
Edit or Delete Artifact Attribute Definitions
Disable Mashup Features
Configure HTTP Response Header Forwarding
Configure Mashable HTTP Request Timeouts
Enable or Disable the Snapshot Feature
Set Web Feed Normalization
Handle SOAP Encoding Errors for WSDL Services
Add XML Schemas to the Wires Mapper Block
Integrated MashZone Server Configuration and Administration
Basic Settings for the Integrated MashZone Server
Tune Memory/Caching for the Integrated MashZone Server
Tune MashZone Memory and Cache Configuration Manually
Automatically Tune MashZone Memory and Cache Configuration
Create New MashZone Resource Directories
Manage MashZone Resource Directories
Configure Proxy Information for the Integrated MashZone Server
Enable the Geocoding Operator for MashZone Feeds
Import or Export MashZone Feeds
Import Existing MashZone Feeds
Export MashZone Feeds from Presto
Add Database Connections for the Integrated MashZone Server
Add a Database Driver to MashZone
Add a Database Connection to MashZone
Manage Database Connections for the Integrated MashZone Server
Enable the MashZone Feed Editor
Enable the MashZone Administration
Event Service Configuration and Administration
Manage EDA Event Sources
Identify the Event Type Store directory
Create EDA Event Sources
Edit EDA Event Sources
Duplicate EDA Event Sources
Delete EDA Event Sources
Import EDA Event Sources
Export EDA Event Sources
Manage Apama Event Sources
Create Apama Event Sources
Edit Apama Event Sources
Duplicate Apama Event Sources
Delete Apama Event Sources
Import Apama Event Sources
Export Apama Event Sources
Start or Stop an Event Source
Restart all Event Source
Process Performance Manager (PPM) Integration
Manage PPM Connections
Create PPM Connections
Edit PPM Connections
Delete PPM Connections
Import PPM Connections
Export PPM Connections
Import the PPM Chart App
Presto and MashZone Repositories
Tuning the Presto or MashZone Repository Connection Pool
Synchronize the Presto Repository and Presto Server Time Zones
Presto Server Administration
View Presto Logs
View the Presto Server Log
View the Audit Log for a Mashable, Mashup or App
Purge the Audit Log
Manage Pluggable Views and Libraries
Manage Pluggable Libraries
Manage Pluggable Views
Manually Changing the Default Version for Libraries
Manage Files for Presto Features or Artifacts
Add External Resources as Presto Files
Find Presto Files
Update or Delete Presto Files
File Organization
Upgrade to New Versions of Presto and Migrate Artifacts
Migrating Extensions to Presto
Migrating Custom XPath Functions, XSLT Stylesheets, Java Classes or JRuby Scripts for Mashups
Migrating Macro Libraries and Custom Macros for Mashups
Migrating the Presto Repository from 3.0 to 3.1
Migrating the Presto Repository from 3.1.1 to 3.2
Migrate the Presto Repository from 3.2.1 to 3.5
Presto 3.5 Schema Updates for MS SQL Databases
Presto 3.5 Schema Updates for MySQL Databases
Presto 3.5 Schema Updates for Oracle Databases
Presto 3.5 Schema Updates for PostGres Databases
Upgrade the Presto 3.5 Repository JAR for MSSQL, MySQL or Oracle
Migrating Existing Apps from Presto 3.1.1 to 3.2
Updating Built-in Policies for Presto 3.2
Updating Built-In Policies for Presto 3.5
Updating Built-In Policies for Presto 3.9
Updating the Macro Metadata Service for Presto 3.2
Migrate Mashups using RAQL for Presto 3.6.1
Upgrade from Presto 3.6.1 to 3.7
Migrate Mashups That Use RAQL for 3.7
Handle In-Memory Store and Load Changes
Handle Column or Function Name Incompatibilities
Updates for Non-Grouping Columns in Queries with Aggregation Functions
Updates for Alias References in Select Clauses
Handle Errors from Derived Schemas
Deploying Presto Instances, Clusters or Artifacts
Deploying the Core Components
Deploying Server and Client Add-Ons
Deploying Presto Artifacts and Other Metadata
Exporting Mashable and Mashup MetaData
Exporting Macros
Exporting App MetaData
Exporting Pluggable Views or Libraries
Exporting Presto Global Attributes
Exporting Users, User Metadata and Groups
Importing Mashable or Mashup MetaData
Importing Macros
Importing App Metadata
Importing Pluggable Views or Libraries
Importing Presto Global Attributes
Importing Users, User Metadata and Groups
Deploying Multiple Presto Servers in One Host
Clustering Presto Servers
Setting Up a New Cluster
Adding New Members to an Existing Cluster
Sharing the Presto Repository in Clustered Environments
Create and Share a New Presto Repository
Share an Existing Presto Repository
Setting Up an External Presto Configuration Folder
Presto File-Based Configuration and Extensions
Sharing JDBC Drivers in Clustered Environments
Additional Information and Support
Preface
Additional Information and Support
preface_pdf_library
prestoIntro
coreComponents
apisSpecs
addOns
faq
hub_library_intro
hub_features
userProfile
hub_search
help.search
hub_shared_tasks
help.hub.bulkUpd
bulkTasks
commonMetaData
grantRunPermission
grantRun1Artifact
grantRunWDependencies
grantRunInAppDepot
mashable_library_intro
serviceTypes
aboutDatabase
dbServiceNames
defaultDBServiceOperations
dbArbitraryQueries
dbResponses
aboutMZFeed
aboutSnapshots
aboutExcel
validSpreadsheetCVSLabels
aboutRSS
aboutWSDL
aboutWSS
publish_intro
publishFeeds
help.publish.rss
help.publish.rest
publishREST
publishWSDL
help.publish.wsdl
help.publish.excel
publish_excel
publish-xml
help.publish.xml
publishCSV
help.publish.csv
publishDB
help.publish.db
publishDBCustom
publish-SPList
help.publish.splist
publishSnapshot
subscribeEvents
help.service.mzfeed
mzFeedEditor
aboutSecurityProfiles
configSecurityProfile
configHTTPRequestHeader
aboutREST
service_details_library
runService
editEndpoint
editSecurityProfile
setCharEncoding
takeSnapshots
scheduleSnapshots
freeform_intro
freeform_display_dashboard
freeform_useFilter
freeform_manage_dashboards
freeform_create_dashboard
freeform_edit_dashboard
freeform_edit_dashboard_properties
freeform_delete_dashboard
freeform_assign_dashboard_permissions
freeform_change_style_template
freeform_create_style_template
freeform_edit_style_template
freeform_configure_dashboards
freeform_add_tab
freeform_delete_tab
freeform_format_tab
freeform_configure_components
freeform_insertComponent
freeform_insertLineChart
freeform_insertColumnChart
freeform_insertPieChart
freeform_insertPrestoGrid
freeform_insertGaugeChart
freeform_insertCombobox
freeform_insertInputfield
freeform_insertPrestoApp
freeform_insertPrestoView
freeform_insertImage
freeform_insertLable
freeform_assignDataSource
freeform_assignDataToLineCharts
freeform_assignDataToColumnCharts
freeform_assignDataToPieCharts
freeform_assignDataToPrestoGrid
freeform_assignDataToGaugeCharts
freeform_assignDataToPrestoApp
freeform_assignDataToPrestoView
freeform_assignDataToCombobox
freeform_assignDataToLabel
freeform_create_input_parameter
freeform_moveComp
freeform_hide_header_and_border
freeform_resizeComp
freeform_copy-pastComp
freeform_defineFilter
freeform_deleteComp
freeform_customize_desktop
freeform_displaysize
freeform_grid
freeform_export_dashboards
freeform_import_dashboards
wires_library_intro
wires_designer
createMashup
help.wires
addMashupOrSvc
directinvokeAction
help.wires.directinvoke
help.wires.spblocks
spGetActions
loopInvokeAction
help.wires.foreach
previewBlocks
stopPreview
addActions
aggregateAction
help.wires.aggregate
autoInput2Property
averageAction
help.wires.average
countAction
help.wires.count
connectInputAction
csvFrmtAction
help.wires.csv
dataDecorateAction
help.wires.datadecorator
dateAction
help.wires.datebuild
help.wires.document
documentAction
help.wires.spect
enableSPECT
extractAction
help.wires.extract
filterAction
help.wires.filter
filterMatchExpr
help.wires.group
groupAction
help.wires.input
inputAction
help.wires.join
joinAction
help.wires.mapper
mapAction
help.wires.merge
mergeAction
mergeSPList
help.wires.mergelist
nsStripperAction
help.wires.namespacestripper
parallelAction
help.wires.parallel
pivotAction
help.wires.pivot
help.wires.raql
raqlAction
selectAction
help.wires.select
addItemSPList
help.wires.addsplistitem
help.wires.sql
sqlAction
stringBuildAction
help.wires.stringbuild
sortAction
help.wires.sort
help.wires.transformer
trasnformAction
transformFunctions
help.wires.urlbuild
urlBuildAction
xpathSelect
useGlobalUserParams
inputParamNames
ifElse
httpHeaders
help.wires.advproperties
blockAdvProps
drawConnections
help.wires.output
outputBlock
propertyEscapeChars
dateFormats
manageMashups
editXPathExpert
customizeWires
macro_add_wires_action
macro_labelsIcons
macro_help
macro_req_properties
macro_property_lines_sizes
macro_simple_datatypes
macro_xpath_picker_config
macro_selection_list
macro_uiconfig_adv
mashup_library_intro
mashup_intro
createMashupScript
mashupRefCmd
emmlNamespaces
operationRefCmd
declareVariablesEtc
inputRefCmd
outputRefCmd
variablesRefCmd
declareNamespaces
declareDatasource
datasourceRefCmd
datasourceDrivers
invokeComponentSvc
invokeRefCmd
directinvokeRefCmd
invokeRuntimeControls
sql-intro
sqlRefCmd
sqlUpdateRefCmd
sqlcallRefCmd
transformData
assignRefCmd
filterRefCmd
groupRefCmd
sortRefCmd
annotateRefCmd
scriptRefCmd
scripting
jrubyInstall
jrubyDeployScripts
xsltRefCmd
combineResults
joinRefCmd
mergeRefCmd
defineMashupResult
constructorRefCmd
appendresultRefCmd
selectRefCmd
controlMashupFlow
ifRefCmd
forRefCmd
foreachRefCmd
whileRefCmd
breakRefCmd
multiFlows
parallelRefCmd
transactionCmds
beginTransactionRefCmd
commitTransactionRefCmd
rollbackTransactionRefCmd
sqlTransactionCmds
sqlBeginTransactionRefCmd
sqlCommitRefCmd
sqlRollbackRefCmd
exceptions_intro
tryRefCmd
throwRefCmd
returnRefCmd
svcErrorHandling
debugCmds
displayRefCmd
assertRefCmd
metadataCmds
emml_metaRefCmd
macro_metaREfCmd
presto-metaRefCmd
user-metaRefCmd
migrateMashupVersions
expressionsIntro
xpath2_intro
xmlEscaping
customXPathFunctions
xquery_intro
mashupExpressions
dynamicStrings
advMashupIntro
mashupHTTPHeaders
svcAuthNHeaders
normalizeData
dateManipulation
convertFloat2Decimal
addCharacterEntities
serverSideBinding
uniqueFilter
setResponseCharEncoding
cdataSections
webClipping
htmlDocumentVars
jsonFormat
wrapPOJO
wrapWSDLHTML
prePostProcess
selfJoin
outerJoinXquery
macro_intro
macroRefCmd
macro_libraries
macrosRefCmd
macro_library_include
includeRefCmd
macro_use
macroUseRefCmd
dynamicEMMLIntro
createTemplateMashupScript
templateRefCmd
generateDynamicEMML
mashupQueryServices
userMetatdataQueries
prestoMetadataQueries
svcDependencyQueries
mashupExamples
utilities-intro
testMashupCmd
publishMashupCmd
updateMashupCmd
pubMacroCmd
profilingUtil
emmlReference
help.editor.emml
autoGenInvoke
macroAutoGen
editMashup
testMashup
publishMashup
raqlIntro
raqlQueries
help.raql.explorer
raqlExplorer
escapeChars
sqlStream
invokeStream
snapshotStream
selectDistinct
selectAs
selectFunctions
fromPathName
validNames
reservedKeywords
fromSubQ
fromLimit
whereConditions
whereLike
whereIn
whereBetween
whereParams
literalValues
whereFunctions
orderByComplex
orderByFunctions
groupByComplex
havingClause
overWindows
overRunningCalcs
overRank
overFunctions
multipleDatasets
raqlDynamicQuery
migrateQueries37to38
dataTypesFormats
operators
raqlFunctions
userDefinedFunctions
raqlSyntax
raqlCache
raqlCacheMemory
cacheStore
cacheLoad
raqlEMML
loadExtStmt
raqlExtStmt
snapshotExtStmt
storeExtStmt
streamExtensions
fileExtensions
schemaExtensions
raqlExamples
view_library_intro
addViews
aboutViews
manageViews
commonChartTasks
angularGauge
help.view.area
areaChart
help.view.bar
barChart
help.view.bubble
bubbleChart
help.view.bulbgauge
bulbGauge
help.view.bulletgauge
bulletGauge
help.view.candlestick
candlestick
help.view.column
columnChart
cylinderGauge
doughnutChart
help.view.feed
feedReader
help.view.funnel
funnelChart
help.views.gantt
ganttChart
gaugesIntro
help.view.gauges
help.view.geomap
geoMap
help.view.googlemap
googleMap
help.view.grid
gridView
help.view.intensitymap
intensityMap
help.view.kagi
kagi
help.view.ledgauge
LEDGauge
help.view.line
lineChart
help.view.rt.linechart
rtLineChart
help.view.lineargauge
linearGauge
help.view.marimekko
marimekko
help.view.pareto
pareto
help.view.pie
pieChart
help.view.propertytable
propertyView
help.view.pyramid
pyramidChart
help.view.radar
radar
help.view.scatter
scatterChart
help.view.sparkline
sparkline_simple
help.view.sparklinecolumn
sparkline_column
help.view.sparklinewinloss
sparkline_win_loss
help.view.splineArea
splineArea
help.view.splineLine
splineLine
help.view.stepLine
stepLineChart
help.views.template
template
help.view.thermometer
thermometerGauge
help.view.zoomline
zoomLineChart
viewsAdvProperties
createCustomView
customViewClass
viewClassResults
viewClassEvents
customLibCSS
customLibProperties
customViewImport
customLibVersions
app_library_intro
help.app.maker
appCreateBasic
help.details.app
app_details
editAppProperties
deviceCompatibility
aboutAppTBButtons
publish2Store
mashboard_intro
help.mashboard
mashboard_designer
findApps
aboutViewsInWS
editWorkspace
manageRowCols
editWSSizeSpanPad
manageTabsPages
desktopLayoutConfig
webPageLayout
rtLineChartIntro
addPPMChart
ppmChartCustomActions
ppmChartFilterSelectEvents
ppmAboutFilters
drillDown
addFilter
filterEdit
addForm
editForm
formFields
addGoogleGadget
addHTML
addObject
addHTMLPage
addJS
mashletWiring
help.workspace.wiring
aboutSubscription4BasicApp
hideAppInputForms
onloadSynchApps
manageWiring
help.app.store
appStoreIntro
appstorePending
mobileIntro
mobileAppStore
app_dev_intro
editor_features
basicAppCustomizeIntro
basicAppThemes
basicAppLayout
basicAppChartAttributes
help.editor.app
editor_intro
getSetProperties
handleResize
handleRefresh
handleExceptions
wiringIntro
wiringTightlyCoupled
wiringWildCardTopics
wiringLooselyCoupled
topicPayloads
registerSamples
resourceVersions
appStructure
appParamsRef
appSpecIntro
appRef
authorsRef
dependsonRef
descriptionRef
helpRef
iconsRef
prestoMetaRef
propertiesRef
contentRef
requiresRef
titleRef
topicsRef
appFiles
add_on_intro
excel_splash
excelToolbarInstall
excel_toolbar
configFile
configSvrConnection
importIntro
importSvc
selectImportNodes
importSvcUpdateParams
importDataUpdates
refreshImportedSvc
removeImportedSvc
registerExcelIntro
registerExcelSvc
registerExcelRange
registerExcelFile
registerCSV
validExcelSvcs
updateExcelSvc
removeExcelSvc
portal_intro
portalInstall
portal_arch
migratePortal
portal_add_mashup_portlet
portal_add_app_portlet
portal_update_portlets
sharepoint-intro
p4spIntro
installSPAddOn
installSPConn
installTrblShoot
migrate
installUpgradeMashupServers
adminlIntro2010
authNIntro2010
authNUX2010
authNDesigns2010
configIntro2010
configFeatures2010
configAuthN2010
configConnections2010
miscConfig2010
admin2010
adminIntro2007
authNIntro20007
authNUX2007
authNDesigns2007
configIntro2007
configFeatures2007
configAuthN2007
configConnections2007
miscConfig2007
admin2007
userCredentialAttributes
introUser
createWPPage
mashupWPAdd
mashupPublish
mashupWPToolbar
mashupUpdate
mashupPublishNoWP
mashupECTList
regListAsSvc
inputParams
appAddWP
appPublish
appWPToolbar
appUpdate
devIntro
restCreateConnection
pc4jsCreatePrestoConnection
artifactTechSpec
pagination
attrMappingExpressions
aboutJUMP
jumpRequestParams
svcHeaders
presto_apis_intro
restAPIRef
prestoHeadersParams
snapshot_api_intro
snapshotCaptureRef
snapshotGetRef
snapshotScheduleRef
snapshotsManageJobs
aboutDTevents
help.api.console
apiConsole
admin_intro
help.manage
getStarted
sysReqPresto
whatIsInstalled
startPrestoServer
startupOrder
upgradeLicense
help.admin.license
moveRepository2NewDB
moveDBMSSql
moveDBMySql
moveDBOracle
moveDBPostGres
help.admin.ldap
userRepositoryLdap
userRepositoryCreate
manageUsers
manageUserGroups
defaultGroups
postInstallOptional
securityIntro
changePassword
authN
builtinUsers
authNSSO
configUserCertificates
authZ
builtinPermissionsNGroups
defaultRunPermissions
configSearchFilter
setAuthZ
configServerIntro
memoryReqs
configCharSetNLocale
confighelpurl
configTheme
configDefaultChartTheme
configCustomPorts
configMashSvr4Proxy
configProxyWhitelist
configSSL2Server
configSSLAppServer
configSSLAdminConsole
configSSLJava
aboutLogs
configLogging
startStopAuditLog
aboutNotifications
configMailServer
configLDAPemailAttr
configSPAddon
bigMemoryIntro
configBMServers
configBMDeclaredCaches
configBMDynamicCache
cachingSvcResponse
help.admin.datasource
manageDataSource
configDBGenerator
manageCategories
manageProviders
attrIntro
manageGlobalAttr
accessUserRepositoryAttrs
manageFlexibleAttr
configMashupFeatures
configHTTPResponseHeader
configHTTPRequestTimeout
enableSnapshots
configNormalization
nsdCompile4WSDL
addMapperSchema
mzConfigIntro
mzConfigBasic
mzMemoryReqs
mzNewResourceDir
mzManageResourceDir
mzConfigProxy
mzGoogleMap
mzImportExportFeeds
mzNewDBConnections
mzManageDBConnections
mzDisableNewFeeds
mzEnableAdmin
rtbsIntro
rtbsManageBuffer
rtbsEventTypeStoreConnection
rtbsEDAConnection
rtbsBufferEdit
rtbsBufferCopy
rtbsBufferDelete
rtbsBufferImport
rtbsBufferExport
rtbsManageApama
rtbsApamaConnection
rtbsApamaEdit
rtbsApamaCopy
rtbsApamaDelete
rtbsApamaImport
rtbsApamaExport
rtbsBufferStartStop
rtbsBufferRestartAll
ppmIntro
ppmManageConnections
ppmConfigConnection
ppmEditConnection
ppmDeleteConnection
ppmImportConnection
ppmExportConnection
importPMMChartApp
repositoryIntro
repositoryConnPool
help.admin.rdspool
repositorySynchTZ
monitorIntro
viewLogs
purgeAuditLog
help.admin.libraries
manageLibraries
help.files
files_intro
migrateAllResources
migrateExtensions
migrateRepository3.1
migrateRepository3.2
migrateRepository3.5
migrateRDS3.5JAR
migrate3_1AppsTo3_2
migratePolicyConfig3_2
migratePolicy3_5
migratePolicies3.6
migrate3-2MacroService
migrateRAQL3.6.1
migrateTo3.7
migrate2raql37
deploymentIntro
deployArtifacts
exportServices
exportMacros
exportApps
exportLibraries
exportGlobalAttr
exportUsersNGroups
importServices
importMacros
importApps
importLibraries
importGlobalAttr
importUsersNGroups
deployMultipleUnclustered
clusteringIntro
repositorySharing
externalConfigFolder
clusterSharedJDBC
otherResources