We need some guidance on where we should house data for an application that will have all the data entry performed through SharePoint.
Our team is building a HelpDesk ticketing system in SharePoint. We put in about 100 new tickets a day and make edits to about 200 of them a day. We will rely heavily on the data input to report out time spent on tickets for each department, by each individual on our team, for each end user, etc.
We are debating whether or not we should store the data in SharePoint Lists or store them and SQL Server and expose the data entry screens in SharePoint using External Content Types and SharePoint Lists. Any recommendations on which we should use for this scenario?
The way we see it there are benefits either way:
- Easy to make changes to schema
- Workflows will work without problem
Data in SQL and exposed through External Content Type
- Better reporting ability/ease
- May Scale better
Any pros or cons to either we are missing?