Integrate new feed into a Datawarehouse for a popular US-based Nutrition company

Business Problem: The client needed to enhance their Datawarehouse to include additional feeds from a new geography they were expanding into

Our Solution Integrated new bi-directional data feeds for Customer, Sales & Inventory to the Enterprise Data Warehouse for a new geography.

The Company wanted to integrate data from China operations into the Enterprise Data warehouse and also provide newly created master data from SAP, SFDC, etc. as a data feed to a portal used in China. Metadata driven DataStage jobs that support current global data integrations operations were extended to support the new China data structures, while new jobs were created to extract Customer data from China’s SalesForce.com and transform them to the hierarchies required for SAP and the EDW.

Technology: IBM Infosphere DataStage 8.7,  Salesforce.com Connector, Oracle 11i, Unix Scripts