Accessing Analytics This section describes how to access and exit Xactly Analytics. How to … Access Xactly Analytics 1. Log into Xactly Incent. 2. Choose Analytics using the Xactly menu. [&helli...
Select
Introducing Analytics Terms
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...
SELECT (DML)
SELECT (DML) Summary The SELECT statement retrieves rows from a table. Syntax Basic SELECT Syntax SELECT FROM <schema_name.table_name> WHERE GROUP BY HAVING ORDER BY UNION|UNION ALL|DIFFERENCE ...
Send Email from Connect
Send Email from Connect Connect enables you to compose and send email messages. What’s more, you can integrate these email message objects into your processes using steps and pipelines. For [&hellip...
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...
Create Schemas and Tables (DDL)
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...
Select a Person Version
Select a Person Version You can quickly select a person version, if applicable, using the user menu. Click the Welcome link. A drop-down menu similar to the following appears: […]
INSERT
INSERT with a Value List Use INSERT statements with literal values to add new rows to a table. For example: 1 SQL> insert into staging.order_item(batch_name, order_code, item_code, incentive...
SELECT
Use SELECT to query a table or function-derived table. SELECT requires both the schema name and the table name for a given table, and returns a result set. For example, […]
Send Email with Attachments from SELECT
One of the most useful features of Connect email is the ability to query data tables and generate email attachments on the fly. For example, your ETL pipeline might execute […]