Introducing Analytics Terms Xactly Analytics uses a set of specific terms to describe sections and elements of the application. Terms The following table provides definitions for common terms in Xactl...
Query
Read and Write CSV Files
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 […]
Query Salesforce with SFDC()
Salesforce Connector Query Salesforce with SFDC() Use the SFDC() table function to issue SELECT queries against Salesforce.com objects. Connect’s SFDC() table function returns result sets that you c...
Use Steps and Pipelines
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...
Query a CSV File with ReadFile()
Use the ReadFile() table function to query a CSV file as a Connect table. Use SELECT as you would with a regular database table: 1 SQL> select * from […]
Show and Query Invocations
Use SHOW INVOCATIONS to review details for the executed pipeline. 1 SQL> select id, state, status, object_type, object_name, created_instant, completed_instant from (show invocations) where object_...