Philips Healthcare, a global manufacturer of medical equipment and healthcare products, needed a solution to transport and store massive amounts of data into a new database. Their current systems could not perform fast enough to handle the high velocity and high volume of data and began to create a backlog.
Their existing data collection process was not able to keep up with the growing amount of information and file sizes; however, they needed to store data on each step in the assembly line for each individual product for diagnostic and quality assurance purposes. Their current systems could not perform fast enough to handle the high velocity and high volume of data and began to create a backlog. And to top it all off, the government has regulations and strict guidelines around the ability to quickly and accurately capture the information about the product being manufactured.
Through this process, corrupted data sets were flagged and made visible, enabling a retransmission and upholding data quality standards. In the next phase, certain features of SSIS and SQL Server were leveraged to improve the performance and quality of the data warehouse import processes. Both of these technologies support the XSL/XML protocol to improve data quality as well as the high performance dataflow functionality, resulting in performance and order of magnitude greater than the previous implementation.
The solution also helped to optimize the manufacturing process by dramatically decreasing production timing issues and improving data quality. Chateaux provided remote mentoring support for the solution after the initial engagement was complete to accommodate the needs of the customer.
The solution is pretty amazing; it just runs, and we don’t need to maintain it, which was one of our main goals. Chateaux provided a solid design followed by a successful implementation that met all of our needs and has helped make BI more affordable for us.