Query ServiceNow database tables directly

saanvisharma
Kilo Contributor

Does anyone query the ServiceNow database tables directly, outside of ServiceNow?   What tool do you use?   What type of db is ServiceNow?

Thank you

1 ACCEPTED SOLUTION

Dave Smith1
ServiceNow Employee
ServiceNow Employee

Saanvi Sharma wrote:



Does anyone query the ServiceNow database tables directly, outside of ServiceNow?


There's no such thing.



You can query the ServiceNow tables within the platform, or you can query the MySQL database that sits below the ServiceNow instance, outside of the platform.



But if you ever manage the latter (which is highly unlikely), you'll find the names of tables and columns may be mystifying since they're presented as meaningful labels within the platform but abstracted to something else outside of it.



So.. in general, if those tables are used for ServiceNow, stick to interrogating them via the platform.


View solution in original post

10 REPLIES 10

bernyalvarado
Mega Sage

Hi Saanvi,



The right way of doing that is through the TABLE API



Thanks,


Berny


bernyalvarado
Mega Sage

The following should be helpful:



Table API



Thanks,


Berny


bernyalvarado
Mega Sage

Another option is to do it through ODBC:



ServiceNow ODBC Driver Quick Guide



Thanks,


Berny


Thank You bernyalvarado