Customizer
Twister Data Integrator 3.7.0.0
Controller Guide
Getting Started
Welcome
Overview of the Controller and Node
What's New in v.3.7
System Requirements
Concepts
Introduction to the Dashboard
Running & Managing Projects
The Summary Panel
Viewing Project Details
Applications
Job Statistics
Flow Graphs
Runtime Configuration
Triggers
Version History
Running & Managing Jobs
The Summary Panel
Viewing Job Details
Running & Managing Services
Using Triggers
Managing Alerts
Global Resources
Managing Nodes
The Summary Panel
Viewing Node Details
Managing Processes
Creating Data Services
Managing the Environment
Monitoring Statistics
Adjusting Configurations
Managing Artifacts
Managing Distributions
Managing Users
Managing Groups
License Agreements
Terms and Conditions
Acknowledgements
Apache License v2.0
Creative Commons Attribution 3.0
Lesser General Public License
Bouncy Castle License
Eclipse Public License
Flamingo License
HSQL License
JDOM License
jGoodies License
JGraph License
JTidy License
Paranamer License
PostgreSQL License
SLF4J License
XStream License
Designer Guide
Introduction
Concepts
Project Types
Data Services
Subgraphs
Data Flows
Components
Connections
Data Records
Phases
Expressions
Workspace
Global Resources
Tour of the Application
The Window
Start View
Menu and Toolbar
Application Project
Design View
Runtime View
Service Project
Design View
Runtime View
Library Project
Design View
Dialogs and Wizards
About Dialog
Activation Wizard
Add Graph Dialog
Component Source Dialog
Connector Properties Dialog
Container Properties Dialog
Database Browser
Core Concepts
Adding an Object to a Query
Joining Tables
Selecting Output Fields
Sorting Output Fields
Defining Criteria
Grouping Output Fields
Defining SQL Query Properties
Advanced Topics
Working wih Sub-Queries
Working with Derived Tables
Working with Unions
Deploy Project Dialog
Dump Handling Dialog
File Server Browser
Global Resources Dialog
Log Viewer
New Project Wizard
Note Editor Dialog
Preferences Dialog
Processes Dialog
Project Properties Dialog
Prompt for Arguments Dialog
Runtime Debug Data Dialog
Command-line Tools
twisterdesigner
twister
Tasks
Create a New Project
Defining Database Connections
Defining File Servers and Directories
Updating the Application
Adding and Removing 3rd Party Components
Installing JDBC Drivers
Handling Dumped Records
Deploying a Project to the Controller
Reference
SQL Statement Assistant
Database Table Assistant
Field and Variable Naming Rules
Data Types
STRING
BOOLEAN
INTEGER
LONG
FLOAT
DOUBLE
DECIMAL
DATE
URL
FILE
XML
BLOB
CLOB
SERIALIZABLE
License Agreements
Terms and Conditions
Acknowledgements
Apache License v2.0
Apple License
Bouncy Castle License
Common Public License
Creative Commons Attribution 3.0
DOM4J License (BSD)
Eclipse Public License
Flamingo License
HSQL License
IBM Public License
Indiana University Extreme Lab License (BSD)
Jaxen License (BSD)
JDOM License
JFreeChart License
jGoodies License
JGraph License
JTidy License
Lesser General Public License
Paranamer License
PostgreSQL License
SLF4J License
XStream License
Scripting Guide
Overview
System Variables
Expression Syntax
Controller Guide
Getting Started
Welcome
Overview of the Controller and Node
What's New in v.3.7
System Requirements
Concepts
Introduction to the Dashboard
Running & Managing Projects
The Summary Panel
Viewing Project Details
Applications
Job Statistics
Flow Graphs
Runtime Configuration
Triggers
Version History
Running & Managing Jobs
The Summary Panel
Viewing Job Details
Running & Managing Services
Using Triggers
Managing Alerts
Global Resources
Managing Nodes
The Summary Panel
Viewing Node Details
Managing Processes
Creating Data Services
Managing the Environment
Monitoring Statistics
Adjusting Configurations
Managing Artifacts
Managing Distributions
Managing Users
Managing Groups
License Agreements
Terms and Conditions
Acknowledgements
Apache License v2.0
Creative Commons Attribution 3.0
Lesser General Public License
Bouncy Castle License
Eclipse Public License
Flamingo License
HSQL License
JDOM License
jGoodies License
JGraph License
JTidy License
Paranamer License
PostgreSQL License
SLF4J License
XStream License
Designer Guide
Introduction
Concepts
Project Types
Data Services
Subgraphs
Data Flows
Components
Connections
Data Records
Phases
Expressions
Workspace
Global Resources
Tour of the Application
The Window
Start View
Menu and Toolbar
Application Project
Design View
Runtime View
Service Project
Design View
Runtime View
Library Project
Design View
Dialogs and Wizards
About Dialog
Activation Wizard
Add Graph Dialog
Component Source Dialog
Connector Properties Dialog
Container Properties Dialog
Database Browser
Core Concepts
Adding an Object to a Query
Joining Tables
Selecting Output Fields
Sorting Output Fields
Defining Criteria
Grouping Output Fields
Defining SQL Query Properties
Advanced Topics
Working wih Sub-Queries
Working with Derived Tables
Working with Unions
Deploy Project Dialog
Dump Handling Dialog
File Server Browser
Global Resources Dialog
Log Viewer
New Project Wizard
Note Editor Dialog
Preferences Dialog
Processes Dialog
Project Properties Dialog
Prompt for Arguments Dialog
Runtime Debug Data Dialog
Command-line Tools
twisterdesigner
twister
Tasks
Create a New Project
Defining Database Connections
Defining File Servers and Directories
Updating the Application
Adding and Removing 3rd Party Components
Installing JDBC Drivers
Handling Dumped Records
Deploying a Project to the Controller
Reference
SQL Statement Assistant
Database Table Assistant
Field and Variable Naming Rules
Data Types
STRING
BOOLEAN
INTEGER
LONG
FLOAT
DOUBLE
DECIMAL
DATE
URL
FILE
XML
BLOB
CLOB
SERIALIZABLE
License Agreements
Terms and Conditions
Acknowledgements
Apache License v2.0
Apple License
Bouncy Castle License
Common Public License
Creative Commons Attribution 3.0
DOM4J License (BSD)
Eclipse Public License
Flamingo License
HSQL License
IBM Public License
Indiana University Extreme Lab License (BSD)
Jaxen License (BSD)
JDOM License
JFreeChart License
jGoodies License
JGraph License
JTidy License
Lesser General Public License
Paranamer License
PostgreSQL License
SLF4J License
XStream License
Scripting Guide
Overview
System Variables
Expression Syntax
Twister Data Server
Introduction
Administrator Guide
License Activation
Registry
Overview
Main (Home) Page
Manage Stored Procedures
Add Stored Procedure
General Attributes
Input Parameters
Remote Queries
Configure JDBC Query Component
Configure XML-HTTP Query Component
Configure Apache Solr Query Component
Configure Marklogic Query Component
Configure SOAP Query Component
Correlated Query
View Templates
View Stored Procedure Configuration
Edit Stored Procedure
Delete Stored Procedure
Test Stored Procedure
Manage Connection Pools
Add Connection Pool
View Connection Pool Configuration
Edit Connection Pool
Delete Connection Pool
Manage Index Schemas
Add Index Schema
General Attributes
Schema Fields
Sources
Configure Apache Solr Source Component
Configure JDBC Source Component
View Index Schema Configuration
Edit Index Schema
Delete Index Schema
Test Index Schema
Export
Import
Performance Metrics
Access Controls
User Authentication - Web Interface
User Authentication - JDBC/ODBC Interface
RBAC for Stored Procedures and Index Schemas
Logging Support
Clustering and Load Balancing
System Properties
ODBC Setup
User Guide
JDBC Interface
RESTful Web Interface
RESTful API for Stored Procedures
Specification
Java Client
RESTful API for Index Schemas
Specification
Java Client
Index Query Syntax
SOAP Interface
Technical Support
Introduction
Administrator Guide
License Activation
Registry
Overview
Main (Home) Page
Manage Stored Procedures
Add Stored Procedure
General Attributes
Input Parameters
Remote Queries
Configure JDBC Query Component
Configure XML-HTTP Query Component
Configure Apache Solr Query Component
Configure Marklogic Query Component
Configure SOAP Query Component
Correlated Query
View Templates
View Stored Procedure Configuration
Edit Stored Procedure
Delete Stored Procedure
Test Stored Procedure
Manage Connection Pools
Add Connection Pool
View Connection Pool Configuration
Edit Connection Pool
Delete Connection Pool
Manage Index Schemas
Add Index Schema
General Attributes
Schema Fields
Sources
Configure Apache Solr Source Component
Configure JDBC Source Component
View Index Schema Configuration
Edit Index Schema
Delete Index Schema
Test Index Schema
Export
Import
Performance Metrics
Access Controls
User Authentication - Web Interface
User Authentication - JDBC/ODBC Interface
RBAC for Stored Procedures and Index Schemas
Logging Support
Clustering and Load Balancing
System Properties
ODBC Setup
User Guide
JDBC Interface
RESTful Web Interface
RESTful API for Stored Procedures
Specification
Java Client
RESTful API for Index Schemas
Specification
Java Client
Index Query Syntax
SOAP Interface
Technical Support