Create an ODBC user account and assign the odbc role

Create an ODBC user account and assign the odbc role

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

Navigate to User Administration > Users.

Click New.

In the User ID field, enter
odbc.user.

Enter a Password for this user.

From the form context menu, select Save.

In the Roles related list, click
Edit.

Use the slushbucket to add the odbc role, and then click
Save.

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.