Can MOSS 2007 connect to external application (HEAT)?

We use the HEAT Service & Support (FrontRange Solutions) application for our Help Desk ticketing system.

There is a need to integrate this with our SharePoint Intranet.

Use case: When a ticket is closed, and an e-mail is sent to the Customer, we want the customer to follow a link to a a SharePoint survey where the Customer's name will dynamically populate his Name, Email, Ticket#, etc.

Can this be done? What are the considerations, and approaches?
sandshakimiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

zephyr_hex (Megan)DeveloperCommented:
not out of the box.  you'd have to code a custom solution if you wanted this level of integration.

there will be work to do with your application ... a mechanism for it to trigger the process to start (upon ticket close, trigger)

on the survey side of things, you may want to consider Infopath (which can store data in a SQL db, and then expose that data to sharepoint via DVWP, or, store directly in a sharepoint list).

either infopath or a sharepoint survey should be able to populate a field with a value passed in via the url.

there are many other things you'll need to consider, such as security, how to expose your survey to the customer (who is not inside your network), how to build your url, etc.


0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vikas413Commented:
am suggesting simpler way to use MOSS web services. do following

1. create extension to your app which do following
    on completion of ticket, create new item in task list of SharePoint site using MOSS web service called lists.asmx (http://dotnetdreamer.com/2009/06/04/moss-web-services-accessing-sharepoint-list-data/),  (here you can fill all required details which can be used while survey.)

2. on SharePoint side do following.
    when new task is crated in list, start a workflow(out of box/code) which in turn send URL of ask or survey item to customer, or create specific list where you can have questions like survey and send that link to that customer.

of course as Zephyer had told .. you need to consider security and authentication configuration for MOSS.

hope this will help.

Vikas Patel.
0
sandshakimiAuthor Commented:
These Customers are also Users of our SharePoint Intranet. (so they already have an account within SharePoint)
So I do forsee that when they follow the link to the SP Survey from the e-mail, they will first have to login.
But how do I access HEAT's database from SharePoint? (perhaps check their API?) Isn't there a Web Part to do this?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.