Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / ASP.NET / Web Services / February 2005

Tip: Looking for answers? Try searching our database.

Sharing Large Live Data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Frank Bishop - 10 Feb 2005 21:03 GMT
We have a problem in that we have an outside company handle our online
conference sessions so they handle the registrations. The data is of
registrations is sent back to us as an excel sheet (after the session
ends). Mapping this data back to our production database to report
demographics is labor intensive sometimes.

Would it be possible or recommended to push out a live xml web service
(to be consumed by the outside company) of all our active customers
(thru a secure connection of some sort...SSL?)They could bounce this off
the person registering online and add other logic if they are a non
customer. I would still need a registrant report after the fact.

Suggestions appreciated.
Thanks
FB
Ben Strackany - 11 Feb 2005 20:51 GMT
You could do that. If your customer list is huge and/or they're downloading
the data a lot, a different data sharing mechanism might be better (e.g.
FTPing CSV files that they pick up daily, etc.). You could also just send
them updates (i.e. list of people subscribed/unsubscribed since XX date)
instead of your entire list.

If the data size is still too big, it might be better to instead publish a
web service method like CheckUserRegistration() where they pass a user's
information & you return whether they're in your system or not. It has the
advantage of being a real-time check (instead of a daily download that might
get out of date as the day progresses), and it might also be faster than
huge, repeated downloads. You could also expose a web service method
allowing them to POST registration information, instead of sending you
Excel.

When they send you Excel, you could use the Excel COM object or ADO.NET to
load the data programmatically into your system. I am assuming that the
labor intensive aspect often comes w/ bad data, not necessarily importing
good data.

In terms of securing web services, SSL is good (maybe w/ custom certificates
that you generate), but has a performance impact. You could also look at WSE
(http://msdn.microsoft.com/webservices/building/wse/default.aspx) in terms
of web service security.

HTH,

Signature

Ben Strackany
www.developmentnow.com

> We have a problem in that we have an outside company handle our online
> conference sessions so they handle the registrations. The data is of
[quoted text clipped - 14 lines]
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.