Solved

What will 'web services' do for us?

Posted on 2007-11-28
1
128 Views
Last Modified: 2010-04-06
We are a small, mid range service company.  The services we provide could be categorized as facility management.  We are looking to impress a few of our larger clients that we provide services to.  One of the ways we would like to do it is with technology. Specifically, web-enabled technology.  My question is related to getting advice on how to do that in 2008 and I would appreciate ideas.  Here is the typical scenario, they send us requests for service either via email or telephone.  We track/manage and report on the requests in an access database.  When it is time to bill them for the services, we use our main business system which has a SQL Server backend and then we send them invoices either via EDI or paper copies, etc.
Based on that simple overview- how can we collaborate with them?  For instance, it would be great if we could provide them with some live data from our project management (access) application (i.e. project status, notes, updates, open issues, etc...).  I know very little about web services, but is a web service sort of a bridge?  
We have limited technological resources currently- but we are willing to get people trained in these technology areas so that we can have added value to our customers.
All suggestions appreciated!   Thanks
0
Comment
Question by:snyperj
1 Comment
 
LVL 11

Accepted Solution

by:
spoxox earned 500 total points
ID: 20366851
Your current architecture might make it difficult to realize the service goals you envision. In particular, MS Access is not a preferred option for secure, production-level web-based systems.

One relatively painless route to your goal might be to implement a web-based project management/support ticket/request tracking system. There are many; wikipedia will provide some lists. Some are open source (but you pay for service or customization). I don't have a particular recommendation; according to feature sheets I've read there should be a selection of products that would allow clients to sign in and see only their own "business", which might include issue tracking and history, etc. Such tools are generally based on more robust database systems; there are probably some built on SQL Server. I know of options based on MySQL and Oracle. One big issue: importing historical data into a new system might be very tedious and time consuming (read: manual).

If you are forced to live with your existing Access system, it should be possible to partially rewrite it, porting it to a more robust DBMS like SQL Server, and implement a front end that would allow client web login and control over what data clients can see. This might require more technical knowledge than migrating to a new system as proposed above.

In either case, it will be a significant effort that will take a fair amount of time. Best of luck.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Styling your websites can become very complex. Here I'll show how SASS can help you better organize, maintain and reuse your CSS code.
"In order to have an organized way for empathy mapping, we rely on a psychological model and trying to model it in a simple way, so we will split the board to three section for each persona and a scenario and try to see what those personas would Do,…
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now