xCL Reference Guide Table of Contents
xCL Reference Guide Table of Contents
Getting Started
- Incent Upload Hierarchy
- Incent Upload People
- Incent Upload Positions
- Incent Upload Titles
- Incent Upload Users
Incent – Reference Data
- Incent Upload Currency Rates
- Incent Upload Customers
- Incent Upload Geographies
- Incent Upload Products
Incent – Sales Orders
- Incent Create Batches
- Incent Upload Orders
- Incent Upload Order Details
- Incent Validate Orders
- Incent Validate Order Details
Incent – Calculation
Use the following calculation commands only if your implementation does not use Incent’s Process Groups features. Otherwise, perform calculations and reset operations using Process Groups in Incent.
SFTP File System Functions
Xactly Connect provides each client a SFTP to be used for CSV file transfers. CSV files on the SFTP can be used in SQL syntax and function as native tables.
- CopyFile
- DeleteFile
- DirList
- Exists
- MakeDir
- MoveFile
- ReadFile
- ReadFileAsString
- RenameFile
- TouchFile
- WriteFile
3rd Party Connectors
Connect has one 3rd party connector today. More to come…
Code Promotion & Snapshots
Invocations: Steps and Pipelines
Incent Process Queue Logs
Steps
Steps are individual xSQL and xCL statements that are persisted on the Xactly Connect platform. Steps can be invoked individually or as part of a Pipeline.
Schedules
Schedules allow developers to automatically run Steps and Pipelines as specified times.
Pipelines
Pipelines are the ETL mappings within Xactly Connect. A Pipeline is a sequence of Steps (or other Pipelines). Steps are individual xSQL and xCL statements.
Variables
Variables can be defined and used in other XSQL and DCL commands and expressions.