Integrating SQL Database with Servicenow

[Community Alums]

Hello,

We are having a requirement to integrate SQL Database with Service-now platform. Clients are going to load the data to the SQL Database instead of loading data to service-now through file system integration.

So, now we need to just display the data from database to the service-now tables based on user requirement.

Can someone please guide us to go ahead on this requirement.

Thanks in advance.

[sachin_namjoshi]

You can achieve this configuring JDBC data source to read records from SQL table in service now tables.

Check below for details

https://docs.servicenow.com/bundle/newyork-platform-administration/page/administer/import-sets/refer...

Regards,

SAchin

[Community Alums]

Hi Sachin,

Is there a way that we can achieve this requirement by REST API Calls? As we want to show the data on service portal, JBDC many be slow down the data fetching process. 

Regards

Prudhvi 

[Harsh Vardhan]

are you able to get the endpoint ? if yes then you can use that in your rest message and based on that you can do the further work. 

sample Video :

How to Expose a SQL Database via a REST API in 5 Minutes

jdbc should also work here , if you have correct sql queries mentioned in "SQL statement" field then it should not take huge time to fetch the data. 

[Community Alums]

Is there a way to create endpoint for a table in SQL server which we can use in reset message?

Regards,

Prudhvi