Synchronization of database on Cloud for marketing advisor firm

Synchronization of database on Cloud for marketing advisor firm 2017-10-30T10:58:58+00:00

Project Description

Project Details

Country: USA
Domain: Information Technology
Solution: Windows Azure, SQL Azure, SQL Server 2008 R2, Sync Framework, C#, .Net Framework 4.0

Client Profile

Client is a USA based email marketing advisor and web services firm, which works across industries.

Business Scenario

The client is an email marketing consultant and web-services firm from USA who wanted to streamline the storage of its optical framework database and its supplying to various users. Wanted to develop solution wherein the key necessities were:

  • Developing a mechanism which could strengthen the database present in multiple users’ iPads with centralized database server
  • Systematizing the database storage by tuning different databases with main database server at regular intervals
  • Allowing distant users to directly access the centralized database from various locations
  • To incorporate security in the system which could only permit users to see and download the data without revealing anything about database and its location in the server

Our Solution

A hands-on experience on Windows Azure and SQL Azure technologies guide us to formed a prototype of the solution according to the client’s needs. The prototype was able to store and combine data with centralized server, which further could be accessed by last users for tracking and downloading necessary information. The solution, so developed, proposed to perform synchronized tasks in a uniform manner at frequent intervals to present up-to-date data to users in secured way.

In developing the prototype we adopted these strategies:

A console application was developed using Sync Framework to connect premise data to SQL Azure and Windows Azure storage

A Sync Scope was created between local SQL database & SQL Azure database to synchronize the data stored at different locations (user’s ipad’s) with centralized server

Used Sync Provider at user and server ends which transmitted changes occurred at either ends using Sync Orchestrator

The console application also incorporated Conflict Resolution Policy to detect conflicts occurred due to changes at either end, which updated the changes at other end. This balancing feature of the application helped in keeping the information up-to-date at both the ends

A middle- tier was developed running on Windows Azure Hosted Service, which operated as an intermediary to connect user’s application with SQL Azure database. This facility helped users to track the essential information from centralized server

Generated web Services under Windows Azure Hosted Services which enabled users to view and download the required data without disclosing the location (where the data was stored)

Business Benefits

The prototype formed on Windows Azure undertook to provide following benefits to the client

  • Full automation of database synchronization process with no human mistakes
  • Ability of tracking user’s database from the up-to-date centralized server
  • Facilitating to store database on common storage platform available to all users

Safe channel mechanism to sync, modernize and share latest information with various users