Why Choose Talend Solutions?

 

Next Steps

Tell us about your requirements:

+44 (0) 1494 616134

sales@talendsolutions.com

Osys

 

BNP Paribas Real Estate is a leading global real estate services provider. The Corporate Real Estate Extranet project aimed to provide extranet functionality to customers of BNP Paribas Real Estate, so that they could visualise their property portfolio and access property and financial reports through the Internet. Talend Solutions was engaged to design and deliver data integration jobs to synchronise data on the core system with the extranet system.

 

Far from a straightforward ETL problem, the data integration processes demanded careful and thorough design. The data structures in the source SQL Server database were vast and complex. Source data spanning over 200 tables was simplified into less than 20 staging views. The system architecture demanded that the integration mechanism be via web services. The web services required a complex multi-schema xml payload (with multiple levels of grouping and looping) containing changes to customer’s property portfolio data.

 

A set of framework jobs were developed in Talend to manage the interface and to provide a full audit history of invocations, records processed and records failed.  A suite of technical and business reporting jobs were developed off of the audit history to facilitate operational management of the Talend jobs and to inform key business representatives respectively. This initial release was developed and tested in just 20 man days.

 

Talend Solutions was awarded Best Talend Project of 2010 by the co-founder of Talend, Fabrice Bonan for its work with BNP Paribas Real Estate.