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?
Solved
Sync users/requesters from external SQL database
Best answer by eeha0120
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,
+12Hi.
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,
Elvis Henriquez
Reply
Join the Community
Already have an account? Login.
Sign in to the Community
No account yet? Create an account.
Social Login
Login with LinkedInor use your username
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.