Create Schedule Summary The CREATE SCHEDULE command creates a schedule domain object. Schedules allow developers to automatically run steps and pipelines at specified times. Syntax create schedule [if...

Create Pipeline Summary The CREATE PIPELINE command creates a pipeline domain object. Pipelines allow developers to build and store complex ETL and data processing logic. Syntax create pipeline [i...

Create Email Summary The CREATE EMAIL command creates an email domain object. Syntax create email [if not exists] <email_name> as ([parameter_list]); Parameters Parameter Parameter List Descrip...

The INCENT CALCULATE command enables you to run compensation-plan calculations within Incent. The command can calculate through just credits, just incentives, or both credits and incentives.   NO...

Load Data into Incent xSQL’s INCENT commands allow developers to manipulate data programmatically in the Incent application. INCENT commands can be invoked manually or added to scheduled steps a...

Scheduling Connect Jobs Connect allows you to create, monitor, and manage schedules of your business tasks, that is, the steps and pipelines where you store your Incent data integration processes. Yo...

Read and Write CSV Files With xSQL commands, you can read, write, and manipulate data files located on SFTP servers hosted by Xactly. Connect users have access to the SFTP directories […]

Data Processing with Steps and Pipelines Your primary tool for creating ETL mappings and automating your Incent processes is using step and pipeline domain objects. You can bundle a series of [&helli...

Create and Use Global Variables Connect’s xSQL language allows you to create global variables. These variables persist across sessions and users, and can store: Literal values Expressions that resol...

Create Schemas and Tables Data Definition Language (DDL) enables developers to create and manage Connect domain objects and tables. In this chapter, we’ll learn how to CREATE and DROP schemas [&hell...