Customer: BANELCO
"We replaced our rigid architecture for a flexible solution using Pentaho Data Integration enabling the processing of more sources, more volume and more easily. We are very pleased with Datalytics and their expert implementation of Pentaho"
Deployment Overview
Key Challenges- Needed to include new information sources that were not in transactional systems
- Needed to improve data quality caused by lack of referential integrity, invalid data loads and incomplete dimensional structures
- Inadequate control over performance such as manual verification through SQL programming at great cost and error prone
- Received updates through SQL scripts resulting in slow development, complex maintenance and rigid architecture
- Technology environment includes Sybase IQ and Windows 2008 R2
- Pentaho Data Integration was a flexible solution allowing BANELCO to extract, transform and load data from multiple data sources faster, easier and more cost-effective
- Worked with <a href="http://www.pentaho.com/partners/partner-info/datalytics/">Datalytics</a>, Pentaho Gold Reseller Partner and professional services firm covering Latin America
- Increased number of data sources from one to five incorporating information from: agreements and commissions with third parties, debit card deliveries, cash availability, operation of ATMs and user responses to messages
- Established unattended execution of automatic processes reporting to those responsible for each area
- Integrated PDI with Report Designer to generate operational reports
- Drastically increased the amount of data processed daily (+7 million records daily and fact tables with +2 billion records) while decreasing the time it takes to process the records to less than an hour
- Migrated all processes through Pentaho Data Integration eliminating all SQL scripting and increasing performance
Why Pentaho
- Low total cost of ownership (TCO)
- Scalable solution based in J2EE architecture
- Îœature product used and tested in multiple and recognized global clients