Site Server - Master Card International's Implementation of Clarus E-Procurement

Article
08/28/2007

August 1999

By Clarus Corporation and Microsoft Corporation

Version: Release 1.0

Introduction

Company Profile

Since its inception 30 years ago, MasterCard International has grown from a US-based credit card system into a leader in the multi-trillion dollar global payments industry, with credit, debit and chip cards as core competencies. In 1997, 23,000 member financial institutions recorded 6.5 billion transactions worth $602 billion through MasterCard.

Solution Overview

This global payments industry leader is rolling out an advanced corporate purchasing solution based on Microsoft® BackOffice® technologies: Clarus™ E-Procurement from Clarus Corporation, a software vendor and Microsoft Certified Solution Provider. The sophisticated system has slashed the average time required to fill a purchase order by 70% and cut the cost of processing purchase orders from $125 to $40, even as it delivers valuable reporting data.

Situation

MasterCard's corporate procurement process was paper-based and labor-intensive. Looking to cut costs and improve delivery times, while simultaneously enabling buyers to take a more strategic approach to their jobs, the company decided to automate and streamline its procurement process by bringing it online.

Business Solution

Working with Clarus, MasterCard deployed a cutting-edge, Web-based electronic procurement solution powered by Clarus E-Procurement, Microsoft Internet Explorer, and Microsoft BackOffice technologies. The system gives users easy access to a cross-supplier product catalog over the corporate intranet. When the user makes a selection, the system automatically creates requisitions, routes them for approval, and submits them electronically to the relevant supplier. Used now by 750 people, the solution will be rolled out in a controlled manner to 2,300 users across MasterCard's entire enterprise.

Benefits

Clarus E-Procurement has empowered MasterCard to slash the average time required to fill a purchase order by 70%—down from four days to one—and to cut the cost of processing purchase orders from $125 to $40—a 68% reduction. And there are bigger savings to come: the company was already saving an estimated $10,000 per month on office supplies, computer hardware, and computer software alone during an early pilot phase with just 250 users. Meanwhile, the system is giving MasterCard valuable reporting data enabling it to get maximum value for every dollar it spends.

Project Overview

Vision Statement

To provide MasterCard employees with one, easy-to-use system for ordering non-production, maintenance, repair and operations (MRO) goods and services across all approved suppliers that exceeds employee service expectations while ensuring compliance with contracted suppliers and improving business resource management.

Project Scope

Like most large-scale projects, the implementation of Clarus E-Procurement at MasterCard required a phased approach.

Phase 1: Pilot Program

A pilot program to prove the concept and the value of the proposed solution took place over a five-week period from project planning through rollout.

The initial implementation had to be a fully functional, standalone system. Integration with other systems was not desirable during this phase of the project as they were in the process of being re-engineered.

This phase of the project included carefully selected requisitioners, buyers and administrators from both the St. Louis and New York sites. The primary focus of the pilot was on office- and computer-related supplies in addition to promotional goods for marketing events.

Activity	Effort	Timeline
Project Planning	1 Day	Week 1
Infrastructure Enablement	3 Weeks	Week 2-4
Administrator Training	2 Days	Week 2
Supplier Enablement	3 Days	Week 3-4
Software Installation & System Test	2 Days	Week 4
Database Configuration	5 Days	Week 4
User Training & Rollout	2 Days of 30-minute training sessions in two locations	Week 4-5
Feedback	Ongoing	Week 2+

The pilot program continued for several months, first using a small base of users to qualify the product's ability to perform, then qualifying the product from a user-acceptance standpoint.

Phase 2: Production Rollout

The first version of Clarus E-Procurement was rolled out at MasterCard's New York and St. Louis sites starting in August, 1997. These users comprised the majority of administrative personnel and the entire purchasing department. The narrow scope of purchases was also expanded to include all externally procured goods and services.

Over the ensuing eight-month period, MasterCard conducted user orientation sessions and provided support through its Information Technology and Help Desk groups to smooth the transition of 750 users.

Phase 3: Enterprise Rollout

The next phase of the project was subject to the addition of feature enhancements to Clarus E-Procurement. These included the ability to:

Handle virtually all procurement activities, from internal services to complex marketing requests
Take advantage of Microsoft Commerce Interchange Pipeline (CIP) to communicate with suppliers

Suggestions gathered from user feedback were also added to the product.

All requisite enhancements have been added and the product is currently being rolled-out to all MasterCard employees. This phase of the project is scheduled for completion within the first half of 1999.

Phase 4: Back-end Integration

Clarus E-Procurement will be integrated with MasterCard's Enterprise Resource Planning (ERP) application—the installation of which is incomplete at this time—during this phase of the project.

Resource Requirements

Pilot Program

Initial deployment of Clarus E-Procurement involved a full-time project manager from MasterCard, with part-time support from various staff members. The project manager has been responsible for the project from mission through customer feedback.

Every successful project needs a champion, and this was no exception. This individual, an employee in the Purchasing organization, promoted solution adoption internally and mobilized the resources needed to deploy the system and accomplish the vision. This included selling the Information Technology (IT) department on the benefits of using the Microsoft technology platform as the infrastructure upon which to deploy the solution.

Additional support was required from key people in the IT, Purchasing, and Finance organizations.

Production Rollout

The production rollout required approximately three full-time people over an eight-week period to manage the project and provide connectivity for 750 users.

Support for Clarus E-Procurement beyond production rollout, including Catalog Management, Business Rules Management and User Profile Management, currently requires one half-time employee.

The person responsible for managing the entire system at MasterCard is a Purchasing employee. It's important to note that this individual is not required to have system programming experience.

The IT department's involvement has been limited to acceptance of the environment, installation of the hardware and network architecture, and support for the server and desktop environment. No database administrator (DBA) has been involved except to validate the system architecture. This has allowed the IT department to focus on other issues within the organization.

Organizational Process Requirements

Organizational change and end-user acceptance are typically the primary factors influencing new system deployment and success. However, unlike replacing an ERP system, implementing Clarus E-Procurement involves an entirely new breed of application. It was the first Web-based application at MasterCard, as it has been at many other Fortune 2000 companies.

"The goal was to move away from being a procurement group thatis tranaction-basedto one that is more strategically oriented. If you can set up an electronic process where the catalog is on the desktop, it really keeps the buyer out of the transaction itself and positions them to play a more strategic role."Jim Cullinan
MasterCard International
Vice President of Global Purchasing

Mostly casual users, rather than functional users, access this application at MasterCard. Therefore, end-user interaction and acceptance had to be handled differently than rollout of a replacement for an existing functional user application.

With this type of application, acceptance of process change is addressed by creating or modifying for end-users and purchasing professionals, and by communicating and monitoring compliance with those procedures. Additionally, IT requirements are identified and responsibilities assigned.

While this application provides significant benefits to the organization through process change and management information, it requires compliance by end-users to achieve results. Too many changes at once would thwart the effort and reduce the likelihood of success.

End-Users

The first step toward change is to provide end-users with access to the application. Rollout occurs in a controlled fashion while winning acceptance from key users. User-evangelists are very important to the success of a voluntary-use application. In addition, incentives to use the application must be in place, because individuals are not specifically measured on its use, as they would be with a functional use application.

As Clarus E-Procurement can be modified at any time without programming, no immediate changes to MasterCard's business rules and procedures were required. As a result, purchasing procedures were left unchanged for the first phase to allow validation of the system, ensure compliance, and reduce end-user hesitancy. Therefore, the only change a user had to endure was to use a new automated system instead of an old, manual, paper-based process. As might be imagined, this was a very welcome improvement.

With information never before available to the Purchasing organization, business rules and procedures can be modified and processes changed at any time as a positive result of the system. This change is a welcome one for those using the old system.

Purchasing Professionals

The greatest change resulting from MasterCard's implementation of Clarus E-Procurement is to the purchasing professional. Though hired as valuable knowledge workers, these individuals have been burdened with extensive paperwork; routinely performing tedious data entry tasks, fulfilling end-users' information and status requests, handling complaints and manually expediting and following up on orders with suppliers.

Purchasing professionals now can work at a higher, more strategic level—fulfilling the requirement for which they were originally hired. They no longer have to manually enter paper requests into a purchasing system. This task is now performed at the frontline—by the end-user. Nor must they field questions about order status from requisitioners. The system proactively provides this information to the end-user via e-mail. This information is also available to the end-user through the Web-based application.

Purchasing professionals now use the system to obtain information that was unavailable with the old, manual, paper-based systems. Armed with this knowledge, they can better anticipate supplier opportunities and negotiate contracts that are more favorable for MasterCard. They can also provide management with much better and more timely information about the purchasing habits of the entire organization.

Because Clarus E-Procurement uses Microsoft SQL Server™, database administration is minimal and access to information is secure, yet readily available through Clarus E-Procurement's standard reports, as well as a range of widely available, third-party tools. MasterCard uses Microsoft Access as a reporting tool. With it, purchasing professionals gain insights into the purchasing habits of the organization and Accounts Payable ensures the timeliness of vendor payments.

IT Professionals

Clarus E-Procurement frees IT Professionals from the burden of system administration. This is a significant and welcome change.

Often, systems are ruled out due to the burden they place on the IT organization. Clarus E-Procurement follows Microsoft's "Zero Administration" philosophy by ensuring that the application only depends on its knowledge experts for maintenance. This reduces the burden on the IT organization to manage an application for which they are not experts.

IT has enjoyed benefits from the new system, too. Because MasterCard uses Microsoft Windows NT® Workstation as the standard desktop operating system, the best time to authorize an individual's use of an application is during initial system configuration. Therefore, the IT department now sets up the user and Microsoft Internet Explorer on the desktop every time a new machine is received. Desktop components used by the application and the user profile are verified upon installation.

Clarus developed a utility that enables administrators to push E-Procurement's components to the desktop for rapid installation on existing machines.

Functional Requirements

MasterCard had a number of specific objectives they wanted to accomplish. Before any electronic procurement system would be accepted, it had to:

Be scalable

Be capable of supporting transactions generated by every employee in the organization.
Have a supplier integration strategy that met the company's core business requirements and objectives.

Lower the number of incomplete or incorrect orders that suppliers receive while simultaneously increasing overall order volume by reducing unauthorized buying.
Be easy to install, configure, maintain and use

Offer a "user-compelling" experience—so users prefer it to the old, manual paper-based systems. As a result, users will not subvert it by engaging in "maverick" buying practices. And it must do all this without placing an undue burden on the IT organization.
Integrate with ERP

Support seamless integration with an impending ERP implementation as well as existing back-end systems.

Through these objectives, MasterCard's Purchasing Department made "Customer Delight" their number one priority.

Scalability

A key requirement in MasterCard's electronic procurement strategy was to obtain a cost-effective, scalable architecture to meet its enterprise needs. By selecting Clarus E-Procurement, MasterCard made the strategic decision to closely align themselves with Microsoft's electronic commerce strategy. All Clarus products are created exclusively with native Microsoft technologies. As such, MasterCard's chosen solution is well suited to take advantage of the rapid advancements being made in Web-based technologies.

The MasterCard implementation plan called for the electronic procurement application to be deployed initially within a small pilot group, with incremental rollout to the entire user community.

When this type of application is implemented across an entire enterprise, user concurrency from 3% to 5% is expected. That is, between 3% and 5% of potential users are expected to access the system at any one time. Currently 750 users, mostly administrative personnel and purchasing professionals, have access to and actively use the system. Given their functional responsibilities, concurrency is significantly higher than 5%. In fact, these users generate about 60% of the total forecasted transaction volume for the enterprise.

The current system runs on a dual processor Pentium 300 server hosting the Microsoft SQL Server 6.5 database, Microsoft Internet Information Server 4.0 and Clarus Enterprise Application Server. As MasterCard's user base and transaction volume increase, the Clarus n-tier architecture will allow the application components to be distributed across multiple servers, thus providing much higher capacity. Based upon current benchmarks, the Clarus solution is expected to effectively scale to support a user base many times greater than MasterCard's future requirement.

Catalog Management

One of MasterCard's basic requirements for any electronic procurement solution was (past tense is used when referring to their other requirements… we should keep this consistent) an online, integrated product catalog. Their assumption was that errors created by the old, manual, paper-based processes would be dramatically reduced, and quite possibly eliminated with such a system.

MasterCard's requirements for catalog access, creation and management were:

Users access product information without going to the Internet.
Users find products without knowing the supplier.
The system accommodates all suppliers, regardless of size or technical sophistication.
The system does not require suppliers to buy new technology in order to do business with the company.
The system allows for the adoption of new catalog maintenance methodologies.
Easy catalog maintenance.

In order to satisfy these diverse requirements, Clarus E-Procurement supports a comprehensive, hybrid approach to catalog access, creation and management.

To allow access to product information without going to the Internet, the cross-supplier catalog is situated on MasterCard's trusted intranet, protected by a firewall. This permits quick, secure access to the information required for decision making.

Finding the right product is very easy. Users can search by partial or complete part numbers, keywords, suppliers or manufacturers. Additionally, any of these keys can be combined to refine the search.

MasterCard's suppliers do not wish to invest in non-standard solutions. Tier One suppliers want to leverage existing investments in their Web sites, while Tier Two and Tier Three suppliers want to support existing solutions without investing in proprietary technology.

For these reasons, Clarus E-Procurement supports suppliers of varying levels of technical sophistication and offers multiple methods of cross-supplier catalog population:

Manual

Basic data entry, directly into the application.
Import

Cross-supplier catalog content in various electronic forms—including CD-ROM, Microsoft Excel, and standard ASCII file formats such as Catalog Interchange Format (CIF).
Dynamic

In early 1999, Clarus E-Procurement is integrating CenterStage from OnDisplay for dynamic catalog content management, thus eliminating any manual or scheduled batch update processes.

A single administrator maintains the catalog through the Clarus Catalog Manager. The application's graphical user interface (GUI), built with Microsoft Visual Basic®, allows for single item entry and update, as well as catalog updates, with the ability to determine what type of update is performed.

This combination of technologies eases the burden of catalog management on MasterCard while eliminating the need for suppliers to invest in new technology in order to do business with the company—although they can realize significant benefits by doing so.

Configuration, Maintenance, and Use

MasterCard required that the electronic procurement system be maintainable by one, functionally-oriented individual, rather than many IT professionals. They did not want to focus precious IT resources on an application that was not mission critical—even though the ROI more than justified its implementation.

Clarus E-Procurement includes a full suite of tools that address this requirement. Together, the Clarus Enterprise Manager (CEM) and the Clarus Catalog Manager (CCM) permit non-IT professionals to effectively administer, configure, monitor and maintain the system.

Through its GUI, created with Microsoft Visual Basic, an administrator uses CEM to:

Configure the user interface
Create and maintain user profiles
Create and maintain supplier profiles
Populate and maintain enterprise information, such as accounting codes, etc.
Add, change and delete business rules and approval workflow

CCM creates and maintains cross-supplier catalogs. It provides the functionality to enhance catalog data, so that casual end-users can quickly and easily find the correct products or services. CCM includes import utilities, which facilitate catalog updates from a simple modification, such as a price change on a single product from one supplier, to a full catalog refresh. A rollback feature allows administrators to undo improperly applied changes to the catalog.

While the version of Clarus E-Procurement used during the pilot program had an efficient and functionally rich user interface, end-user feedback led to an improved second-generation product now being implemented at MasterCard. This includes a new user interface that is at once more aesthetically pleasing and more intuitive. Now, instructors spend more time teaching users about process change and less on the product itself. Training sessions last an hour, including a question and answer period, for 20 to 25 people.

In addition to these usability goals, MasterCard wanted to achieve a specific objective: The ability for a casual end-user to create and submit a purchase requisition within 30 seconds. To accomplish this goal, the product offers an event-driven procurement model.

In this model, administrators and end-users can create requisition templates that include all products and services that are appropriate for a given event—new employee hire, etc. Within Clarus E-Procurement, these requisition templates are referred to as hot lists. These can be either public or private. As the names imply, public hot lists are accessible by all users, while private hot lists are just that, accessible by only the creator.

When end-users create requisitions, they use an electronic shopping basket. Another type of requisition template, a stored basket, complete with item quantity, account code distributions and other information, can also be created here. This is done most frequently for routine orders—a bimonthly office supply order, for example. Like hot lists, stored baskets can be either public or private.

Whether hot lists or stored baskets are employed, the majority of MRO purchases are driven by an event, and the use of these templates allows the system to meet MasterCard's requirement for lightning fast requisition creation and submission.

Operations

Reporting

"They are really getting much more information than ever before. For example, looking at office supplies, what does the average person spend a month on office supplies? How does that vary from department to department? We can drill down all different kinds of ways, and the users can go in and get this information whenever they want. We're learning a lot."Jim Cullinan
MasterCard International
Vice President of Global Purchasing

The E-Procurement client includes common user reports, which requisitioners use to report and track their own expenditures. However, MasterCard's Purchasing Department generates additional, more complex reports using Microsoft Access and an ODBC connection to the E-Procurement Microsoft SQL Server database. Using various criteria, such as number and dollar total of transactions, by supplier, per month, MasterCard's Purchasing Department can report and analyze:

The average dollar expenditure per transaction per supplier and the average overall dollar expenditure per transaction.
The average number of line items per transaction per supplier and again an overall average number of line items.
The order processing time from submission of request to approval and transmission to the supplier, categorized by commodity.

Troubleshooting

Since most common errors relate to the configuration of Clarus E-Procurement, an E-Procurement administrator resolves 99% of troubleshooting issues. Occasionally additional help is required from IT staff or Clarus Customer Service.

If the issue is related to:

Orders

Users call the appropriate MasterCard buyer for the commodity/supplier.
Catalog

For problems with catalog data, the E-Procurement administrator contacts the appropriate supplier(s). For all other issues, they call Clarus Customer Service.
Server

The E-Procurement administrator contacts MasterCard's IT Department contact for problems with Windows NT Server, Internet Information Server, SQL Server, E-mail, etc. They call Clarus Customer Service application-level issues.

The E-Procurement server generates messages during the workflow process. Key messages indicating status of the workflow are displayed on the server monitor screen. Error messages are also sent via e-mail to internal designees such as the E-Procurement Administrator and IT Administrator. Optionally, these contacts can also be paged.

Maintenance and Backups

Automated and routine virus scanning and database backups comprise the bulk of maintenance for the E-Procurement server. Occasional file purges help maintain adequate disk space. Also, the IT administrator routinely checks the server with remote monitoring and administration utilities.

Manual backups complement the automated routines. These are performed before any significant operation is executed, such as importing major catalogs and updating data sets with scripts.

Staging

A test server stages the new product upgrades. Future plans include using the test server to prototype and stage changes on same-version product, including enterprise configuration changes, users, suppliers, and routing rules.

Back-end Integration

Like most Fortune 2000 companies, MasterCard has multiple back-end systems from several vendors. In addition to various internally-developed legacy systems, MasterCard is currently in the process of implementing a commercial ERP system.

MasterCard requires that the electronic procurement solution have the ability to seamlessly integrate with its heterogeneous back-end environment. Moreover, they require that the system provide a level of abstraction and isolation from the back-end systems. That way, the electronic procurement system can continue to function without modification as back-office applications are upgraded.

Clarus E-Procurement satisfies this requirement through a message-based integration strategy that leverages Microsoft Transaction Server (MTS) and Microsoft Message Queue Server (MSMQ). This loosely coupled approach enables MasterCard to affect integration with multiple, heterogeneous back-office systems in near real-time in an extremely cost-effective manner.

Solution Implementation

MasterCard's original procurement environment was a combination of Microsoft Access databases and Lotus Notes. The system provided electronic forms-type messages for certain types of purchases, coupled with some basic workflow routing. MasterCard required an integrated solution that included:

Catalog-based product selection based on easy implementation
Broad support for suppliers, regardless of their level of technical sophistication
Automated user profile creation
Event-driven purchasing (new employee hire, etc.)
End-user requisition tracking
Highly flexible, yet manageable, business rules administration
Multiple site deployment with organizational separation
Standards-based, yet forward-looking, electronic communications with suppliers
Robust management reporting
Integration with existing and future back-end applications

And, of course, it all had to work within their existing technical environment.

To accomplish this, the solution was developed using a Microsoft-centric architecture. This was done for several reasons, including Microsoft's commerce strategy and the development of an industry-leading vision of supplier integration. Microsoft Site Server Commerce Edition with the Commerce Interchange Pipeline (CIP) is key to delivering on this vision today and in the future.

"We did evaluations of who had product out there, and more importantly who had product that was actually working. Clarus was a company that was very aligned with our strategy, very willing to work with us. They were committed to our project, and it was as important to them for this to be a success as it was for us."Jim Cullinan
MasterCard International
Vice President of Global Purchasing

MasterCard sought a partner that would allow it to implement a solution immediately while keeping abreast of industry and technology trends. Implementing support for CIP made possible an integrated and secure communications session between MasterCard and its suppliers. As more of MasterCard's suppliers take advantage of CIP, they will be able to create near real-time communications sessions over which to transact business—with both parties realizing many benefits in the process.

A key driver of this architecture is the need to satisfy the functional requirements and technology issues—not only for the internal procurement process, but for supplier and back-office integration as well. Since the requirements and technologies differ significantly between these three domains, each is addressed in turn.

Internal Procurement

Logical Architecture

Figure 1 illustrates the logical architecture of Clarus E-Procurement as used at MasterCard.

Figure 1 Clarus E-Procurement Logical Architecture At MasterCard

All the MasterCard transaction, profile and catalog index data are maintained in one Microsoft SQL Server database. The schema contains tables for entities such as user, supplier, catalog item, routing rule, order, and report. Purchase order attachments and rich content information (pictures, etc.) are stored in a specified file structure outside the SQL Server database.

MasterCard administrators use two client applications to configure the system:

Clarus Enterprise Manager performs such tasks as creating users and their roles, setting up approval routing rules and setting up supplier information.
Clarus Catalog Manager creates and maintains catalogs.

All end-users interact with the procurement system through Web browsers. Virtually all MasterCard users are on Microsoft Internet Explorer 4.0x. As a result, these users view ActiveX® components served through Active Server Pages. Users with older, or non-Microsoft, browsers view the HTML 3.0 version of the application. Since Clarus E-Procurement takes advantage of the performance and component characteristics of ActiveX, users with Microsoft Internet Explorer 4.0x enjoy a much richer experience.

MasterCard chose to access Clarus E-Procurement via its existing Lotus Notes desktop. Once requested, Clarus E-Procurement:

Displays the user interface
Controls navigation through the procurement process
Manages the interactions between both the client- and server-side business objects and the database

The organization of ASP's in the Clarus E-Procurement Application Server mirrors the end-user interface. Figure 2 offers a high-level view of this organization.

System Administrator Responsibilities

Figure 2 High-Level Active Server Pages Organization

All users enter Clarus E-Procurement through Default.asp. This page prompts for user name and password, then starts the session. After querying the database for user information, it sets session variables, and determines the user's browser type and version. Main.asp is opened as appropriate to the browser type and version (ActiveX or HTML).

Main.asp creates a frameset at the highest level of the browser interface, and houses scripts used throughout the application. The user can set the look of the frames.

Five tabs are always displayed: Catalog, Shopping Basket, Orders, Reports and Preferences. Each represents an ASP or group of pages. When a tab is selected, the functionality available on any given page depends on the user's authorized role.

When the user submits a requisition, Clarus E-Procurement Workflow routes it to the appropriate approver(s) via e-mail. Once all approvals are received, purchase order(s) are transmitted. Available transmission methods include hardcopy, e-mail, fax, output of an EDI-friendly text file, or Commerce Interchange Pipeline (CIP). Processing intervals for Workfloware configured through Clarus Enterprise Manager.

Physical Architecture

Components for the application, workflow and database may be deployed on the same or physically separate servers. This provides for scalability, as well as for logical partitioning based on the enterprise's business requirements. MasterCard currently runs all three components on the same physical server.

Security

Clarus E-Procurement uses the Microsoft Windows NT and SQL Server security models for user access. Users must provide an ID and password to gain access to the network and the application. IIS and SQL Server manage data security.

E-Procurement user profiles indicate functional, access-level authorization. Users may be authorized as a:

Requisitioner able to create and submit requisitions and receive against their own orders.
Approver able to approve orders based on approval routing rules.
Receiver able to receive against all orders.
Buyer able to manage catalogs

Load Simulation

MasterCard requires that Clarus E-Procurement support as many as 3,000 users with a 3% to 5% concurrent usage load. About 25% of the organization currently uses the system, with concurrent usage at about 60%.

In February 1998 Clarus performed load simulations using Rational LoadTest 6.1. Testing variables were manipulated to ensure a "lowest common denominator" environment. Specifically:

The Workflow server was turned off during the simulation, replicating a user option to run the Workflow batch process during non-peak hours.
The testing application and database servers resided on the same physical Windows NT based-server—a modest Pentium 166 with 192 MB of RAM.
The testing network was a 100 Mbps Ethernet, and all workstations were equipped with 100 Mbps NIC's.

The test consisted of one "GUI user", a real user for whom system responsiveness was measured, and a number of "virtual users." The simulation software only allowed the GUI user to interact with ActiveX controls. The additional virtual users provided an easy means to simulate load with minimal hardware.

The GUI user repetitively performed the following tasks:

Log in
Search on a part number
Add the part to the shopping basket
Submit the requisition
Change a preference
Log out

The GUI user averaged 45 seconds to complete each cycle in no-load environment.

Virtual users also repetitively performed a sequence of tasks. However, because virtual users could not interact with ActiveX controls, they performed the following tasks:

Log in
Read a record from the database
Log out

The GUI user averaged 120 seconds to complete each cycle when the system was stressed under load.

In general, these tests verified acceptable performance at anticipated load levels.

Technologies

To build the optimal solution that affords MasterCard the opportunity to obtain a rapid return on investment, while maintaining upgrade flexibility, the application uses the following technologies:

Dynamic Web pages, employing ASP, HTML, JavaScript, and VBScript
Client-side ActiveX controls
Active Data Objects (ADO)
Remote Data Services 1.5 (RDS)
Windows NT Server 4.0
Internet Information Server 4.0 (IIS)
SQL Server 6.5
Site Server 3.0 Commerce Edition

Third-Party Components

MasterCard requires end-users, as well as, management reporting. Clarus bundles Seagate Crystal Reports 6.0 with Clarus E-Procurement and includes numerous standard report templates for this purpose. With this technology, reports transmit to the browser, where the Crystal Reports viewer component allows users to search and sort the results.

System Configuration

The following tables list the system configuration for Clarus E-Procurement 3.0 as installed at MasterCard International.

Application Server
Operating System	Microsoft Windows NT Server 4.0 (SP3)
Internet Server	Microsoft Internet Information Server 4.0 with Microsoft FrontPage® Extensions
	Microsoft Remote Data Services 1.5¹
Reporting	Seagate Crystal Reports 6.0 (runtime version)¹
Network Protocol	TCP/IP
E-Mail Client	Lotus Notes 4.6
Hardware	HP Kayak 3000 Dual Pentium II 300 MHz Processor 128 MB RAM 4 GB Hard Drive
Database	Microsoft SQL Server 6.5 (SP4)
Database Connectivity	Microsoft ODBC Administrator 3.51

¹ Denotes third party license provided with Clarus E-Procurement.

End-User Workstation
Operating System	Microsoft Windows NT Workstation 4.0
Web Browser	Microsoft Internet Explorer 4.0x
Network Protocol	TCP/IP
E-Mail Client	Lotus Notes 4.6
Hardware	Pentium 133 MHz or better processor 32 MB RAM 800 x 600, 256-Color SVGA Video Adapter and Display

Administrator Workstation
Operating System	Windows® 95/98 and Windows NT
Reporting	Crystal Reports 6.0
Database Connectivity	Microsoft ODBC Administrator 3.5
Network Protocol	TCP/IP
Hardware	Pentium 133 MHz or better processor 64 MB RAM 800 x 600, 256-Color SVGA Video Adapter and Display

System Administrator Responsibilities
Windows NT Server Administrator	Prepare and install Clarus E-Procurement server software
Web Master	Web configuration and maintenance
Database Administrator	Performance Tuning SQL Server Monitoring Backups

Supplier Integration

"The vendors who are on it absolutely love it. This makes the transaction on their end much easier." Jim Cullinan
MasterCard International
Vice President of Global Purchasing

For MasterCard, and most other Fortune 2000 companies, supplier integration is a key component of an electronic procurement solution. Clarus addresses supplier integration through both catalog and transactional data. In addition, MasterCard requires that Clarus E-Procurement be able to work with any supplier to minimize the cost of business transactions between the buying organization and its suppliers. Since the number and variety of potential MasterCard suppliers is vast, E-Procurement must offer flexible, low-cost solutions for online transactions and catalog management.

Logical Architecture

The system components associated with delivering supplier integration to MasterCard are illustrated in Figure 3.

Figure 3 Supplier Integration Components

Workflow

Clarus E-Procurement Workflow is responsible for transmitting purchase orders to suppliers. The available transmission methods are hardcopy, e-mail, fax, EDI, and Microsoft Commerce Interchange Pipeline (CIP). Of these, only EDI and CIP offer application-to-application transaction automation.

Historically, EDI provided the only option for application-to-application integration of business transactions. However, EDI is expensive and labor intensive. To use EDI, both MasterCard and its suppliers would be required to implement translators and establish relationships with Value Added Network providers. Although MasterCard and some of its suppliers are moving in this direction, it is not the most cost-effective or efficient solution for either party given today's Internet technologies. Microsoft Site Server Commerce Edition with CIP provides the first commerce framework that shows significant promise to reduce the reliance on EDI for automated transactions over the Internet.

Catalog Manager

Clarus Catalog Manager (CCM) is used by MasterCard's administrator to create and update catalogs. It uses a fixed-format text file to update the catalog table in the E-Procurement database. To convert the different file formats provided by suppliers into a fixed-format text file usable by CCM, Clarus E-Procurement supports CenterStage from OnDisplay.

Online Transactions

As mentioned earlier, MasterCard supports multiple purchase order delivery mechanisms for its suppliers. Hardcopy, fax, e-mail, EDI and CIP are all utilized. The TransmitVia component in the application directs transactions to the correct delivery format as outlined below:

TransmitViaEDI directs a formatted file with pre-defined EDI data elements to an EDI translator for transmission to suppliers.
TransmitViaE-mail directs a Crystal Reports-formatted attachment to the e-mail server at MasterCard (Lotus Notes) with the address definition required for delivery to the supplier's order entry desk.
TransmitViaFax directs a Crystal Reports-formatted attachment to the fax gateway at MasterCard with the address definition required for delivery to the supplier's order entry desk.
TransmitViaPrint routes a Crystal Reports-formatted document to a printer for delivery via postal mail.
TransmitViaCIP transmits structured data to a supplier through Microsoft Commerce Interchange Pipeline (CIP). CIP allows applications to freely exchange information without respect to transport protocols and data formats.

CIP manages the transport and data format details and is easily configured using Microsoft's graphical Pipeline Editor.

TransmitViaCIP allows administrators to define the data source, fields, field names, and field hierarchical organization. This minimizes transaction costs, because a different purchase order document structure may be defined for each supplier for repeated use.

Microsoft Commerce Interchange Pipeline

Figure 4 illustrates one scenario in which applications at separate trading partners exchange data via CIP. In this scenario, Clarus E-Procurement Workflow transmits a purchase order to Supplier A.

Figure 4 Data Exchange Via CIP

Step 1: Workflow's transmit step creates a Microsoft Commerce Dictionary object, and populates it with purchase order data. The transmit step then invokes the transmit pipeline configuration file for Supplier A (SupplierATrans.pcf) and passes it the populated dictionary object

Step 2: The transmit pipeline configuration file knows what data format, encryption method, and transport protocol to use. It formats the data in XML, encrypts it, and performs an HTTP Post to the EPReceive.asp at Supplier A's website.

Step 3: The receiving ASP creates a Microsoft Commerce Dictionary object invokes the receive pipeline configuration file (EPReceive.pcf), passing it the dictionary object and the incoming data.

Step 4: The receive pipeline configuration file knows what encryption method and data formats were applied to the incoming data. The receive pipeline receives the incoming data, decrypts it, parses the XML, populates the dictionary object with the data and passes the dictionary object back to the ASP script.

Step 5: The ASP script navigates and processes the populated dictionary object as appropriate. In Figure 4, the ASP script updates the supplier's database.

Figure 5 shows the creation of a transmit pipeline configuration file in Microsoft's Pipeline Editor. The pipeline consists of a sequence of stages (Map, Add Header, Digitally Sign, Encrypt, Audit and Transport), for which a choice of components are provided. A simple right-mouse click adds a component at any stage.

Figure 5 CIP Editor

Fundamentally, CIP serves to reduce the size and complexity of the application's architecture by abstracting data transport processing. Note how CIP simplifies the requirements of dealing with multiple suppliers. In Figure 4, if the purchase order is sent to Supplier B instead of Supplier A, Workflow's transmit step merely invokes SupplierBTrans.pcf instead of SupplierATrans.pcf. The Workflow application knows nothing about the data format, encryption and transport methods employed in either case.

Clarus TransmitViaCIP

Clarus TransmitViaCIP allows the administrator to define document structure, data source, included fields, field names, and hierarchical field organization. In addition, Clarus E-Procurement provides for file attachments to be transmitted along with the document.

The administrator defines a new document structure, or "schema", by making entries in database tables. A schema consists of a hierarchical organization of "document objects", each of which represents a logically related group of data items. For example, document objects in a purchase order schema typically include:

Order header
Dates
Requisitioner
Shipping
Billing
Line items
Attachments.

Data required for each document object include:

Unique ID
Name
Type
Name of stored procedure that will be executed to obtain the data for populating the object
Object parent ID of the object's parent (to establish the hierarchical structure).

In addition, "friendly" field names can be specified so that the name transmitted for any given field can differ object schemas.

Three data types are used for document objects:

Dictionaries are Microsoft-provided "Commerce objects." They are containers that hold attribute/value pairs, where values are any type of object.
SimpleLists are Microsoft-provided "Commerce objects." They are containers that hold unnamed objects that can be enumerated in code or script.
Attachments are Clarus-provided objects. They areused specifically for representing file attachments.

Because a Dictionary can contain Dictionaries and SimpleLists, and a SimpleList can contain Dictionaries and SimpleLists, it is straightforward to represent arbitrary hierarchical data using them.

The interface to TransmitViaCIP is:

Public Function Process(vDataSource As Variant, _
vDataKey As Variant, _
vCIPSchemaID As Variant, _
vPipelineConfig As Variant) As Boolean

The Boolean return value indicates success or failure of the transmit operation. The parameter meanings are as follows:

vDataSource specifies which database contains the document data.
vDataKey specifies the ID that uniquely identifies the document to be transmitted. For example, the purchase order number identifies a purchase order.
vCIPSchemaID specifies the ID that uniquely identifies the administrator-defined schema to use. For example, this might specify the purchase order schema for SupplierA.
vPipelineConfig specifies which transmit pipeline configuration file to use. For example, this might be SupplierATrans.pcf.

Clarus Workflow Transmit Step Example

The administrator previously used Clarus Enterprise Manager to specify that purchase orders for Supplier A should be transmitted via CIP, and identified the schema ID as well as the transmit pipeline configuration file.

When the transmit step encounters a purchase order for Supplier A, TransmitViaCIP is invoked and the data source, purchase order number, schema ID, and the name of the transmit pipeline configuration file are passed to it. TransmitViaCIP then performs the following tasks:

Schema is read (using vCIPSchemaID) from the database (vDataSource)
Document structure is built using Dictionary, SimpleList, and Clarus Attachment objects as specified
Stored procedures specified in the schema are executed to obtain the purchase order data (using vDataKey) from the database (vDataSource)
File attachments are read
Document structure is populated with the purchase order data and any file attachments
Root document structure object is passed to the transmit pipeline (vPipelineConfig)
Root document structure object is transmitted to the supplier
Return result is passed to the transmit step of Clarus Workflow

Supplier Technical Requirements

Clarus E-Procurement imposes no "requirements" on suppliers. However, in order to realize the benefits available by using CIP, suppliers must implement Microsoft Site Server Commerce Edition. Additionally, CIP and the TransmitViaCIP object included free of charge with Clarus E-Procurement must be configured and enabled.

The default installation of Clarus TransmitViaCIP assumes that HTTP Post is employed as the transmit method in the pipeline configuration file. It further assumes that the supplier is running Microsoft Internet Information Server so that received documents can be navigated and processed with ASP scripts that are provided in near-complete form by Clarus.

In this scenario the supplier requires the following components:

Microsoft Internet Information Server
Microsoft Site Server Commerce Edition
The Clarus ReceiveViaCIP component to decode file attachments
The EPReceive.pcf receive pipeline configuration file. This must be compatible with the transmit pipeline configuration used by the buying organization.
The EPReceive.ASP script. This ASP, which is included with Clarus E-Procurement, contains the script to call the receive pipeline, and to navigate and process the data structure. This must be compatible to the schema defined at the buying organization.