Summary
Learn how Idaho Power, a locally operated electrical power utility worked with ExistBI to define, design, implement and test ETL processes to move data from its SAP implementations using Informatica PowerCenter.
About Idaho Power
Idaho Power is a locally operated and regulated electrical power utility that is headquartered in Boise, Idaho. The company owns and operates 17 hydroelectric dams and three natural gas power plants and owns shares of two coal-fired power plants. The company has 2,000 employees and has been serving residential, business and agricultural customers since 1916.
Challenge
Idaho Power was looking for an expert who could support the company’s enterprise data warehouse (EDW) development efforts which included assisting in the development of data models and building proven and logical ETL mappings for the SAP environment. ExistBI was chosen to work with Idaho Power to deliver these critical services.
Solution
ExistBI worked hand-in-hand with Idaho Power to deliver the following services:
- Define and document ETL process architecture
- Create and update source to target mappings
- Create and update technical ETL specifications documents
- Develop and unit test ETL code to technical specifications document
- Document testing results
- Create a configuration management plan
- Establish Informatica connections to source and target databases
- Research and resolve defects, troubleshooting from the data source (SAP ECC) through the SAP Business Warehouse to the enterprise data warehouse
- Develop/support ETL reconciliations and control processes
- Participate in implementation and issue resolution of ETL codes
- Analyze data and providing business logic for data integration
- Analyze data quality
- Design data cleansing and error handling routines
- Ensure adherence to approved standards
- Interface and communicate with upstream data warehouse partners (business warehouse), project managers and IT Ops
Expertise Offered
To support Idaho Power in its business requirements, ExistBI leveraged its expertise in the following:
Informatica provides tools for extracting, transforming, and loading (ETL) data from various sources into a centralized data warehouse or data lake. This process ensures that data from different systems can be combined, cleansed, and made ready for analysis.
SAP ECC (Enterprise Core Component) is a comprehensive enterprise resource planning (ERP) system that integrates different business processes such as finance, human resources, procurement, manufacturing, sales, distribution, and more. This integration allows for seamless data flow and real-time information across various departments within an organization.
SAP Business Warehouse (SAP BW) integrates data from different transactional systems, databases, and external sources into a central data repository known as the data warehouse. This data integration process ensures that data from various systems can be combined and analyzed in a unified and consistent manner.
ETL development including a strong understanding of data structures, data modeling, and databases. ExistBI is also proficient in working with various data formats and sources, understanding data quality issues, and ensuring data accuracy during the extraction and transformation process. In addition to Informatica, ExistBI is well versed in working with ETL tools like Microsoft SSIS, Talend, IBM InfoSphere DataStage and SAP Data Services.
Results
Idaho Power was extremely pleased with the services provided by ExistBI.
“Thank you for providing us sharp SAP BW / ECC and Informatica Consulting resources for our enterprise data warehouse project here in Idaho. They have succeeded over the last 18 months where numerous other resources have failed!”
Do you need the expertise from a proven and experienced ETL consultant who can help you reliably move your data? Let ExistBI be your ETL partner.