Connect does not have an explicit command for validating staging.user rows, but if an upload encounters any errors during execution, messages are written to the staging.user_exception table.

 

To confirm that there were no errors, we can query that table:

 

1 SQL> select * from staging.user_exception;

 

 

The fact that, in our example, the query returns 0 rows confirms there were no exceptions.

 

The upload writes the staging data to the xactly.xc_user table, which we can now query for our new User data:

 

1 SQL> select user_id, email, name, created_date, modified_date, created_by_name

from xactly.xc_user x

where “email” in (select email_address from staging.user);