Connection to Servicenow from VBA excel.

[ashartaqvi]

I am developing a reporting tool in VBA excel(Macro) which requires connection with ServiceNow to fetch the Problem Records data as per the filters provided. This data can be fetched out in excel format to be used further by the macro. But I cannot find any API which can be used to do this connection with ServiceNow. Need help, if anyone has done anything on this before.

[Victor Ruiz]

Here's the ODBC installation and instructions:

ODBC Driver - ServiceNow Wiki

http://wiki.servicenow.com/index.php?title=Using_the_ODBC_Driver_in_Excel#gsc.tab=0

[ashartaqvi]

Thanks Victor,

I checked this link before but i am not able to use this as i cannot see Servicenow as a database here(when it asks for the 'choose data source' to connect, in second step).

When i try to create the ODBC connection(to create a database), it doesnt show the physical installation path of Servicenow on my machine(which could have been "Start > Programs > ServiceNow ODBC > Interactive SQL (ODBC).") .

Servicenow installation i believe is done on the network and i am using it via a internet shortcut.

I am looking for a similar API like what we have for QualityCenter(QC) like -

Set QCConnection = CreateObject("TDApiOle80.TDConnection")

QCConnection.InitConnectionEx "https://qualitycenter/qcbin"

do we have a similar thing for Servicenow?

[Victor Ruiz]

Not sure about the QC like API have you checked the installation path for the SN ODBC:

[ProbirDas]

I feel you need to configure User DSN   as part of the ODBC administrator configuration.