Data exchange

Edenred is a company specialized in social benefits, with over 50 years of market experience and present in Portugal for over 35 years. They are world leaders in transactional solutions for companies, employees and merchants.

Creators of the Ticket Refeição, they have evolved and extended this social benefit concept in several ecosystems.

Challenge

Replace the legacy solution of data exchange between database servers through Service Broker, as well as propose a new architecture to be the new solution. Review all SQL Server database servers proposing how to improve their performance and availability.

Use case

The legacy environment between data exchange was analyzed, as well as the solution that currently existed of Service Broker. A new solution was proposed using an existing tool not yet used. After the release of the accesses to all Production and Quality servers, tuning adjustments were proposed to the customer.

Achievements

Use of SQL Server Integration Services – SSIS with the proposal of a new data exchange structure through queues. Integration between the new portal and the legacy system through SSIS for creation of customers, payment orders, creation of cards and replacement. Tuning in all Sql Server database servers.

Let’s talk