“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 

Background 

This diversified financial services holding company has subsidiaries worldwide engaged in investment and financial planning and investment banking. They also  manage client assets exceeding a total of 400 billion dollars. 

Use Case

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 these clients have disparate data systems that use various formats. Frequently, data does not conform to existing layouts, causing delays in validating and processing. With new clients joining the company on a daily basis, they urgently needed a solution for delays in onboarding and transferring data.

Profile  

This Global Financial Services Company handles more than 2.5 million accounts in over 2,500 locations around the United States.   

Industry  

Financial Services 

Product  

Astera Centerprise  

Use Case 

This company used Centerprise to conduct mass account transfers and integrate them into a single SQL database 

Result  

The Company was able to save significant time and resources. 

Learn More about Astera Centerprise.

Enter Astera Centerprise

After conducting their research, the IT team chose Astera Centerprise. 

Centerprise is a high-performance, scalable data management platform that allows businesses to meet today’s advanced business needs. Powered by an enterprise-grade parallel-processing engine, Centerprise offers data extraction, transformation, integration, and data warehousing all through a single platform.  

The team was drawn to Centerprise because of its user-friendly, unified environment. Centerprise provided them 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. Using Centerprise, the Company was able to save significant time and resources by streamlining their process.  

Ready to Learn More?