Espirito Santo Bank Selects Centerprise to Integrate Data Into IBM Mainframe for Warehousing
“I like it. It was quick and easy to use.” Luis Arango, IT Director
Financial services, banking, wealth management
Espírito Santo Bank is a chartered bank headquartered in Miami, Florida that provides private and commercial wealth management, banking, and financial services to domestic and international individuals, institutions, and corporate clients.
Migrate data from brokers into IBM mainframe for data warehousing
Luis Aragono, IT manager, is responsible for migrating data from brokers into a mainframe for data warehousing. He works with the broker dealer department and was charged with extracting the broker data that was stored in an MS Access database and loading it into an IBM mainframe data warehouse. The extraction was problematic since he had to place certain values from the Access records into a template prepared specifically for the mainframe.
The data integration software had to be easy to use and able to put the data into a predefined template that could be read by the IBM mainframe. The client had to be able to design the dataflow for someone else to execute. And above all, the software had to be able to be changed in an instant as new business requirements change frequently. In short, flexibility, scalability, and ease of use must be combined in one solution.
Centerprise Data Integrator
Extract broker data stored in an Access database and load it into an IBM mainframe data warehouse
Extraction was problematic since certain values from Access records had to be placed into a predefined mainframe template
Solution had to be able to be changed in an instant as new business requirements change frequently
Flexibility, scalability, ease of use must be combined in one solution
Ease of use required in order to hand off dataflows for business users to execute without requiring extensive training
Astera Solution and Results
Since this was a brand-new project, Aragono had the option of writing a COBOL program or looking for a software solution. He chose the latter, since he knew that any program he wrote would have to go through a lengthy development and QA process to make even the smallest change. He evaluated various software solutions and only Centerprise Data Integrator provided a seamless solution that met all his requirements.
Astera’s Centerprise Data Integrator provided all the flexibility, scalability, and functionality required for the bank’s complex application, while at the same time offering the ease of use Aragono needed in order to hand off dataflows for business users to execute without requiring extensive training.
Find out more about the industries we’ve helped and how we did it.
This site uses functional cookies and external scripts to improve your experience.
Before You Go, Grab Your Invite…
To Our Upcoming Webinar on Automating Data Pipelines for the DW.
Join the live session to find out how you to build fast, accurate, timely, and self-regulating data pipelines that keep your data warehouse stocked with high-quality BI for advanced analytics.