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 All > 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.
Parent Topic:Getting started with ODBC
Previous topic:Getting started with ODBC
Next topic:Define an ACL rule for the odbc role