Craig Talbert's Weblog

Google Plus Facebook Twitter LinkedIn RSS

ServiceNow's ODBC driver is a wrapper for ServiceNow's SOAP interface

posted 10-11-2012 at 12:35

I setup ServiceNow's ODBC driver and then setup a Linked Server to connect to one of our ServiceNow instances from SQL Server Management Studio. When you run a SQL query from SSMS on your ServiceNow instance and check the v_user_session table, it seems to be using SOAP to pull the data and then doing any necessary work for joins or aggregates in the driver code.

Results oD ODBC queries

We've been trying to troubleshoot some problems where data that's in an instance database doesn't always show up in the view mappings of particular tables (the .do URLs also used for the SOAP interface). I've always thought of ODBC drivers as connecting "directly" to a given database, but in this case the driver connects to the model (database) through the view. I have to say it's a pretty creative approach, I wouldn't have thought of implementing an ODBC driver in that way.

category: /servicenow | click to comment (permanent link to this entry)

Very important rectangles

Creative Commons License Blogshares  BlogTopSites

XHTML Friends Network (XFN)

The Audio Prof, Digital News Test Kitchen, CU Libraries News, CU Money Sense, sciencegeekgirl, Exemplary Support (Chris Bell), Jeeg Salbian, Paul O'Brian University Communications CU ATLAS CU Boulder Career Services

This weblog is not meant to represent the University of Colorado in any respect; the information and opinions contained herein are solely my own.

powered by blosxom