New answers tagged external-content-type
I would prefer the SharePoint for the tickting system, easy to use customization options Alerts, workflows etc Use BI tools to get the reports archiving the old tickets( if proper planed). Search. Only drawback for advance features you need the Enterprise License. Here are two Example of Ticketing systems, which will help you understand it. ...
Data in SharePoint has more advantage than storing in SQL. Search Workflow Alerts and Emails Automatic remainders Easily scale (Database or by extending farm) Powerview (SharePoint Enterprise) Export to excel and then create adhoc reports Easy form creation (Any change in fields will automatically updates the CRUD UI)
Top 50 recent answers are included