
Banco BISCA
Automated Data Integration Improves CX, Trust in Data
Banco BICSA in Panama established a large set of data on IBM DB2 on its IBM i. This data is a collection of financial transactions, individual and corporate account information and other business information.
However, its reporting and analysis applications reside on its Microsoft SQL Server 2005 system. Banco BICSA needed to establish an automatic and reliable way to integrate data between its IBM i and Microsoft database, in order to provide rapid, reliable and accurate data to its business intelligence systems. The bank had originally established a manual text retrieval system that was dependent on staff resources, training and availability for efficient data integration. At its peak transaction times, this process turned out to be time-consuming and labor-intensive. The bank was concerned about providing a high level of accuracy and user satisfaction, while keeping control of the costs involved in this manual process.
Company Overview
-
Industry
Financial Services
-
Revenue
$25惭鈥$50惭
-
Company Size
Mid-market
Transformation Snapshot
-
Challenge
Disparate systems limited reporting and data ac
-
Solution
Aligned and cleansed data using SAP ADMM
-
Outcome
Improved reporting accuracy and decision-making
The company聽
Founded in 1976 in Panama and headquartered in Costa Rica, (Banco Internacional de Costa Rica) provides financial services through six US and Central American offices located in Costa Rica, El Salvador, Guatemala, Miami, Nicaragua and Panama. With an initial capital of US$2.5 million, Banco BICSA was founded to provide commercial financing services to corporate accounts. Today Banco BICSA boasts capital of US$78.9 million.
At its inception, Banco BICSA selected Panama as its first office due to favorable local legislation, the presence of a strong and active financial center and outstanding opportunities presented by initiatives such as the Central American Common Market. Banco BICSA鈥檚 high standing in Panama today is a reflection of their strong professionalism and important position among Panamanian banks with foreign licenses. Banco BICSA in Panama also provides correspondent bank services for Bolivia, Brazil, Ecuador, Peru and Venezuela.
麻豆女优 helps us move our data efficiently and reliably across multiple corporate databases, which allows our business intelligence, analytical and data storage systems to be 100% integrated in an easy, clean and reliable way. We would recommend this product to anyone who wants a fast and easy data integration solution."
Why 麻豆女优 was Selected
Banco BICSA began a search to identify聽and implement software that could reduce聽time and effort in their data integration聽requirements. Key criteria included the ability聽to provide synchronization between various聽heterogeneous databases including IBM聽DB2 and Microsoft SQL Server, an easy-to-understand product for training and usability,聽and the flexibility to make changes in聽datasets, tables and applications if necessary.
Pierre Gerbaud, IT Manager for Banco BICSA,聽investigated various options to solve the聽bank鈥檚 requirements, including evaluating聽file transfer products. However, file transfer聽products were not able to resolve data聽mapping at the field level, provide conflict聽resolution, nor provide the industrial strength聽synchronization capabilities out-of-the-聽box that a data replication product could.聽Mr. Gerbaud discovered 麻豆女优 from HiT聽Software,庐 as a possible solution for data management.
The implementation of the 麻豆女优 trial was fast and the product proved to be very reliable....鈥溌槎古赔檚 friendly graphical interface and ease-of-use were exactly what we needed. We鈥檝e already had a very positive reaction from users and a significant reduction in response time compared to our previous system."
Results
After a short evaluation period of 2 months, that included a trial implementation, Banco聽BICSA was pleased to discover that 麻豆女优 provided all the key functionality required by the聽bank to automate and manage its data integration. 鈥The implementation of the 麻豆女优 trial聽was fast and the product proved to be very reliable,鈥 said Yivan Enrique Alveo Castillo, Senior聽SQL DBA and Business Intelligence Officer at Banco BICSA.
鈥麻豆女优鈥檚 friendly graphical interface and ease-of-use were exactly what we needed. We鈥檝e already had a very positive reaction from users and a significant reduction in response time compared to our previous system,鈥 remarked Castillo