Welcome

Hello and welcome to the first lesson in the Xactly Connect Developer’s Guide and Training Lab. The lab contains a series of lessons to introduce you to the Xactly Connect xSQL and Xactly Command Language (xCL). This lessons do not presently cover the Connect REST APIs.

You might have questions about commands and their syntax as you work through the lessons. xSQL and xCL reference guides are available:

First Steps

Before you can interact with your Incent data, you must first:

  1. Install the ODBC driver. Instructions are here: ODBC Driver Install Guides
  2. Login to the Connect data service using a valid set of Incent credentials. Your compensation administrator can create an Incent account for you. The Xactly Connect roles in Incent must be assigned to your user before you can login to the Connect data service.

Login to Connect

Login Example Using isql on Mac

The isql command line SQL client is used throughout the lab to demonstrate the xSQL and xCL command examples and output. isql is available only for Macs and Linux. Windows users may choose to use a SQL editor called RazorSQL. Toad Data Point 4.1+ is another option.

Any of the command examples found in the lab can be copy/pasted and executed in any of the SQL clients.

At your shell prompt, enter isql to show syntax and a list of switches and parameters. 

$ isql

Screen Shot 2016-06-03 at 3.53.23 PM

Use isql to log in to your Incent account.

$ isql ODBC_DSN username password

 

Where:

  • ODBC_DSN is the data-source name specified in your ODBC configuration.
  • username is an Incent user with Xactly Connect privileges.
  • password is the Incent user’s password.

 

When the login succeeds, isql returns a “Connected!” statement. For example:

$ isql -v -n -m20 ODBC_DSN incent_username password

Screen Shot 2016-06-03 at 3.58.03 PM

Test Your Connection

Test your connection with a simple query.

select name, start_date, end_date
from xactly.xc_period;

Screen Shot 2016-06-03 at 4.01.19 PM

 

If you are on Linux, you must add the go command on a separate line (without semicolon) to execute a xSQL query. For example:

1 SQL> show tables;
2 SQL> go

show_tables

If you are on Windows, enter the queries into RazorSQL. (isql is unavailable on Windows.)

 

Log Out

To exit isql and return control to the command prompt, use \quit:

1 SQL> \quit
$

Reminder: If you’re using a different SQL editor, the steps to login, run a query, and exit the program will differ from the isql examples.