System integration based on Microsoft .Net and SQL Server

The client was looking to restructure their entire marketing database and also revamp their existing APIs. Their goals were to speed up data transfer through APIs and generate reports from the custom backend interface.

  • Understanding the existing system of the client
  • Getting timely response from client end to the queries from the team at WS

What we did

  • Analysed APIs from different third party data sources, including Salesforce, Google AdWords, MSN/Bing, Omniture - SiteCatalyst, and Simon & RDE.
  • Developed, scheduled processes for ETL of data from these third party systems to client’s marketing database.
  • Developed custom UI for gathering custom reports from the client’s marketing database.

Solution Highlights

The solution provided by WS included Microsoft .NET and Microsoft SQL Server based scheduled processes for Extraction, Transformation & Loading of data from external systems (Salesforce, Google AdWords, MSN/Bing, Omniture, Simon & RDE) and pulling into databases for the UI for Micros and showing report based on the extracted data, after an intermediate validation process through the UI.

What we achieved

  • Successful integration with third party data sources using respective APIs.
  • Achieved 100% data accuracy from the third party data sources, which include Salesforce, Google AdWords, MSN/Bing, Omniture - SiteCatalyst, and Simon & RDE.

System integration based on Microsoft .Net and SQL Server

Industry :
Automotive
Expertise :
System Integration
Country :
United States

 

 

Want to know more

Go To Top