Sudheer Palyam

We need to exchange our customer data with an external partner on a daily basis. This data is highly confidential. This size of the data will be around 1GB. The data format is unicode.

What will be the best way to exchange the information



Re: Architecture General Data Exchange

VikasGoyal

can you provide some more info like :

1. do u have connectivity between two netwroks.

2. where is data stored in your network e.g. db or file system

http://DotNetWithMe.blogspot.com
vikas goyal






Re: Architecture General Data Exchange

Sudheer Palyam

Vikas,

We don't have any connectivity between two networks as of now. The cusotmer data is stored in SQL Server (some applications in 2000 and some applications in 2005). The partner uses SAP(SQL server as its database)





Re: Architecture General Data Exchange

Frank Carr

1 GB a day Are you sure you need that much data Is some of it redundant Trimming down the amount might open up some other possibilities.

My initial thought would be a program, probably a Windows Service working off a schedule, that would extract the data from SQL Server into an XML file into a very limited access folder, encrypt it, and then call a web service on the other end to upload it. Then, on the receiving end, have a Windows Service application move the encrypted file to a safe location, decrypt it, and load it into the database in a secure table on that side.






Re: Architecture General Data Exchange

erikj

Don't forget to compress it first! Following the web services theme, the binary (and encrypted) data could be sent using MTOM, which means the data gets transmitted as MIME attachments rather than in the SOAP XML document itself. It's more efficient to process because the XML parser doesn't see the data (I think).