The ODBC driver communicates with your ServiceNow instance as a specific user. Create an ODBC user account and assign the odbc role to enable the user to communicate via ODBC.

Before you begin

Role required: admin

About this task

The odbc role contains various additional roles, including the soap_query role required to make ODBC requests and the itil role required to access core tables such as the incident table. You can modify the odbc role to allow access to other tables as needed by adding additional child roles.

Procedure

  1. Navigate to All > User Administration > Users.
  2. Click New.
  3. In the User ID field, enter odbc.user.
  4. Enter a Password for this user.
  5. From the form context menu, select Save.
  6. In the Roles related list, click Edit.
  7. Use the slushbucket to add the odbc role, and then click Save.
  8. Click Submit.

What to do next

In a separate browser session, confirm that the odbc.user is able to log in to your ServiceNow instance.