Post date: Mar 07, 2014 5:34:1 PM
In my business group, we also support Oracle EBS for the company and we utilize Oracle Service Requests for managing internal support requests for our business applications. One of the things that we do each and every day is to log the number of open tickets for each area into a SharePoint list. I have developed a SQL report that easily provides us with the numbers that we are to input into the list entry; however, the next step that I would like to take is to have this automated.
I have found a very interesting SharePoint bolt-on called "iLove SharePoint". Specifically, this tool can expand SharePoint Workflows by creating an action to execute SQL to a seperate SQL server. Documentation on this can be found here: http://www.ilovesharepoint.com/2011/02/execute-sql-action-advanced-sharepoint.html. I can actually have the users create the list item without numbers, because they have to type up notes as to how the day went, and then the WF would fire up with the list item creation and fetch/populate the numbers automatically.
While this is built for 2010, it may also work with 2013. Of course another option is to custom build a workflow in Visual Studio, but I was looking at this bolt-on because there are a number of other actions that are also created and then they are reusable for the users who do not know how to write code but can maneuver in SPD.
Hopefully more to come soon.