0

I'm struggling a bit with how to connect R to ServiceNow ODBC.

The closest solution I found is https://www.cdata.com/kb/tech/servicenow-odbc-r.rst, but it's using some paid software dependencies to make it work, which I think unnecessary.

If someone else has managed to set up a connection between R and ServiceNow, I would like to learn how.

Afiq Johari
  • 1,372
  • 1
  • 15
  • 28
  • Have you tried using the official ODBC driver distributed by ServiceNow? See https://docs.servicenow.com/bundle/paris-application-development/page/integrate/odbc-driver/concept/c_ODBCDriver.html – Josh Nov 06 '20 at 18:58
  • @JoshNerius, yes thanks for the reply. I found about the ServiceNow ODBC. Thanks :) – Afiq Johari Nov 11 '20 at 02:01

1 Answers1

0

ServiceNow provides its own ODBC driver. Once installed, you can connect to the ServiceNow instance using DBI library.

library(DBI)
con <- dbConnect(odbc::odbc(), .connection_string = "Driver={ServiceNow ODBC Driver 64-bit};", timeout = 10)
Afiq Johari
  • 1,372
  • 1
  • 15
  • 28