09-25-2017 08:29 AM
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
09-25-2017 08:45 AM
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.