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

You're welcome saanvisharma. Would you mind marking one of the responses are correct so that we can close this thread?



Thanks,


Berny


I can't download the Service now ODBC with my ServiceNow SSO login, it keeps reposting the ODBC view to the download. Very frustrating! 

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.


Thank you, Dave Smith


bernyalvarado
Mega Sage

Hi saanvisharma, do you have any further questions on this topic? Is there anything else around this question that we can help you with?



Thanks,


Berny