#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2010
    Posts
    2
    Rep Power
    0

    Question Data exchange server design question


    I have 2 desktop softwares - one for buyers & another for sellers. I want to develop internet based data exchange server so that buyers & sellers can send/receive orders & sale invoices to avoid manual entry.

    A standard use case will be:
    - A buyer prepares purchase order(s) (contains a set of master/detail data) targeted for a specific seller
    - the buyer issues command within his desktop app to submit prepared POs to the server
    - the seller issues command in his desktop app (according to his convenience) to retrieve all POs targeted for him
    - the seller processes POs and prepare sale invoices using his desktop app
    - the seller then submits all invoices to the server targeted for different buyers
    - buyer finally issues command in his desktop app to retrieve (according to his convenience) all the invoices from different sellers targeted for him
    - buyer processes received invoices in his desktop app

    Please help me in designing how the desktop apps can connect, get authenticated, submit/retrieve POs/Invoices in a secured manner. Suggestions regarding technology, protocols will be highly helpful. There are no platform specific requriements.

    Thanks in advance.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    May 2004
    Posts
    3,417
    Rep Power
    887
    How many buyers and sellers are we talking about?
    Is it fixed number or is it going to be variable? How variable?
    What OS is your desktop software running on?

    There are many approaches to this problem as stated so far. Answers to the above questions will help to trim the list down a bit.
    I no longer wish to be associated with this site.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2010
    Posts
    2
    Rep Power
    0

    Post


    Originally Posted by jwdonahue
    How many buyers and sellers are we talking about?
    Is it fixed number or is it going to be variable? How variable?
    What OS is your desktop software running on?

    There are many approaches to this problem as stated so far. Answers to the above questions will help to trim the list down a bit.
    Thanks jwdonahue for the reply.

    There will be thousands of buyers & sellers. The number will go on increasing gradually. Both the desktop apps are on windows.
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    May 2004
    Posts
    3,417
    Rep Power
    887
    Take a look at MSMQ.

    http://msdn.microsoft.com/en-us/libr...8VS.85%29.aspx

    If you can squeeze your data into 3.8MB message payloads it's one way to go. If your payloads are larger than that, you can use MSMQ messaging to coordinate file transfers via other means such as sFTP. I would recommend using HTTP(S) transport however rather than punching MSMQ holes through your firewall (it's more secure that way).

    Here's a really good resource with pointers to other good resources on MSMQ:

    http://blogs.msdn.com/johnbreakwell/
    I no longer wish to be associated with this site.
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2010
    Posts
    1
    Rep Power
    0

    Data exchange server design question


    The expected proliferation of local-area networks has created a need for network database servers. It is reasonable to view local-area network data servers as extensions of backend database systems. This paper addresses several critical data-server design issues: distribution of functionality, high availability, security, and performance.
    Thanks & Regards
    Lisa Johnson
    Data Recovery Software
  10. #6
  11. No Profile Picture
    Contributing User
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    May 2004
    Posts
    3,417
    Rep Power
    887
    Originally Posted by Lisa Johnson
    This paper addresses several critical data-server design issues:...
    What paper would that be?
    I no longer wish to be associated with this site.

IMN logo majestic logo threadwatch logo seochat tools logo