[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4335
  • Last Modified:

SQL database backend with Sharepoint Front-end...how?

Hi,

One of my co-workers and I are working together to implement a new help desk issue tracking front-end using Windows Sharepoint Services 3.0 (WSS).  What's the best way to accomplish this?  We have all Office 2007 applications so we've been playing around with InfoPath and Access.  We also have Sharepoiint Designer 2007 as well, but don't know much about it?  Is one of those our best option, or is there something else out there?

Our Back-end SQL 2000 database has all of our asset information, users, departements, etc in tables already, so we would just need help on the front-end.  Ideally, it would be nice to design something, then publish it right to our sharepoint site somehow, but we're open to anything.

Thanks.

0007
0
trippleO7
Asked:
trippleO7
  • 3
  • 2
1 Solution
 
Robbie_LeggettCommented:
There are templates MS have built for scenarios such as this that you can deploy as ready made sites. Alternatively, you can create your own sites from scratch from within SharePoint.

http://www.microsoft.com/technet/windowsserver/sharepoint/wssapps/templates/default.mspx - templates

http://msdn2.microsoft.com/en-US/library/aa830818.aspx - Is part 1 of 3 - great tutorials.

SharePoint Designer is good for customising the look and feel of the sites and also creating workflow to automate a lot of the document management.

Great website with lots of excellent articles.
0
 
trippleO7Author Commented:
Thanks, I'll take a look at those tutorials.  I have worked with the Sharepoint apps and templates you posted about.  Do you know of a way we can grab one of those applications and modify it to fit our needs?  I do like the appearance of the Help Desk application that was provided, but it lacked e-mail functionality when assigning the Issue Ticket to someone.  Otherwise it might have been perfect.  The call center app didn't work for us either.

0007
0
 
Robbie_LeggettCommented:
You can modify the templates using SarePoint Designer.

Also this 3rd party app may help you with the email side of things if it on an alert type basis:

http://store.bamboosolutions.com/ps-34-5-alert-plus-web-part-available-early-oct-06.aspx
0
 
trippleO7Author Commented:
We're still struggling with SharePoint Designer a little bit, but I think we'll figure it out.  Thanks for the help.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now