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 and pipelines.

 

xSQL supports the following operations:

 

• Sales Orders

• Validate data in staging.order_item and staging.order_item_assignment tables.
• Upload order data from staging into Incent.
• Purge or delete order batches from Incent.

 

• Execute Incent Calculations

• Reset Incent credit and incentive rule calculation results.
• Execute credit and incentive rules configured within Incent.

 

• HR Data

• Upload Users from staging tables into Incent.
• Delete or update user records found in Incent.

 

In the following examples, we’ll learn how to load and validate orders, run calculations, and reset/purge. Then we’ll load a bunch of different HR data types into Incent.