Experience Success http://www.microsoft.com/success. Customers’ and Partners’ stories from multiple perspectives Highlights business challenges & solutions Stories encompass technical and business-focused videos, case studies, and articles.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Customers’ and Partners’ stories from multiple perspectives
Highlights business challenges & solutions
Stories encompass technical and business-focused videos, case studies, and articles.
Rich, interactive environment offers both “guided” and “self-directed” experiences.
Same OBA… in a different light.
Catalyst Capabilities International is a consulting firm that specializes in the design, development, and deployment of emergency planning and response systems.
International Consultants Create Office Business Application to Help Assist with Disaster Response Management
PR Contact: Andrew Zdunich Director, Public Safety and Security. 1 (416) 697-6738
Catalyst is a consulting firm that specializes in the design, development, and deployment of emergency planning and response systems. A key goal of Catalyst has been to find ways of using technology to help speed communications during disasters. To assist in this effort, Catalyst teamed up with Infusion Development to design the Joint Emergency Planning and Response System (JEPRS).
the partners wanted to build a technology solution that would take advantage of the software tools that people are most familiar with—particularly Microsoft Office.
Office SharePoint Server 2007 provides a way to create easy-to-use, full-featured Web sites for storing documents and contact lists. It also lets teams establish various workflow elements, including real-time alerts and notifications that can be sent to pagers or e-mail software such as Outlook 2007. With the Groove Mobile Workspace for SharePoint, users can take content on a SharePoint site offline to view and edit information. When users reconnect, the content is synchronized with the SharePoint-based portal. InfoPath can be used to quickly create forms for keeping track of volunteers, establishing approvals for delivery of emergency supplies and posting policies. Finally, the Instant Messaging capabilities of Microsoft Office Communications Server 2007 can be used for rapid, real-time, PC-based communications between two or more people without consuming a lot of network bandwidth.
The Department of Commerce and Economic Opportunity (DCEO) is charged with enhancing Illinois' economic competitiveness by providing technical and financial assistance to businesses, local governments, workers and families.
DCEO creates eGrants portal to ensure a scalable workflow and robust content management system
PR Contact: Terry Lutes CIO Department of Commerce and Economic Opportunity [email protected] (217) 524-4613
DCEO managed an increasingly complex and large grant request prcess and was expreienceing productivity inefficiencies.
They wanted to create a unique, single user interface to all agency programs, documents, and data. The chose to build an Office business application based on on Microsoft Outlook 2007 and Office SharePoint Server 2007.
DCEO’s solution included replacing the current client-server windows
interface for grants management
with a web interface that enables
content management, retaining tight integration of the web
interface with Microsoft Office 2007 on
the desktops as well as with the
Agency’s COBOL fiscal systems, and integrating disparate Agency databases
into a master database which
support the web portal interface.
In 2006, the London Stock Exchange (“the Exchange”) was the world’s third-largest exchange; the value of shares traded on the Exchange totaled approximately £7.57 trillion, or nearly U.S.$15 trillion—a 50 percent jump from the prior year.
Major Stock Exchange Streamlines Primary Account Managers’ Work, Improves Customer Service with Web-based Dashboard
Press Office+44 (0) 20 7797 1222
The relationship between the Exchange and its member firms is handled by the Exchange’s primary account managers, or PAMs. One of the biggest challenges they faced was the multiple data sources across the Exchange. PAMs needed to respond to client questions quickly and accurately. Depending on the complexity of the questions, the answer could take from a couple of hours to a couple of days to analyze and deliver.
The Exchange developed an OBA designed to dramatically streamline how PAMs access the wealth of information that is compiled every day in the Exchange’s data warehouses. The central element of the solution is the web-based intranet called PAM Dashboard. The dashboard is linked to a central data warehouse. From there, the information stored in the warehouse is turned into OLAP cubes; the information in the OLAP cubes is updated every 3 minutes. The data cubes are then delivered to the PAM dashboard. The PAM UI is based on Excel and uses Excel Services so that users can display and work with Excel workbooks through the dashboard.
Parsippany, New Jersey–based Skanska USA Building is the third-largest construction company in the United States, with approximately 3,800 employees.
Builder Improves Access to Information and Expertise with Enterprise Search Capabilities
Cole [email protected]: 718 746 2714
Skanska USA Building needed to help its employees more easily find information on the company’s enterprise-wide intranet portal, which spans back-end, line-of-business systems; public directories; and more.
Skanska picked Office SharePoint Server 2007 and took advantage of the server application’s Enterprise Search capabilities which extend beyond Web site content to include shared files, document repositories, and other unstructured information; information in line-of-business systems and other structured data sources; and directories of people and expertise, including information stored in the Active Directory service of the Windows Server 2003 operating system.
Google lacked the security layer that’s built into Office SharePoint Server 2007, which limits search results to the information that people have rights to access.
SYSPRO is a leading software solutions provider, supplying mid-market manufacturers and distributors with enterprise business applications.
OBA Enables SYSPRO/Office Integration, Unlocking Valuable Enterprise Data
Kevin DermanSystems Architect21 11 461 [email protected]
Syspro markets a range of enterprise software products targeted at mid-sized companies. These include ERP, CRM, and Business Analytics applications. External business partners and customers of companies using a SYSPRO LOB application were previously unable to easily access information from within the SYSPRO database . This access required a client application, training, and a full user license. Inability to access SYSPRO information inhibited the flow of vital business information and limited the use of valuable data. Because SYSPRO data was not easily integrated into Microsoft Office, users were also required to do additional work to bring information into business context. This lack of integration with Microsoft Office resulted in reduced productivity, business process discontinuity, and errors.
SYSPRO Office Integration (SOI) was developed using Visual Studio Tools for Office to seamlessly integrate SYSPRO and Microsoft Office. The purpose of SOI is to enable any user in the enterprise, whether SYSPRO is installed on the client machine or not, to access information directly from the SYSPRO database within a Microsoft Office application such as Word, Excel, or Outlook and to do this securely. XML schemas enable extraction of SYSPRO data, and secure web services are used to communicate between Office and the SYSPRO application server. Secure web services enable remote access, eliminate licensing requirements, and allow customer, supplier, and partner access to specified information.
TASER International manufactures advanced electronic control devices used by law enforcement, medical, military, and security professionals and consumers.
Protection Device Manufacturer Reduces Time-to-Market with Integrated Collaboration
Hi Tech and Electronics Manufacturing
Steve Tuttle, VP of Communications(480) 444-4000
When its staff quadrupled in two years, to 240, TASER International needed more efficient ways to collaborate than face-to-face meetings and lengthy e-mail strings. TASER also wanted to empower its information workers to manage intranet content without IT assistance.
TASER was looking for a solution that consolidated information about projects, employees, and business processes in one area
Taser partnered with Avanade to create an intranet portal built on Office SharePoint Server 2007. Taser picked Sharepoint over Lotus and other open source applications because open source choices didn’t scale to the enterprise, and deploying Lotus would have required a great deal of work to integrate into backend systems.
Sharepoint, on the other hand, provided tight integration with Office and the ability to tailor workflows to Taser’s own business processes.
T-Systems is the business customer brand of Deutsche Telekom. T-Systems’ 56,000 employees offer integrated ICT solutions from a single source.
OBA Solution for Engineering Design Unites Distributed Teams and Streamlines Projects
Media Relations49 69 6 65 35 - 1 [email protected]
T-systems was facing new challenges as its design and engineering practice shifted to distributed groups outside of the Original Equipment Manufacturer (OEM), complicating the overall workflow and process. In order to unify these disparate teams, there was also a need for an integrated project platform that crossed boundaries of individual companies within the organization.
T-Systems chose an OBA solution in order to achieve an integrated approach that simplified project management. With this implementation, Office SharePoint Server 2007 provides a platform for document storage and versioning, Office 2007 offers an interface for the back-end system, Office OpenXML documents serve as the data container for secure information exchange, and Exchange Server 2007 is deployed for project communication
WincasTech provides solutions in global messaging infrastructure, office automation, project and document management systems.
OBA Solution for the Construction Industry Improves Productivity and Reduces Project Delays
Professional Services Construction
Jacqueline LiSales Manager852 252 657 [email protected]
The construction industry lacks a unified system for project management and collaboration. In addition, the absence of an automated payment and approval process causes unnecessary delays. WincasTech wanted to address these concerns while also providing the ability for teams to view and mark up drawings online in order to streamline the building process.
eProjectDM , built on SharePoint Server 2007, provides shared collaboration space and seamless integration with the Microsoft Windows and Office platform. In addition, Windows Workflow Foundation integrates business process rules such as payment processing and approval processes into eProjectDM
China Telecommunications Corporation (China Telecom) is a large, state-owned telecom operator organized according to China's telecom industry reform scheme.
OBA Enables System Integration, Simplifying China Telecom’s Business Processes
PO Submission Form. (Built on ASP.NET and integrated with InfoPath and Sharepoint Server)
Email confirmation of PO with custom Ribbon in Outlook
Users can select product and click “Purchase” to submit a PO (Built using Silverlight)
PR Contact: Mr. Yang [email protected]+86-10-58552120
Using Virtual Earth.mash-up that shows status of sales data by location
Ability to export sales reports from Sharepoint to Excel
Ability to visualize sales data. Built on WPF.
China Telecom is the #1 fixed service Telecom provider in PRC. It provides approximately 62% of China's internet bandwidth.China Telecom’s procurement technologies were non-integrated. Order management, team collaboration, knowledge management, e-mail, billing and video monitoring systems were islands of information and process. This lack of integration made workflows cumbersome and unmanageable and the point-to-point integration was not scalable. It was hard for employees to track billing details and quickly see impact on sales.
To address these short-comings, they implemented an OBA-based application built on Office SharePoint Server 2007, InfoPath, and Silverlight which enables seamless systems integration. In addition, Windows Workflow Foundation automates workflows. Now, the procurement workflow is more automated with online submission forms and email notifications. In addition, sales employees can easily visualize their data both graphically and geographically.
Canada Post, one of the largest postal administrations in the world, employs 72,000 people and is based in Ottawa, Ontario, Canada.
OBA boosts productivity and helps increase customer satisfaction at Canada Post
Chantal Gauvreau(613) [email protected]
The organization was spending increasing amounts of time and money to get data into its SAP R/3 ERP system, and wanted to reduce that time and expense—while increasing data accuracy.
Canada Post adopted the Winshuttle TxShuttle solution, which gave it an Office Business Application interface through which to ease and automate the process of uploads to SAP. For Excel integration, WinShuttle uses COM (OLE Automation) to drive the Excel object and for Access, ADO.NET.
Energizer Holdings, based in St. Louis, Missouri, is a leading manufacturer of batteries, flashlights, and wet-shave products.
Energizer Simplifies Access to Business Data to Speed Collaboration, Workflows
PR Contact: none available
Energizer financial data for annual business planning resided in 20 different locales and currencies. A central organization had to spend time transferring all of this data to a home grown system and convert currencies manually. Similarly supply-chain information resided in several different LOB apps and employees would spend time exporting data from myriad systems into numerous spreadsheets. Beyond the work required to transfer LOB data into productivity applications, many Energizer workers simply couldn’t locate the information they needed.
Energizer used Office SharePoint Server 2007 to create a single companywide intranet called EnerNet. On this central portal, Energizer has 1,000 personal, team, and divisional SharePoint sites, all of which are searchable using the Enterprise Search service In SharePoint Server. Further, using the Business Data Catalog data integration service in Office SharePoint Server 2007, Energizer created connectors between SAP and other LOB applications and SharePoint Server 2007, which makes LOB data readily available from the company’s portal. The Business Data Catalog also provides the ability for Enterprise Search to search LOB data. In addition, the company plans to use Excel Services in Office SharePoint Server 2007 to automatically export data from LOB applications into Office Excel 2007 spreadsheets.
Epicor provides integrated ERP, CRM, SCM, and professional service automation (PSA) software solutions to more than 20,000 customers in more than 140 countries.
Office Business Application Extends Reach and Value of Enterprise Solutions
Lisa Preuss [email protected]
+1 949 585 4235
Epicor sought to increase the reach of its applications to more workers and provide access to its applications within the context daily business activities. Information workers often have to manually integrate disparate applications into their work environments to accomplish their work. This reduces productivity and can limit the quantity and quality of business information captured by a LOB application. Thus, in addition to increasing the reach of its applications to more users, Epicor also wanted to improve the value of its applications by simplifying how workers access and update the applications.
Epicor developed Epicor Information Worker (EIW) to deliver data from its applications to Microsoft Office programs. The EIW UI includes a custom toolbar with 4 buttons that provide the information worker with various ways to interact with data from Epicor LOB applications. While the current version of EIW was built on Outlook 2003, the buttons were developed with coding for the Ribbon in Office 2007. This enabled developers to build additional functionality into the toolbar, including the ability to light up buttons and items as appropriate to provide necessary data and guidance to walk employees through their basic business processes. EIW also includes custom folders through which users can subscribe to content that they need from Epicor apps. This content is delivered through Epicor Portal which uses Office SharePoint Server 2003 and WSS. The mechanism for this integration is a publication subscription process.
Pfizer Global Research and Development (PGRD) is a leading research and development organization in the pharmaceutical industry, with 12,000 scientific and medical researchers and a budget of more than U.S.$7 billion.
Better Collaboration and Deeper Context Improve Research Decision Making
Media Relations Office
Pfizer needed a way for its research biologists worldwide to sort through large volumes of data, analyze that data quickly, and share the results of their research with other scientists in order to speed up the process of developing new drugs. A faster development cycle would help Pfizer bring drugs to the marketplace and create new hope for people struggling with health problems.
Pfizer partnered with Microsoft & Infosys to create an OBA called Biologist Workbench. The Biologist Workbench is a set of tools built on .NET Framework 3.0 and SharePoint Portal Server 2003 and uses Windows Presentation Foundation and Windows Communication Foundation. This makes it possible for scientists to query the database (SQL Server and Oracle), select as many research results as they want, and then view that set of results in a multidimensional, visual display (“finding needle in haystack”).
The Biologist Workbench will allow Pfizer to make better-informed decisions regarding compounds earlier, which helps reduce drug discovery costs.
The Tampa Police Department is faced with the challenges of ensuring public safety during public events, such as the Gasparilla Day parade.
Law enforcement agency improves incident management with easy-to-use solution
Douglas PasleyEmergency Management Planner(813) [email protected]
Tampa UASI decided to use E•SPONDER, an OBA developed by Convergence Communications. The E•SPONDER solution enables the police department and Tampa UASI members to enter, share, and access operational information on a Web portal using Office 2007 programs on Mobile devices or laptops. The portal integrates area law enforcement agencies, fire and rescue departments, and emergency services all on a single communication and collaboration platform. Anyone working with E•SPONDER can write documents and memos, create spreadsheets, or create or edit electronic forms, and then post those files on the portal.