Skip to content

Custom ODI Data Integration, Solution Design, and Managed Services

Case Studies

About Consumer Goods Company

KPI's client is a Canadian manufacturer of branded clothing, including undecorated blank activewear such as T-Shirts, Sport Shirts and Fleeces, which are subsequently decorated by screen printing companies with designs and logos with annual revenues of $2.75 Billion and over 42K employees.


  • ODI KPI Partners
  • SQL Server KPI Partners
  • Microsoft_Office_Access KPI Partners
  • Oracle Exadata KPI Partners

Business Driver

Business Users needed the JD Edwards and LOGIPLAN data for Inventory Planning, Demand Planning, and Supply Planning to be transformed and populated to a SQL Server-based warehouse where the reports are being generated using Qlikview in near real-time. Approximately 5 GB of data needs to be transformed daily using the Custom ETL Design.


Selection Process

The client has evaluated many consulting companies but selected KPI Partners based on the KPI's expertise in solution designing with JD Edwards and Business Intelligence using ODI. In addition, KPI proposed a strong solution architects and a development team with onsite-offshore model resources to optimize cost and risk for the customer.


What KPI Delivered

KPI Proposed and Designed Custom ODI Solution Design to the client. Solution design is based on ODI logic which was used to build and populate Data Model for the Logility Supply Planning tool.


Build Model - comprises of multiple data sources like LOGIPLAN and JD Edwards from different business locations, transportation lanes, manufacturing resources like equipment & labor teams, and production conversion details like BOM & Routings with the required transformations.


Populate Model - the ERP transactional data is transformed to populate Logility with updated transaction data as relates to inventory, inventory transfers, production work orders, purchase work orders, and customer orders. Provided ODI-based logic and code for cleansing the source data, capturing the bad data & Error records, and sent the error data via an email. Provided Post Production Support where handled 24X7 Production Load monitoring and Issue resolution from offshore. Extensively supported on performance tuning of the ETL jobs in Production as this was a mission-critical project. Provided Infrastructure design for ODI environment and Disaster Recovery planning and implementation. Provided documentation on all aspects of the project life cycle with appropriate data flow diagrams. 


Business Benefits

Served as the automated Data Load for Supply Planning Tool. Solution of Smart ODI logic minimized source data maintenance like BOM flattening and Salad Bar network mapping. And the ODI logic compensates for bad or incomplete source data to enable the Planning Model to load and solve as best it can.  Helped to facilitate client ERP consolidation from JD Edward World Soft to JD Edwards EnterpriseOne (E1). This Model is Dynamic, accommodating many different processes for Retail, Wholesale, Socks, Underwear, Tops (T-Shirts & Fleece), and when the business expands and the processes change, the ODI logic enables the client to often adjust at only one place.


Comments not added yet!

Your future starts today. Ready?