DATA Step, Macro, Functions and more

Reading ServiceNow with SAS

Reply
New Contributor tcv
New Contributor
Posts: 2

Reading ServiceNow with SAS

Our site just started using the web based product ServiceNow.  It stores it's data in databases for which I have an ODBC on my PC has anyone read this data using SAS

Super User
Posts: 19,878

Re: Reading ServiceNow with SAS

If it has an ODBC you can connection via a libname and then you should be good to go, similar to any other ODBC connection.

 

Does that method not work for you?

New Contributor tcv
New Contributor
Posts: 2

Re: Reading ServiceNow with SAS

I tried the LIBNAME and PROC SQL connect they both time out with no data.

 

ERROR: CLI error trying to establish connection: [SN][ODBC ServiceNow driver][OpenAccess SDK

SQL Engine]Cannot connect to the instance. [dataSource=ServiceNow]

[user=odbc.user]java.net.SocketTimeoutException: connect timed out[1001]

 

Community Manager
Posts: 2,956

Re: Reading ServiceNow with SAS

ServiceNow is software-as-a-service, correct? It would surprise me they allowed access to a database directly, and if they did, access might be provisioned via a whitelisted IP address.  

 

However, they do have REST APIs, and that might be the more robust method for accessing this.  You can use PROC HTTP and the JSON libname engine to fetch and parse the information you need.  I have several examples of doing similar work with other web services.

Ask a Question
Discussion stats
  • 3 replies
  • 115 views
  • 0 likes
  • 3 in conversation