Euroticket Edenred.
Data Exchange
New data exchange architecture via SSIS
- Industry
- Employee Benefits & Fintech
- Service
- Product & Delivery
- Stack
- SQL Server · SSIS
Edenred specializes in social benefits, with over 50 years of market experience and a presence in Portugal for more than 35 years. It is a world leader in transactional solutions for companies, employees and merchants. Creator of the Ticket Refeição, the company has evolved and extended this social benefit concept across several ecosystems.
Challenge
Replace the legacy solution for data exchange between servers via Service Broker, proposing a new architecture. Review all SQL Servers, proposing performance and availability improvements.
Solution
Analysis of the legacy data exchange environment via Service Broker and proposal of a new solution based on an existing tool not yet in use. After access was granted to all Production and Quality Assurance servers, tuning adjustments were proposed to the client.
Result
Use of SQL Server Integration Services (SSIS) with a proposal for a new data exchange structure via queues. Integration between the new portal and the legacy system via SSIS for customer creation, payment orders, card creation and replacement. Tuning across all SQL Servers in the environment.
Technologies used.
Related stories.
Have a similar challenge?
Tell us about your project. We respond within one business day.
Discuss your Product & Delivery challenge