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.”
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.
Mass account transfers integrated into a single SQL database
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..
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.
Centerprise Data Integrator
- More than 6,000 financial advisors serving more than 2.6 million accounts worldwide
- Daily mass account transfers from incoming clients in disparate data formats
- Data integration is an ongoing challenge and created delays in conboarding new clients and transferring data
- The IT team consists of both developers and business users so the software had to be user-friendly
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.
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.