Create an ODBC user

All ODBC queries must be performed as a ServiceNow user.

About this task

This user must have the soap role and any other roles that are required to read the tables you want to query. An administrator can create a user within the ServiceNow instance for ODBC queries:

Procedure

  1. Create a new user.
  2. Give the new user the soap_query role.
  3. Give the user any roles needed to view records on the tables you want to query.
    • You may need to create a role with the appropriate ACLs if one does not already exist.
    • It is good practice to grant this user the itil role when querying Task tables.