Philips migrates to SQL Server reporting to improve supply chain management

Philips Consumer Electronics is installing software based on Microsoft SQL Server Reporting Services to improve supply chain management.

Philips Consumer Electronics is installing software based on Microsoft SQL Server Reporting Services to improve supply chain management.

The company, which has a turnover of 6.8bn, began a global business intelligence programme five years ago. It is due to complete the migration onto reporting software provided by Panorama by the end of the year.

The software provides front-end reporting built on SQL Server 2000, which draws in information from the company's SAP system.

Aart Joppe, programme manager, business intelligence at Philips, said the migration was part of the firm's on-going business performance review strategy that relies on providing visibility in the supply chain. He said, "We wanted to provide easier access to information using a front-end with daily updates from SAP."

Using Panorama has allowed Philips Consumer Electronics to ensure all end users access a single version of the data.

Managers used to work with Excel spreadsheets to manipulate data, where Excel would take a copy of the production data. With Philips running operations around the globe this approach carried the risk of users analysing data that was out of date.

With Panorama, users no longer rely on Excel to perform data analysis, Joppe said.

Panorama uses SQL Server 2000 to provide reports that users can access. These reports are compiled through a back-end reporting system that draws information from 30 IT systems at Philips Consumer Electronics into a central SAP system running on an Oracle database.

An Informatica Powercenter extract, translate and load tool is used in conjunction with Tibco middleware to move the SAP data into a 2Tbyte Oracle datawarehouse. Kalido then provides the data modelling to users, who access reports via Panorama.

Read more on IT risk management

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchCIO

SearchSecurity

SearchNetworking

SearchDataCenter

SearchDataManagement

Close