Version
Chapter 65. Language Reference
This chapter describes the syntax of CloverDX Transformation Language - CTL. CTL can be used to define transformations in many components.
This section describes the following areas:
-
CloverDX Designer
- CloverDX Overview
- Installation
- Configuration
-
Using Designer
- Designer User Interface
- Projects
- Graphs
- Execution
- Common Dialogs
- Import
- Export
- Graph Tracking
- Search Functionality
- Working with CloverDX Server
-
Graphs
- Components
- Edges
- Metadata
- Connections
- Lookup Tables
- Sequences
- Parameters
- Internal/External Graph Elements
- Dictionary
- Notes in Graphs
- Transformations
- Data Partitioning (Parallel Running)
- Data Partitioning in Cluster
- Subgraphs
- Jobflow
-
Data Services
- Data Services Introduction
- Architecture
- Development
-
Use cases
- Custom Serialization
- Using Static File as Response
- Sending a File Generated by .rjob
- Publishing a Static File
- Using CTL2 Functions in Data Services
- Data Service that Receives a File or Text in Body Part
- Converting Graph to Data Service
- Converting Graphs to Data Service
- Publishing Data Service
- Publishing Multiple Data Services at Once
- Unpublishing Data Service
- Unpublishing Multiple Data Services at Once
- Example
- Troubleshooting
-
Component Reference
-
Readers
- Common Properties of Readers
- CloverDataReader
- ComplexDataReader
- CustomJavaReader
- DatabaseReader
- DataGenerator
- DBFDataReader
- EmailReader
- FlatFileReader
- HadoopReader
- JavaBeanReader
- JMSReader
- JSONExtract
- JSONReader
- LDAPReader
- MongoDBReader
- MultiLevelReader
- ParallelReader
- QuickBaseRecordReader
- QuickBaseQueryReader
- SalesforceBulkReader
- SalesforceReader
- SpreadsheetDataReader
- UniversalDataReader
- XMLExtract
- XMLReader
- XMLXPathReader
-
Writers
- Common Properties of Writers
- CloverDataWriter
- CustomJavaWriter
- DatabaseWriter
- DB2BulkWriter
- DBFDataWriter
- EmailSender
- FlatFileWriter
- HadoopWriter
- InfobrightBulkWriter
- InformixBulkWriter
- JavaBeanWriter
- JavaMapWriter
- JMSWriter
- JSONWriter
- LDAPWriter
- MongoDBWriter
- MSSQLBulkWriter
- MySQLBulkWriter
- OracleBulkWriter
- PostgreSQLBulkWriter
- QuickBaseImportCSV
- QuickBaseRecordWriter
- SalesforceBulkWriter
- SalesforceWriter
- SalesforceWaveWriter
- SpreadsheetDataWriter
- StructuredDataWriter
- TableauWriter
- Trash
- UniversalDataWriter
- XMLWriter
- Transformers
- Joiners
- Job Control
- File Operations
- Data Partitioning
- Data Quality
- Others
- Deprecated
-
Readers
-
CTL2 - CloverDX Transformation Language
- CTL Overview
- Language Reference
- CTL Debugging
-
Functions Reference
- Conversion Functions
- Date Functions
- Mathematical Functions
- String Functions
- Mapping Functions
- Container Functions
- Record Functions (Dynamic Field Access)
- Miscellaneous Functions
- Lookup Table Functions
- Sequence Functions
- Subgraph Functions
- Data Service HTTP Library Functions
- Custom CTL Functions
- List of All CTL2 Functions
- CTL2 Appendix - List of National-specific Characters
-
Tutorial
-
Creating a Transformation Graph
- Terminology
- Creating a Project
- Creating a New Data File
- Creating a Graph
- Placing Components in the Graph Editor Pane
- Connecting Components by an Edge
- Extracting Metadata from the Input File
- Assigning Metadata to the Edges
- Setting Up Readers (FlatFileReader)
- Setting Up Writers (SpreadsheetDataWriter)
- Running the Graph
- Opening the Output File
- Filtering the records
- Sorting the Records
- Processing Speedup with Parallelization
- Debugging the Java Transformation
-
Creating a Transformation Graph
-
CloverDX Server
- Introduction
- Installation
- Configuration
-
Administration
- Monitoring
- Temp Space Management
- Secure Parameters
- Users and Groups
- Sandboxes - Server Side Job Files
- Server Configuration Migration
- Upgrading Server to Newer Version
- Support Package
- Diagnostics
- Troubleshooting Worker
-
Using Graphs
- Graph/Jobflow Parameters
- Tasks
- Manual Task Execution
- Scheduling
- Viewing Job Runs - Execution History
- Listeners
- Recommendations for Transformations Developers
- Extensibility - CloverDX Engine Plugins
- Troubleshooting
-
API
- Simple HTTP API
- JMX mBean
- SOAP WebService API
- Launch Services
-
Data Services
- Data Services Overview
- User Interface
-
Using Data Services
- Deploying Data Service
- Publishing and Unpublishing Data Service from Sandbox
- Publishing Data Service Examples
- Changing Data Service to Anonymous
- Running Data Service on HTTPS
- Running Data Service on HTTPS on Cluster
- Monitoring Data Service
- Testing Data Service
- Performance Tuning
- Exporting Data Service Configuration
- Importing Data Service Configuration
- Avoiding Premature Marking of Data Service as Failing
- Looking up Particular Data Service
- Resetting State of Failing Data Service Endpoint
- Custom HTTP Headers
- Data Services on Cluster
- Data Apps
- Cluster
- Security
-
CloverDX Profiler
- About CloverDX Data Profiler
- Installation
- Configuration
- Using Profiler
- Profiling Jobs
- Reporting Console
- Profiler and CloverDX Graphs
- List of Metrics