CASOS DE ÉXITO

Europ Assistance

Sector: Insurance / Travel Assistance and Emergency Services.

Technology: SQL Server, SQL Server Reporting Services (SSRS), PowerShell, PySpark, and Databricks.

Europ Assistance disconnects more than 500 production reports and regains full control of its reporting ecosystem.

Europ Assistance operated more than 500 reports directly connected to its production database, creating performance, security, and governance risks. The lack of a centralized inventory made it difficult to understand report usage and rationalize the reporting landscape. The organization needed to regain control of its reporting ecosystem without affecting business access to information.

Customer challenges

More than 500 reports were retrieving data directly from production systems, impacting performance and increasing the exposure of sensitive information.

Limited visibility into actual report usage made it difficult to identify which reports were still required and which could be retired.

In addition, the uncontrolled creation of new reports continuously increased the complexity of the reporting environment.

Partner solution

Aleson ITC delivered a reporting rationalization and automation project, including:

01
Inventory and usage analysis of more than 500 SSRS reports.
02
Classification of active, obsolete, and underused reports.
03
Databricks automation with PySpark to generate the data required by each report on a daily basis.
04
Complete decoupling of reports from the production database through CSV-based data delivery.
05
Implementation of controls to prevent unauthorized report creation.

Customer benefits

Europ Assistance regained full control of its reporting ecosystem, eliminating direct access from reports to production systems and reducing performance and security risks.

Databricks automation ensures up-to-date information without impacting transactional systems, while the new controls support ongoing governance and compliance.

Key results

Complete production decoupling

More than 500 reports were successfully reconfigured to eliminate direct connections to the production database, protecting transactional system performance.

Governance and control restored

A complete inventory of the reporting ecosystem was created, identifying active, obsolete, and underused reports. Additional controls were implemented to prevent unauthorized report creation.

Automation and guaranteed availability

An automated Databricks process generates the data required by each active report every day, without relying on production systems.

More than 15 years solving challenges like yours

Leading organizations trust us with their critical systems. Let’s start by understanding yours.

Request an assessment