We are planning tp push data from SQL server database to ServiceNow and make it our source of truth. What would be the best way to move forward ? JDBC/ Mid Server or Scripted Rest API. What would be the correct process for if we go ahead with either. Also the folks managing SQL server database are not familiar with ServiceNow.
The only way to push is REST* (scripted or table) API.
While ServiceNow does have a JDBC driver, it is a read-only limited one which underneath uses SOAP - with all the scalability limitations that brings with it.
