- This topic has 5 replies, 1 voice, and was last updated 9 years ago by
.
-
Posts
-
-
-
Actually, what I want to do is to build a system that will take clients’ survey specifications (flat file), check and save to database. There will be another program which will build survey forms (Adobe) based on these specifications. The survey forms are then sent to respondents. Respondents fill out the forms and send back to the system where survey results are parsed and save to database. Finally survey results are converted to flat file or xml to send back to clients.
Biztalk and Adobe are chosen for this project. Biztalk acts like a parser, taking in specifiations, sending survey forms to respondents, parsing the results received from respondents and sending confirmations/reminders to respondents.
So do you think Biztalk is the right tool for this kind of project?
-
I haven’t used Notification Services before. Can I schedule it to send emails at certain times? For instance, if the system hasn’t received results from respondents in 10, 20 … day intervals, it will send emails to remind them.
Thanks a lot.
-
You coiuld use a Dynamic send port on your orchestration to do this. There are several examples out there of using dynamic ports with the SMTP adapter. Here’s one:
http://www.winterdom.com/weblog/2005/08/15/SMTPAdapterInBTS2006AndHTMLFormattedMessages.aspxThat said, do realize that BizTalk is not the tool if all you want to do is extract a big bunch of email addresses from a DB and start doing a mass mailing. If this is what you want, since you already have the data in the DB, I’d look at maybe leveraging SQL Server Notification Service.
-
It should work well, I think, and Biztalks facilities for XML<->FF mapping should be very useful. I was only concerned you might be, for example, taking 100s or 1000s of addresses and start generating huge number of messages in a tight loop. Sounds like that might not be the case, though.
That said, if you do need to send a huge number of emails, sounds like you could certainly extend that little part with Notification Services and still take advantage of BizTalk for all the rest.
-
Yes, you should be able to get that kind of behavior if you want with a little work. I’m not a Notification Services Expert by any means, but there is some good information out there that might be useful:
http://www.codeproject.com/dotnet/SQLNS.asp
http://www.microsoft.com/technet/prodtechnol/sql/2000/evaluate/sqlnsto.mspx
-
-
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.