The CreatorCon Call for Content is officially open! Get started here.
This video demo shows you the process of configuring a Microsoft SQL linked server with the ServiceNow ODBC driver, allowing you to query tables from a ServiceNow instance directly via the ODBC driver.
This video applies to all supported ServiceNow releases compatible Microsoft SQL Server versions.
Role required: soap_query plus another role that provides read access to the tables you intend to query on the ServiceNow instance.
For best video quality, increase your player resolution to 1080p.
</em></p><p></p><p>This video covers:</p><p><a title="outu.be/aSxzmXYDQHU?t=46s" href="https://youtu.be/aSxzmXYDQHU?t=46s">0:46 Configuring the provider</a></p><p><a title="outu.be/aSxzmXYDQHU?t=1m29s" href="https://youtu.be/aSxzmXYDQHU?t=1m29s">1:29 Configuring general and security settings</a></p><p><a title="outu.be/aSxzmXYDQHU?t=3m14s" href="https://youtu.be/aSxzmXYDQHU?t=3m14s">3:14 Testing the linked server</a></p><p><a title="outu.be/aSxzmXYDQHU?t=4m7s" href="https://youtu.be/aSxzmXYDQHU?t=4m7s">4:07 What to do if you get an error message</a></p><p></p><p>For more information on configuring Microsoft SQL linked server with the ODBC driver, see:</p><p><a title="ki.servicenow.com/index.php?title=Using_ODBC_Driver_in_SQL_Server" href="http://wiki.servicenow.com/index.php?title=Using_ODBC_Driver_in_SQL_Server">ServiceNow product documentation: Using ODBC Driver in SQL Server</a></p><p><a title="i.service-now.com/kb_view.do?sysparm_article=KB0538992" href="https://hi.service-now.com/kb_view.do?sysparm_article=KB0538992">ServiceNow knowledge base: Troubleshooting Linked Server</a></p><p><a title="upport.microsoft.com/en-us/kb/321185" href="https://support.microsoft.com/en-us/kb/321185">Microsoft support: How to determine the version and edition of SQL Server and its components</a></p><p></p><p style="text-align: center;">Your feedback helps us better serve you! Did you find this video helpful? Leave us a comment to tell us why or why not.</p>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
