SQL Server in Manufacturing: Product Data ManagementCentralize data from disparate systems into Microsoft SQL Server 2005 data platform so that product design and engineering teams can have easy and secure access to product design, manufacturing, supplier, and performance information across all processes in the product life cycle. Teams across the organization can have integrated views of data that is typically fragmented across business processes. Challenge | Global product design efforts are difficult to manage and synchronize. |
| SolutionUse a high-performance platform with enterprise-class reliability, replication, and synchronization. BenefitEmpower collaboration by making sure that up-to-date product information is always available. |
R.A. Jones: "SMARTEAM also helps when engineers are working on the same file concurrently. The SMARTEAM controls ensure that a release does not happen if files referenced in the release are still being modified by others. The new design cannot be released until that conflict is resolved."
-- R.A. Jones | See the case study |
Challenge | Data is stored in multiple applications that aren’t integrated. |
| SolutionIntegrate data from disparate systems and aggregate it on a single platform. BenefitProvide an enterprise-wide view of product data so that managers can matter better informed decisions more quickly. | "The chemists and engineers frequently need to analyze the correlations between quality and production measurements and the physical and chemical characteristics of product components. Such analysis was simply too difficult to do in the past because it was hard to link and compare information contained in different information repositories. Today, the analysts can query against a single cube that offers all the data they need to do their analysis—kind of a 'supercube' that provides one location for all relevant data."
-- Italcementi | See the case study |
Challenge | People involved in the product lifecycle have difficulty accessing the data they need to do their work. |
| SolutionStore product data in a single location so that it's easier to find and use. BenefitEnable a holistic approach to product data management and eliminate errors that arise during manual data transfer. | "Our managers can use SQL Server Notification Services to set their own rules on what event will trigger a report to be sent to them. For example, you could use Notification Services to automatically send an SMS message to your mobile phone if a customer ever cancels an order above a defined amount. Or a message could be triggered by a specific item's inventory level or shipment date. Data that used to be unavailable for weeks can now be sent instantly to our people wherever they may be in the world."
-- Sandvik Tooling | See the case study |
| |
Read real-world customer solutions of SQL Server in 
