Global Financial Services Company Overcomes Challenge of Complex Client Data Integration With Centerprise

“Centerprise has saved our company significant programming time and resources. With our former tool we would have had to build complicated SSIS packages to transform huge amounts of disparate incoming data. There aren’t a lot of bugs in Centerprise and it works as advertised. Centerprise serves all of our complex data integration needs.”
Application Developer

Overview

This diversified financial services holding company has subsidiaries worldwide engaged in investment and financial planning, as well as investment banking and asset management. Total client assets exceed $400 billion.

Challenges

With more than 6,000 financial advisors serving more than 2.5 million accounts in more than 2,500 locations throughout the United States, Canada, and overseas, the IT team for this company takes care of daily mass account transfers from incoming clients, most of whom have disparate data systems using fixed length, Excel, and SQL database formats that must be transformed into the main SQL database format. Frequently, data does not conform to existing layouts, adding to the complexity and causing delays in validating and processing. Because new clients join the company constantly, data integration is an ongoing challenge..

Business Needs

This company needed a robust data integration solution that could handle the complexities of validating and processing mass account transfers in a myriad of formats quickly and reliably. With new clients joining the company on a daily basis, delays in onboarding and transferring data had to be overcome.

Astera Solution and Results

The IT team, which consists of both developers and business users, chose Astera’s Centerprise Data Integrator because of its user-friendly, unified environment that provides a straightforward means to create the many complex data mappings needed to transform client account data into the company standard data format to be integrated into the server. Centerprise provides native connectivity to all the common file formats such as fixed length, delimited, Excel, COBOL, XML, and PDF, and supports all encodings. This enabled the team to address all of the disparate data formats and efficiently map and integrate incoming data into the company database.

Why Astera

Centerprise Data Integrator’s sophisticated complex data-mapping capabilities and native connectivity combined with its unified environment and user-friendly interface was precisely what this company’s IT team needed for the task at hand.