Question

Sync users/requesters from external SQL database

  • 19 September 2023
  • 1 reply
  • 38 views

Userlevel 1
Badge +2

We have a SQL database maintained by IT that includes all users (and associated data) we would want to sync into FreshService? There are options to sync AD, Azure, etc., but is it possible to sync our users/requesters with our SQL database?


1 reply

Userlevel 6
Badge +11

Hi.

Interesting.

You can perform API calls from SQL Server Broker or other, so, theoretically, yes, you should be able to maintain FS data when data in SQL Server is created/updated.

I’d suggest to take a look to:

Service Broker: Scalable Web Service Calls From SQL Database (maskalik.com)

sql server 2005 - Can a SQL trigger call a web service? - Stack Overflow

 

Hope this helps.

 

Regards,

Reply