Best Practice

Automated mapping of external assets in agree 21

Fincon Reply has developed a robust and automated process for mapping external assets within agree21. This enables banks to gain a consistent and up-to-date view of client assets, forming a reliable basis for advisory services, reporting, and customer segmentation. Manual maintenance and parallel data solutions are rendered completely unnecessary.

The scenario

Disparate data sources hinder transparent asset overviews

When collaborating with external service providers, assets are often managed outside the bank’s core systems. In practice, this results in limited transparency for banks: relevant holdings are not consistently visible within the core banking system, information must be added manually, and evaluations rely on supplementary lists or bespoke solutions.

The aim, therefore, is to map external assets within agree21 on a regular, traceable, and stable basis — creating a unified data foundation for advisory services, reporting, and customer engagement, without disrupting day-to-day operations.

The challenge

Copying data is easy – integrating it into agree21 in a way that ensures all downstream processes continue to function correctly is the real challenge

Ensuring data quality and stability despite complex system landscapes

The difficulty lies less in the mere transfer of data and more in its sound professional and technical integration into the agree21 data environment. The task is to make intelligent use of existing fields and data structures, to consider interactions with other functionalities, and to establish a process that is reliably stable in the long term. At the same time, data quality, traceability, and compliance with regulatory requirements must be ensured — with minimal manual effort in daily operations.

The solution

Automated data integration with clear validation rules

The proven approach involves building a standardised, automated import process for external assets. This process begins with a clearly defined, regular data delivery by the service provider in a pre-agreed format. These data are then integrated into the bank’s data infrastructure, subject to professional validation, and subsequently created or updated automatically in agree21.

On this basis, external assets are made directly available within the agree21 workplace. In addition, key figures can be derived for analysis and reusable selections — for instance, in reporting or personalised customer engagement. Defined validation rules — for example regarding marketing consent, address quality, and exclusions due to incomplete data sets — ensure audit-compliant and consistent outcomes.

The execution

From target architecture to
stable batch processing

The general project approach of Fincon Reply is divided into five essential implementation steps:

The result

A stable data foundation for advisory services, reporting, and segmentation

External assets are now fully and accurately represented in agree21 — without the need for parallel Excel spreadsheets or manual updates. Relationship managers benefit from a clear and comprehensive overview of client holdings, evaluations can be generated efficiently, and selections reused. Operational effort is reduced to a minimum: monthly data delivery takes only a few minutes, while creation and updates are handled automatically.

The result is a stable, future-ready solution that enhances transparency, streamlines processes, and sustainably improves the data foundation for advisory services and management.

Fincon Reply is a business and IT consultancy specializing in the financial services industry. Fincon Reply proactively advises banks, the Sparkassen Financial Group, the German Cooperative Financial Group and insurance companies as well as their suppliers on their digital transformation. The company provides on-site support with specialised teams of consultants and developers and delivers turnkey solutions.