Access CMDB data from on-prem application using jdbc

[Kbuddy]

Hello

We have a requirement to query and read the data from CMDB tables which is hosted on cloud. External application which reads data from CMDB is hosted on-prem. The volume of queries to CMDB tables will be in high. What is the best way to fetch the data from CMDB tables? I have thought of two options either use jdbc connector to query CMDB tables or use REST API to directly access CMDB endpoints. But I have to also consider the CMDB data volume and number of queries triggered by application.

Actively looking for the feedback.

Thanks, 

[AJ-TechTrek]

Hi @Kbuddy ,

You can configure the JDBC datasource configuration, You need the JDBC URL and Credentials to get the cmdb data.

https://docs.servicenow.com/bundle/tokyo-platform-administration/page/administer/import-sets/referen...

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

ServiceNow Community Rising Star 2024

[Sohail Khilji]

You onprem app is servicenow or any other application ?

Suggest to got with JDBC over REST API, 

1. For JDCB you will be using a mid server for which you can create a seprate queue which is balance your load for processing.

2. Field mapping / sql query  becomes easy for JDBC type. were as in rest api parsing becomes hard job.

3. try to split the pull request based on classes and schedule them at timely intevals during non business hours.

i hope this helps...

[Kbuddy]

The app is an external application (event management solution) which is on-prem