Integrating Microsoft BackOffice with Microsoft Office 2000

enginestagNetworking and Communications

Oct 26, 2013 (3 years and 7 months ago)

131 views




Integrating Microsoft BackOffice with
M
i
crosoft Office 2000

White Paper

Abstract

Microsoft
®
BackOffice
®

Server 4.5, the integrated server suite optimized for the Windows

NT
®

Server operating system, simplifies the development
, management, and deployment of
powerful solutions for departments, branch offices and midsized organizations.

®



.

The combination of the Microsoft
®

BackOffice
®

family with
Microsoft Office

2000 enables businesses of

all sizes to build
knowledge management solutions for tracking, publishing,
collaborating on, and analyzing corporate information. When
BackOffice family components are deployed using BackOffice
Server, customers get the additional benefit of of an integr
ated
server that is easy to setup, deploy, and manage. This white paper
will show how developers, administrators and users can build
knowledge management solutions that take advantage of the
unique services offered in Microsoft Office and BackOffice.

BackOffice Server 4.5
and Office

2000






Office

2000 & BackOffice


Foundation for the Digital System

................................
........................

1

Introduction

................................
................................
................................
................................
...........

2

Digital System Solutions

................................
................................
................................
......................

3

Building Digital System Solutio
ns with Office

2000 and BackOffice

5

Knowledge Management

................................
................................
................................
......................

6

Microsoft’s Knowledge Management Platform

7

Knowledge Services

7

System

7

Third Party Solutions

8

BackOffice and Office in the Knowledge Management Platform

8

Feature Summary: Knowledge Management

8

BackOffice

8

Office

2000

9

Knowledge Management Solutions

................................
................................
................................
...

10

Publishing and Searching

10

Collaboration and Communication

12

Data Analysis

15

Tracking and Workflow

17

Operations or Line of Business

................................
................................
................................
.........

19

Web
-
based Applications

19

Commerce

................................
................................
................................
................................
............

20

Infrastructure

................................
................................
................................
................................
.......

21

Management

23

Deployment

25

Enterprise Integration and Interoperability

27

Application Development

28

Office and BackOffice Server in the Enterprise

................................
................................
...............

29

Deployment Scenarios

29

Branch Office

29

Departmental

29

Co
rporate vs. Workgroup

29

Appendix A: Benefits of an Integrated Server Platform

................................
................................
..

32

Reducing TCO

32

Unified Environment

32

Easy to Learn a
nd Use

33

Easy to Build

34

C
ONTENTS


Microsoft BackOffice Server 4.5 and Office

2000



Tools Integration with Application Services

34

Enterprise Interoperability

35

Enterprise Manageability

37

A Comprehensive Platform

37

Standards Support

37

Upgradeable and Extensible

38

Third
-
Party Support

38

Appendi
x B: What Is BackOffice?

................................
................................
................................
.....

40

Benefits of the Integrated BackOffice Family Platform

40

The BackOffice Client Access License

41

The Designed for Microsoft BackOffice Log
o

41

Appendix C: BackOffice Server 4.5


Features at a Glance

................................
............................

43

Appendix D: Benefits of Integrating BackOffice and Office
................................
............................

46

Appendix E: Additional Information

................................
................................
................................
..

49

Product Information on the BackOffice Family, Licensing and More

49

Other Important Information Sites

49


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
1

How your company manages and uses information may be the one factor that dete
r
mines
its failure or success

or runaway success. And how well you manage and use
information depends on the technology you use.

This white paper provides an overview of how Micr
osoft® Office and the Bac
k
Office


family combine to make a Digital System possible. It also provides an overview of some of
the tools and technologies of the Microsoft platform that will help you achieve the goal of
an integrated enterprise information sys
tem, from the desktop to the server.

Using Office and BackOffice together allows you to build solutions to your common
business problems, in a simple, integrated way. You will read about the ben
e
fits for:



Knowledge Management



Business Operations



Commerce



I
nfrastructure services


OFFICE

2000 &
BACKOFFICE


FOUNDATION FOR
THE DIGITAL
SYSTEM


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
2

By itself, Microsoft Office

2000 is a powerful tool for personal productivity, wor
k
group
collaboration, and World Wide Web publishing. When combined with the BackOffice
fa
m
ily, it becomes a tool for helping teams of p
eople to develop smarter ways to
co
l
laborate and interact with corporate data.

In the same way that Office

2000 delivers productivity in an integrated suite, Microsoft
BackOffice Server 4.5 offers a number of unique suite
-
level value
-
added features that
s
implify the development, management, and deployment of powerful solutions for
departments, branch offices, and mid
-
sized organizations.

By the end of this document, you will understand how the combination of Office

2000
and BackOffice makes it possible to
develop powerful business solutions. You will also
understand the role that individual BackOffice family products play in en
a
bling
Office

2000 features, and the additional benefits of deploying Office

2000 along with the
BackOffice Server suite in branch,
departmental, and intranet env
i
ronments.

Figure 1: Benefits of Deploying Office

2000 with BackOffice Server


INTRODUCTION

Office

2000 Desktop plus

BackOffice Family

Co
m
ponents



Integrated Digital
System Sol
u
tions

Office

2000 Des
k
top



Individual
Pr
o
ductivity

Office

2000 Desktop plus

BackOffice Server



S
implified
development,
deployment, and
ma
n
agement for
branch o
f
fices,
departments, and
medium sized
organiz
a
tions.


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
3

3

The companies that will succeed in today’s global economy are those that can pr
o
cess
information quickly, learn from exp
erience, and develop new strategies, and technology
plays a major role in the attainment of these skills. The Digital System is the Microsoft
vision for a technology infrastructure that will enable co
m
panies to compete in the Digital
Age. With a Digital Sy
stem, information flow is improved, allowing organizations to run
more effectively, and to act, react and adapt more quickly

all crucial factors in a
company’s ability to compete in a global env
i
ronment.

More specifically, a Digital System fosters rich co
mmunication between employees,
improves access to business
-
critical information, increases automated management of
computing resources and expands the ability to use information to automate core
business processes. This translates into software that integr
ates well with an enterprise
computing environment, and provides for efficient knowledge management. Microsoft
BackOffice, Office, and the Visual Studio


development system are key elements of the
Microsoft Digital System vision. This document discusses so
me examples of the deep
integration that brings companies one step closer to a Digital System.

A Digital System relies on connected PCs (local, mobile, and remote) and integrated
software to make the flow of information rapid and the information itself acc
urate. It
helps everyone to act more rapidly and make more informed dec
i
sions. It prepares your
company to react to unplanned events. It helps close the gap between your company
and its customers. It lets people focus on business, not technology.

A Digital

System has several advantages over conventional, one
-
off technology
approaches:



Makes companies agile.

Your company can compress the time it takes to perform
planned, routine business activities, without getting bogged down in d
e
tails.



Prepares your compa
ny for the unforeseen.

It provides all the information you
need to respond intelligently to an unexpected situation. It lets you quickly rearrange
priorities, people, and processes to head off threats and take advantage of sudden
opportunities.



Ensures tha
t you have all the up
-
to
-
date, accurate information

you need,
where you need it, and when you need it.

Your company is able to blend
intell
i
gence and information to make wise decisions.



Lets you reach beyond your organization in two important ways.

You can

get
closer to your customers and you can work better with par
t
ners.

Digital Systems are easy to use because they are built upon software components that
work together in a familiar, consistent way. People don't have to spend a lot of time
figuring out how

to make their computer processes work. New features are easy to
master and new applications are easy to learn. Your company can focus on results,
rather than on the tools used to achieve them.

DIGITAL SYSTEM
SOLUTIONS


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
4

4

As seen in Figure 2, a Digital System helps people work more
intelligently; helps an
organization improve business processes; and helps you work more closely with
customers and partners, making them a bigger part of your business. All of this is
enabled by powerful technology that is easy to learn and use, providing

a foundation for
flexible sol
u
tions.

Figure 2: Customer Focus








People

Process

Technology

Customer

Digital
System


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
5

5

Building Digital System Solutions with Office

2000 and BackOffice

The combination of the BackOffice family of server products and Office

2000 e
n
hances
the knowledge worker’s experienc
e by enabling key features such as si
m
plified
document publishing, workgroup collaboration, advanced search, simplified forms
design, and data analysis. BackOffice also makes a broader range of ente
r
prise data
and applications available to the Office user,

through integration with existing Unix,
mainframe, and AS/400 systems, as well as a wide range of database products, such as
Oracle, Sybase, DB2, and Informix. BackOffice can also simplify the rollout and
administration of Office

2000 clients through tool
s such as the Micr
o
soft Systems
Management Server.

There are several key categories into which solutions built into a Digital System fall.
Table 1 illustrates the key Office

2000 and BackOffice tec
h
nologies that enable these
scenarios:

Table 1: Digital Sys
tem Solutions


Key Product or Technology

Windows Distributed interNet Archite
c
ture

Scenario

Office

2000

BackOffice

Point of Integration

Knowledge Management:

providing access to business
-
critical information so individuals can make informed decisions

P
ublish and
Search

Word, Fron
t
Page

Windows NT Server with Internet
Information Server (IIS), Site
Server

Office Server Extensions, Extensible Markup
Language (XML) tags, universal HTML file
formats

Data Analysis

Excel

SQL Server™

OLE DB for OLAP

Tracking
and
Workflow

Access, Ou
t
look

SQL Server, Exchange Server

Data Access Pages, Access Projects, Routing
Objects, Scripting Agent

Collaboration

Outlook, Fron
t
Page

Exchange Server

MAPI, CDO

Business Operations:

making business processes faster, more efficient

and more reliable

Line
-
of
-
Business,
Mission
-
Critical
Applications

Office Web
Components
(OWC), FrontPage

SQL Server, SNA Server

Visual Basic for Applications, Visual Basic, Visual
Basic Scripting Edition

Commerce:

enabling business
-
to
-
business and busi
ness
-
to
-
customer interaction

Electronic
Commerce

OWC, Data Access
Pages, FrontPage

Site Server Commerce Edition,
SQL Server, SNA Server

Cut and paste HTML pages into Microsoft
Office

2000


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
6

6

Knowledge Management is a nascent but rapidl
y growing practice that seeks to
maximize the value of an organization by helping its people to innovate and adapt in the
face of change. A number of significant forces are pushing organizations to manage
more systematically their experiential and intellec
tual capabilities with knowledge
management practices.

The most relevant force with respect to the topics covered in this white paper is that of
the technology used to implement IT systems today. The technology itself has created
the imperative for knowled
ge management. The ability to capture i
n
formation,
knowledge, and data has far outstripped people’s ability to absorb and analyze this
information in a focused way. Companies whose people have access to the information
and skills necessary to spot trends a
nd manage opportunities will have a distinct
competitive advantage in exploiting market shifts. Furthermore, technology has allowed
today’s market leaders to build a new breed of solutions that dissolve the boundaries of
time and distance to enable global
value propos
i
tions to custo
m
ers

Knowledge management helps prepare people for an environment of constantly shifting
demographics, industries, economies and customer needs by ensuring that people have
the expertise and information they need in order to prop
erly assess business problems
and opportunities.

KNOWLEDGE
MANAGEMENT


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
7

7

Microsoft’s Knowledge Management Platform

Knowledge Services

The knowledge services provide centralized ma
n
agement of the core knowledge assets
of a company as well as enabling the seamless delivery and tra
cking of those assets.



Collaboration: Sharing Tacit Knowledge Across Time And Distance:

Office and Microsoft Exchange are integrated with collaborative capabilities
that allow users to innovate t
o
gether within their familiar desktop tools.
Exchange and Off
ice provide capabilities such as shared calendars and
tasks, threaded discussions, easy application cre
a
tion and folder home
pages to help groups collaborate. In addition, Microsoft NetMeeting®
contains tools such as white boarding, video, chat, and applic
ation sharing
that a
l
low users to not only communicate, but work together on knowledge
assets as they co
l
laborate.



Content Management
:

Capture and Manage Explicit Experience:

Content management technologies allow people to capture, codify and
organize exp
eriences and ideas in central repositories that enable
seamless, intuitive access to an entire organization. Exchange, Microsoft
Site Server and Office integrate to provide the ability to categorize, publish
and manage documents and content. Microsoft’s kn
owledge management
platform also supports workflow around content, such as versioning,
approvals, routing, and loc
k
ing.



Analysis: Turning Business Data into Knowledge:

Being able to quickly
spot trends in financial and line of business data allows decision

makers to
plan better strategies. The data warehousing and business intelligence
features in Office and SQL enable knowledge workers at all levels of a
corporation to better understand their markets. Data Transformation
Services allows SQL users to analyz
e data from any ODBC compliant
system. MSOLAP, Microsoft PivotTable® Services and Office Web
Co
m
ponents allow users to analyze vast amounts of data in their familiar
Office or browser environment.



Search and Deliver: Bringing Knowledge to Teams and Communi
ties:

Building teams and communities across a dispersed organization is
possible with portals built on personalized, cross
-
enterprise search and
delivery technologies. Site Server 3.0 searches across databases, public
folders, Web sites, and file shares. I
n addition, it is also able to deliver
personalized information to either community portals or d
i
rectly to users’
desktops.



Tracking & Workflow: Capture and Enforce Best Practices:

Tracking
services allow companies to identify best practices by measuring
s
uccesses, while workflow tools enable the creation of process based
applications to ensure that the practices are followed and measured.
Exchange Folder Agents and Routing Objects combine to provide a
powerful and flexible system for building workflow appl
ications.

System

Microsoft Windows

NT Server provides the foundation for the Digital System by
providing a scalable set of services that manage all the core elements of any solution.
Windows

NT Directory services provides a centralized, standards based dir
ectory for
managing information about the skills and competencies of employees that is directly

Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
8

8

integrated with standards based security.
Windows

NT

also supports extensible
business logic through Component Object Model (COM) and the Microsoft Technology
S
erver and provides links to legacy data in accounting or manufacturing systems
through COM
-
TI.

Third Party Solutions

Because every business is different, Microsoft has fostered the premier partner network
in the technology industry to provide businesses wi
th the choice of a provider that
understands their particular business needs. By making available a broad array of
qualified industry partners, Microsoft ensures that companies get the best solution for
their business.

BackOffice and Office in the Knowled
ge Management Platform

Microsoft provides its customers with a comprehensive platform of products that enable
their knowledge management practices. The attributes of the platform are designed to
ensure that corporations’ knowledge management efforts are au
g
mented by technology.



A
comprehensive

knowledge management platform needs to manage,
track, and deliver the three types of knowledge assets: tacit experience,
explicit exp
e
rience, and business data.



The platform must be
integrated

to provide a seamless an
d transparent
exp
e
rience to users, programmers, and administrators across the asset
types. Micr
o
soft is helping remove the barriers to knowledge management
by integrating knowledge services with users' desktops and information in
business systems to create

an environment where sharing information is as
easy as making a phone call or saving a document to a hard drive.



The platform must be
interoperable

with existing data in the system such
as legacy accounting systems. Drawing deeply on Internet standards
al
lows for both forward and backward interoperability as well as excellent
integration.



The platform must be
scalable
so it is available for knowledge
management initiatives from the team to the enterprise. This ensures that
every level of the organization h
as access to the same information. By
delivering scalable pro
d
ucts that can integrate knowledge management
practices from ad hoc team collaboration to structured line
-
of
-
business
applications, Microsoft’s platform can be adapted to a customer’s culture
and

strategy rather than vice
-
versa.

BackOffice and Office provide all the technologies necessary for building a knowledge
management solution and are the core of the Microsoft knowledge pla
t
form.

Feature Summary: Knowledge Management

BackOffice

BackOffice Se
rver delivers the core infrastructure for building knowledge management,
business operations and commerce solutions in a single, integrated server suite. This is
illustrated in Table 2.


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
9

9

Table 2: BackOffice Suite

BackOffice

Windows

NT Server

Server operati
ng system, providing services for file and print,
applications, communications, and Web appl
i
cations.

Exchange Server

Enterprise messaging, collaboration, and workflow ser
v
ices.

SQL Server

Enterprise database, online analytical processing (OLAP),
and dat
a warehouse services.

Systems
Management Server

Windows desktop and server manag
e
ment.

SNA Server

Access to a larger amount of company data, including
databases resi
d
ing on mainframes and AS/400 systems.

Proxy Server

Secure and high
-
performance Internet

a
c
cess.

Site Server

Analyze, search, and deploy Web sites and content.

Office

2000

Office

2000 delivers on knowledge management requirements by providing corporate
users with easier, more direct access to the data sources they need and enabling them
to
perform more useful business analysis. It provides effective methods of sharing
information using a familiar set of produ
c
tivity applications, as shown in Table 3.

Table 3: Office

2000 Suite

Office

2000

Word

Word
-
processing for highly efficient online com
munication
and collaboration.

Excel

Powerful spreadsheets, charts, tables, and PivotTable
dynamic views, as well as a robust front end to corporate
data, such as SQL Server databases.

PowerPoint®
presentation
grap
h
ics program

Organize, illustrate, and pr
esent your ideas and inform
a
tion.

Access

High
-
powered personal relational database
-
management,
forms
-
based applications and corporate data access, and
powerful SQL Server management tools.

Outlook

E
-
mail, scheduling, and desktop inform
a
tion
-
management.

FrontPage® Web
site creation and
manag
e
ment tool

Creation and management of outstanding Web sites

with no
programming required.


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
10

10

Publishing and Searc
h
ing

Getting users and customers connected to corporate data, and allowing t
hem to interact
with it effectively, is a driving goal of a Digital System. Using Web
-
based applications
and publishing and management methods, administrators can bring together new and
legacy systems to provide users with access to databases, corp
o
rate di
rectories,
documents, discussions, process
-
applications (forms), and more. With these tools, users
can create, publish, search, and manage new info
r
mation easily. Administrators and
content creators can deliver, manage, and analyze the Web site and data.

O
ne such example could include a corporate intranet solution for a company where
employees need to know how and where to access information internally. This might be
a customer service system or human resources application. Such a system would allow
informa
tion to be available to anyone in the organization

the right information, at the
right time, to the right people. This system would allow for the following:

Anyone can edit, post, and collaborate with any document on the Web site



HTML universal file format
s.



Standards
-
based, user platform
-
independent.



No IT department involvement in publishing data.

An increase in productivity



Allows decisions to be made where the work is pe
r
formed.



Leave files in native format and locale.



Enhanced ease of use, extended fun
ctionality for style, format, input
method, etc.

Microsoft Word, Windows

NT Server’s Internet Information Services, Index Server, Site
Server, and the Microsoft Office Server Extensions are the key enabling technologies for
building an information publishi
ng solution that provides simple and seamless data
access and interactivity to users. Features such as the following make accessing data
that much ea
s
ier:



Office Server Extensions:

Office Server extensions take advantage of
Inte
r
net Information Server to
provide the following features:



Subscription and Notification.

So that you know when a document
posted on the Web or in a public folder is changed.



AutoNavigation pages.

When documents are published to the Web
server, table
-
of
-
contents pages are automatica
lly created for easy
navig
a
tion.



Save directly to Web server.

Individuals and workgroups can save
files directly to the server in native HTML, and retain any special
formatting done by Office.

KNOWLEDGE
MANAGEMENT
SOLUTIONS


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
11

11



Site Server:
Site Server extends the simplified publishing feat
ures of
Office

2000 by adding powerful search and metadata tagging capabilities:



Catalog and Search.

Comprehensive information search capabilities
for Office users, across Office documents, HTML files, ASP files,
databases (SQL Server and A
c
cess), and Exch
ange public folders.



Web Publishing Wizard.
Users can post data by dragging
-
and
-
dropping files into a document library on a Web server, and tag the file
with metadata (such as ke
y
words) for searching.

The same technologies could also be deployed as a solut
ion for corporate pre
s
ence on
the Internet, such as a company investor information site, where content is updated on a
regular basis by a variety of people in the organization, but is provided externally to
customers.


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
12

12

Collaboration and Communic
a
tion

Users

need to be able to send e
-
mail reliably, securely, and quickly. The system must
provide for fast response times, the ability to send attachments and sign and encrypt
messages, provide for rules, multiple formats and styles (rich text, HTML, etc.), and
org
anize the flood of information arriving by e
-
mail. General infr
a
structure requirements
include reliability, high
-
performance, security, scalability, and interoperability with

and
migration from

existing messaging systems.

Organizations also look for collab
orative capabilities that are not necessarily tied to
messaging, growing across a spectrum of requirements:



Individual productivity:

calendar, contacts, one
-
to
-
one information
sharing.



Team productivity:

group scheduling, shared task lists, shared contacts
,
public folders.



Departmental productivity:

discussion groups, real
-
time
-
collaboration,
custom forms.



Enterprise productivity:

routing applications, workflow, document
ma
n
agement.

These features can be further extended to Web
-
based scenarios that include
structured
data and transacted applications, by using Collaboration Data Objects (CDO), Active
Data Objects (ADO), and Microsoft Transaction Server (MTS) with Microsoft Message
Queue Server (MSMQ), Windows

NT Server’s technologies.

For example, a collabora
tion solution for project management:



Allows a company to r
e
act to changing business conditions.



Makes users more productive with near
-
instant access to information.



Manages information by providing structure to data.



Allows all members of an organization
at all levels to communicate in real
-
time or asynchronously.



Allows all users of an organization to add value through real
-
time
collaboration on business initiatives.



Allows individuals within an organization to make informed decisions by
sharing and colla
borating on analysis and i
n
formation.



Provides universal tools and IT infrastructure tools for maintenance.

Office

2000 with the Microsoft Outlook® 2000 messaging and collaboration client offers
many new features and benefits to E
x
change Server customers.
Advances in setup and
installation technology across Office

2000 lowers deployment and support costs for
administrators. In addition, Outlook 2000 provides many messaging, scheduling, and
contact management e
n
hancements for increased productivity. Business

managers who
use Exchange and Office together gain more effective ways to foster collaboration
across virtual teams and interact with customers, increasing return on investment.
Corporate developers and Microsoft business partners are able to capitalize o
n more
powerful object models and tools for building co
l
laborative and workflow applications.


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
13

13

Office

2000 makes it easier than ever for corporate developers and solution pr
o
viders to
combine Office and Exchange (as well as other Microsoft BackOffice a
p
pli
cations) in the
same application, delivering powerful solutions for workflow, tracking, routing, and
customer interaction. A common
add
-
in

architecture across all Office applications
simplifies deployment of custom solutions. The Outlook 2000 programming m
odel has
been significantly expanded, enabling greater control of the application user interface
and event
-
driven scripting. Finally, the Outlook 2000 Application Design Wizard,
shipping as an Office add
-
in shortly after Outlook 2000 ships, dramatically si
mplifies the
process of creating Exchange Server collaborative applications.

The combination of Office

2000 and BackOffice offer a rich set of features for
collaboration, including:



Routing Objects and the Exchange Scripting Agent.

Application
developers
can build custom workflow solutions to automate business
tasks, create more effective teams, and make better use of the knowledge
available throughout an enterprise. Exchange Server and Outlook provide a
comprehensive set of tools for building workflow app
lications, including the
Exchange Scripting Agent and Routing Objects and the Outlook drag
-
and
-
drop tools, with full support for Vi
s
ual Basic Scripting for creating electronic
forms
.



Outlook 2000 Team Folder Application Wizard.

The Application Design
Wi
z
ar
d is an extensible COM add
-
in for Outlook that provides a simple user
inte
r
face and set of templates that make it easy for all application
designers, from power users to developers, to create customized
collaborative applications. The Application Design Wi
zard requires no
programming to create applications for discussion groups, issue tracking,
calendar sharing, and contact and task tracking.



Advanced e
-
mail services.
Users of Exchange Server and Outlook can
co
m
municate easily with advanced e
-
mail features
such as server
-
side e
-
mail rules and out
-
of
-
office handling, message tracking, deferred message
delivery, automatic message expiration, a global address book of recip
i
ents
and more.



Group scheduling.
Users of Outlook can efficiently schedule meetings
when
people and resources are available. Over the Internet, using the
iCalendar Internet standard, an Outlook user can view when other users
are free or busy and schedule meetings accordingly. Also, by setting
appropriate permissions, a user can view the detail
s of another user’s
calendar and delegate access or management to others.



Offline support
. Powerful synchronization with Exchange Server allows
Ou
t
look users full access to their e
-
mail, calendar, contacts, tasks and
corporate application information while

working offline. Changes are
automatically sy
n
chronized between their PC and Exchange Server when
back o
n
line.



Folder home pages.

Outlook 2000 allows developers to combine the
power and flexibility of Web pages with Outlook views and offline usage
support

of E
x
change Server Public Folder applications. This provides users
with a graphical way to organize their Outlook information with links to
related content, branding, user instructions, frequently asked questions,
policies for the applic
a
tion, etc.


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
14

14



Docume
nt
-
based discussions.

Multiple users can add comments to an
Office

2000 document residing on a Web server with Office Server
Extensions, sha
r
ing ideas and work. Users can also subscribe to a
document for automatic not
i
fication of content changes, and searc
h the
Web site for information based on the OLE properties of documents.



Threaded discussions.

Users can participate in discussions hosted in an
E
x
change Server public folder and access them via Outlook 2000 or
through a Web browser via Outlook Web A
c
cess.



Real
-
time collaboration.

Exchange Server and Outlook features such as
group tasks lists and schedules, global directories, public folders, complete
chat services, channel transcription, the NetShow™ server and NetMeeting
conferencing software features for online meetings, and mor
e let users call
on people and resources to get a job done.



Browser
-
based e
-
mail, scheduling, contacts, and collaboration.

Outlook Web Access lets users send e
-
mail, set schedules, access
Exchange Public Folders and Outlook forms, and use their contacts
d
at
a
base from a Web
-
interface from across the Internet.



Broadcast presentations.

Internet and intranet users can participate in
Web
-
based broadcasts of PowerPoint presentations. Using the NetMeeting
conferencing software and the NetShow Windows streaming me
dia
services, they can even participate in whiteboard and collabor
a
tive
sessions online
.

For more information about building collaborative solutions using Exchange Server and
Outlook 2000, visit
http://www.mi
crosoft.com/exchange
.


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
15

15

Data Analysis

All organizations need to have access to timely and reliable data in order to make
decisions. Data center managers must think about collecting relevant data, storing it,
staging it for future use and making it availab
le for users to extract, manipulate, and
analyze. Business users and administrators look at exploiting this information via
analysis tools, datamarts, and data warehouses. Developers build workflow
-
type
applications (such as document routing), or informati
on management systems such as
Decision Support Systems (DSS).

Employees need to be able to obtain data easily for analysis using familiar tools.
Employees should not have to rely on the management information services (MIS)
department to create complex fr
ont ends to corporate databases. By using Office
applications, employees have full access to data and the tools to analyze industry
-
wide,
corporate and even departmental data. In addition, employees should be able to
communicate and collaborate on data ana
lysis, real
-
time, with other employees

either
from headquarters or remotely.

For example, a DSS for financial or sales analysis would:



Increase control, allowing u
s
ers to make faster and better decisions.



Allow anyone to examine company data.



Allow anyone
to analyze and make decisions based on co
m
pany data.



Allow users to interact with data

write data anytime, an
y
where.

Office and BackOffice provide the following rich data analysis capabilities:



Support for OLE DB, ADO (Active Data Objects).

Office

2000 imp
roves
su
p
port for connecting to back
-
end databases by using Microsoft
component
-
based middleware. OLE DB and ADO provide better
performance against SQL Server and other OLE DB providers, so
developers can easily create powerful applic
a
tions. Office

2000 al
so takes
a client/server approach to dealing with very

large databases, only
retrieving
the data the user wants to see instead of the entire data set.



Support for OLAP.

OLAP support in Office

2000 allows it to work
tightly
with SQL Server
-
based data marts
and data warehouses
.
Users can use a

Pivo
t
Table dynamic view in Microsoft Excel

for high
-
performance data
analysis
. This allows users to make complicated queries against large
amounts of data and across many dimensions (such as time and
geography), and get

answers quickly. OLAP services are provided in
Microsoft
OLAP server technology
(available as part of SQL Server 7.0).
For the first time, Excel users can an
a
lyze gigabytes and terabytes of data.



Office Web Components.
Any of the Microsoft Office Web Comp
onents

a
Spreadsheet component, a Chart component and a PivotTable
component

can be linked directly to SQL Server or OLAP data cubes. The
components provide an interactive view of data within a browser and will be
updated anytime a change is made to the li
nked data source. This
integration provides an easy way to distribute reports, as well as a simple
way for users to view and an
a
lyze the data they need.


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
16

16



Microsoft Data Environment as part of the Office Developer Edition
(ODE).

The Office

2000 Developer Edi
tion (ODE) will include the Microsoft
Data Env
i
ronment (DE), a user interface
-
based tool for connecting to SQL
Server and other OLE
-
DB compliant data sources. The ODE is the version
of Microsoft O
f
fice targeted at professional developers. The ODE is the
ea
sy way for develo
p
ers to access data programmatically and integrate it
with a custom Office
-
based solution.


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
17

17

Tracking and Workflow

As the Web becomes more pervasive in everyday productivity, database users have
recognized intranet technology as a unique a
nd fast way to gather, track, and share
information quickly. Organizations require workflow
-
type applications (such as document
routing), or an information management system such as sales force automation tools
(lead
-
tracking systems and expense reporting)

to support data trac
k
ing.

Historically, it has been challenging for anyone other than a database admini
s
trator or IT
professional to access data from an enterprise
-
level database. Increa
s
ingly,
corporations are using Office as the preferred front end for
data access and corporate
reporting systems, making it possible for end users to get more directly involved.

For example, a sales force automation or sales tracking tool allows the company sales
force to develop relationships with customers, and delivers a
ccess to the most up
-
to
-
date information possible. This solution:



Helps an organization remain competitive in the marke
t
place.



Allows an organization to
stay in touch

with its customers and suppliers.



Allows individuals within an organization to make infor
med decisions by
sharing and collaborating on analysis and i
n
formation.



Helps and organization to seamlessly improve user produ
c
tivity.



Allows users to manipulate data in an ad hoc or structured way.

Access 2000

in combination with SQL Server

makes it easy

for users to interact with
and manage data and the databases in which it resides. In addition to being a
standalone application for creating databases for individual or workgroup use, A
c
cess
2000 is an easy to use front
-
end to SQL Server, providing both a
n application
development environment and a database management tool. This lowers the bar for
creating true client/server applications by allowing end users to take advantage of the
ease
-
of
-
use of Access combined with the scalability and reliability of Mic
rosoft SQL
Server.

Access 2000 provides a Web
-
based paradigm for creating Access database s
o
lutions
that are hosted within the browser. This combines the power of sharing co
r
porate
information with the power of managing the data in a desktop environment. F
or example,
rather than soliciting ideas or input via e
-
mail and then transferring to a separate data
store for analysis, Access users can distribute a Web
-
based sol
u
tion for tracking and
gathering data that others can directly input into the database. Wit
h Access 2000, an
average Office user can easily create a database, distribute a data
-
entry HTML page
with a customized theme and look, save it to a group server, and quickly gather
feedback from others in the department. Recipients see a live view of the
data and can
easily browse, query or update the information as allowed.


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
18

18

Office and BackOffice provide the following features to simplify the creation of powerful
tracking applications:



One hundred percent SQL Server
compatibility.

Microsoft Access 2000
s
upports OLE DB, allowing users to combine the ease of use of the Access
i
n
terface with the scalability of back
-
end enterprise databases, such as
Microsoft SQL Server, without needing to go through the Jet d
a
tabase
.



Access pro
j
ects.

The Access interface ca
n create a new file type (.adp)
that connects directly to the integrated store available in Office, SQL Server
6.5, or SQL Server 7.0. This lowers the bar and makes it easier for Access
users to create true client/server applications



Client/server wizards
and design tools.
Many popular Access wizards
have been updated to support the new client/server tasks, such as creating
a new database, report or form. When users work in a Microsoft Access
Project (.adp), new design tools allow them to create and manage
server
-
side objects easily, including tables, views, stored procedures, and
database di
a
grams
.



Routing Objects and the Exchange Scripting Agent.

Application
developers can build custom workflow solutions to automate business
tasks, create more effective te
ams, and make better use of the knowledge
available throughout an enterprise. Exchange Server and Outlook provide a
comprehensive set of tools for building workflow applications, including the
Exchange Scripting Agent and Routing Objects, and the Outlook d
rag
-
and
-
drop tools, with full support for Vi
s
ual Basic Scripting for creating electronic
forms
.



Data Access Pages.

Data Access Pages are interactive, dynamically
linked HTML pages that let users analyze and manipulate data from within
a Web browser. Data c
an be included within the context of the page, or
linked from a SQL Server database. Pages can be stored on a Web server
or file system, in Exchange Public Folders, or included as e
-
mail
attachments for easy access, which also allows for disco
n
nected and o
ff
-
line use.


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
19

19

Most businesses need specialized applications to help them perform specific fun
c
tions,
including horizontal applications such as accounting and vertical applications such as
manufacturing control systems.

To func
tion well as part of a Digital System, business specific applic
a
tions need to make
use of five building blocks: a PC computing architecture, all i
n
formation in a digital form,
universal e
-
mail, ubiquitous connectivity, and common end
-
user productivity tool
s. Doing
so makes the information in these applications easy to dive into, organize, and share.

Web
-
based Applications

Businesses are increasingly using the Windows

NT operating system for applic
a
tions
that are developed specifically for a business need, a
nd are critical to the day
-
to
-
day
operations of the company. The applications must be scalable, reliable, and secure,
while maintaining data integrity, communicating over unreliable networks, and
int
e
grating with a variety of back
-
end data sources and lega
cy enviro
n
ments and
applications.

Many companies currently use proprietary front ends and a legacy 2
-
tier cl
i
ent/server
architecture. To take advantage of the capabilities of the new technology, they need to
consider moving to a system with client indepen
dence (and a variety of front ends, such
as Web
-
based or Windows 32
-
bit API
-
based). In order to support applications and data
sources of varying sizes, they will also need to consider uti
l
izing a 3
-
tier COM
-
based
application architecture. Using today's Win
dows

NT tran
s
action and message queuing
features with Web
-
based applications, developers can deliver scalable and reliable
systems for online transaction processing (OLTP), f
i
nancial systems, and other mi
s
sion
-
critical tasks.



Mission
-
critical applications
must be reliable, scalable, interoperable,
available, and manageable.



The developer must consider:



Distributed Web
-
applications.



A 3
-
tier component application model.



Integration with independent software vendor (ISV) tools.



A reliable, easy to use front e
nd.

For example, users could access a mission critical financial application via a Web
-
browser, access related data with Excel 2000 and Access 2000, and tie into existing
enterprise resource planning (ERP) tools such as SAP via OLE DB.

To enable such a sol
ution, many Office

2000 and BackOffice technologies come into
play, including Internet Information Services, Microsoft Transaction Server, M
i
crosoft
Message Queue Server, Certificate Server, SQL Server, SNA Server, Proxy Server,
Access 2000, Excel 2000, th
e Visual Studio development system, and the Office Web
Components. Key features for Web
-
based applications carry over from data analysis
and tracking and workflow solutions, but add components for reliability, scalability, and
interoperability.

OPERATIONS OR LINE
OF BUSINESS


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
20

20

Te
chnology is becoming a true competitive advantage as electronic commerce b
e
comes
more prevalent. Businesses need to be able to sell products and services effectively and
easily via the Internet, both for customer
-
to
-
business and business
-
to
-
business
transa
ctions. The system must be reliable, scalable, high
-
performance, and very secure.

Such a system allows a company to build, engage, transact, and analyze co
n
tent on the
Web:



Business
-
to
-
customer transactions

selling directly to customers in a
persona
l
ized w
ay.



Secure, reliable, high
-
performance transactions.



Fast, effective deployment.



Dynamic merchandising, easy updates to content, pricing, real
-
time
prom
o
tions.



Flexible order processing, flexible payment methods.



On
-
line subscriptions
--
scalable membership

management.



Extranets: supplier sites with secure logon and custom catalogs; business
-
to
-
bus
i
ness transactions.



Integration with existing legacy systems, data, and applic
a
tions.



Application
-
to
-
application data interchange in multiple fo
r
mats.



Worldwide im
pact via euro support, single
-
executable for Office

2000.



Cut and paste HTML pages (such as formatted reports) into and out of
Excel and Word, while retaining formatting el
e
ments.

Building this kind of solution on BackOffice, particularly with Site Server
3.0, Commerce
Edition, SQL Server, Microsoft Transaction Server, SNA Server 4.0, and Office

2000
enables a broad range of capabilities for secure and reliable transa
c
tions, data anal
y
sis,
and many of the features listed in the solutions detailed above.

COMMERCE


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
21

21

Knowledge management, business operations, and commerce solutions require a
comprehensive infrastructure of management, deployment, interoperability, and
application development services. Office

2000 and the BackOffice family provide an
inte
grated platform for building, managing, and deploying these applications.

Infrastructure can be broken down into several key functional areas, and Table 4
highlights the key points of integration for each:

Table 4: Infrastructure

Infrastructure

Requiremen
t

Office

2000

BackOffice

Point of
Integr
a
tion

Management

Software
Installation

All Components

Systems
Ma
n
agement
Server

Windows Installer

Application
Maint
e
nance

All Components

Windows

2000
Professional

IntelliMirror


management
technol
o
gies

Deployme
nt

Using the legacy
PC install
-
base

All Components

Windows

NT
Server 4.0,
Term
i
nal Server
Edition

N/A

Software
Distribution

All Components

Systems
Ma
n
agement
Server

PDFs included
with Office

2000

Enterprise Integration and Interoperability

Host Integr
ation
(data, applic
a
tions)

Access, E
x
cel

SNA Server, SQL
Server

OLE
-
DB, SNA
protocols

Legacy Transaction
System Int
e
gration

Microsoft Internet
Explorer

SNA Server, SQL
Server, MTS

COMTI

NetWare and Unix
Interoperability

(Client Services
for NetWare)

Wind
ows

NT
Server

TCP/IP, IPX/SPX

Secure, High
-
performance
Inte
r
net and
intranet a
c
cess

Microsoft Internet
Explorer

Proxy Server

N/A

I
NFRASTRUCTURE


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
22

22


Development

Web
-
based and
Wi
n
dows 32
-
bit
based applic
a
tions

Office Web
Components,
Visual Basic for
Applications
(VBA)

Vis
ual Studio
d
e
velopment
system,
Windows

NT
Server (IIS, MTS,
MSMQ)

Visual Basic for
Applications,
COM, Windows
DNA

Web site usage
and integrity
anal
y
sis

Excel

Site Server, SQL
Server

ODBC

OTE
The following section covers examples of each of the above requ
irements, but more details can
be found in
Appendix A: Benefits of an Integrated Server Platform
.


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
23

23

Management

System and network administrators need comprehensive and easy to use tools for
ma
n
aging the enterprise. Any enterprise is built from many componen
ts, such as:



Hardware:

both server and workstations.



Software:

including client/server front ends and server a
p
plications.



Users:

who require extensive account management.

Different corporate operations have different responsibilities, for example:



Operati
ons IT

(Desktop, Network, Applications, Data Center Managers)
--
deploying and maintaining systems.



Service Management

(CIO or IT Manager, Support staff)
--
fix downed
systems based on whichever is most important or has the greatest impact
(help desk).



Busines
s Management

(Business development manager)
--
evaluates
costs and makes decisions (capacity planning, upgrades).

Managers in these organizations all have concerns about the total cost of owne
r
ship
(TCO) and long
-
term management. Some of the most important i
ssues are initial
purchase price, speed and ease of development, upgrade rate, reliability, performance,
availability, resource requirements, and change co
n
trol.

Total cost of ownership can be reduced with centralized administration, demand
-

and
scenario
-
b
ased setup, migration tools, flexible deployment methods, and co
-
existence
strategies and tools, which:



Reduce management costs for migration and deployment.



Step towards a
Touchless

client.



Allow the company to capitalize on existing hardware and software
,
network infrastru
c
ture, and so on.



Decrease help desk support calls.

For example, with Office

2000 and BackOffice, an IT executive will find that the process
of rolling out new software to an organization can be managed better than before.

With a managem
ent strategy that includes Systems Management Server and the
dynamic deployment features of Office

2000 (enabled with Windows

2000 Profe
s
sional),
IT managers can significantly ease administration tasks and reduce assoc
i
ated costs.

Systems Management Server

2.0 delivers:



Ability to handle distributed environments

(WAN, slow
-
link
connections). Systems Management Server allows IT managers to tailor
how they distribute software and manage clients by supporting rules for
network bandwidth co
n
sumption, multiple c
onnection methods, and remote
installation via removable media (CD, tape). This means that users in
branch offices or other remote loc
a
tions can still receive Office

2000 in a
simple and timely manner.



Push
-
model software distribution, scheduling, conditio
nal
distribution, unattended, status checks.
In LAN
-

and WAN
-
based

Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
24

24

environments, distrib
u
tion of Office

2000 can be tightly controlled, and
company
-
wide policies for desktop configurations can be enforced by
pushing software to the desktops, rather than le
tting users choose what to
i
n
stall.



Cost
-
effective desktop management; troubleshooting and help desk
fun
c
tions.
Systems Management Server provides tools for making sure
that any user’s desktop software issues are dealt with quickly and easily,
including r
e
mote control, chat, and remote execute functions.



Software metering for deployment planning.
Systems Management
Server 2.0 adds features for metering software use, so that IT planners can
track and report how software is used, or control access to new tool
s.



Comprehensive software and hardware inventory.

Systems
Management Server 2.0 collects detailed information about each server
and workstation to help identify machines with out
-
of
-
date software or
insufficient hardware. This information can be used to he
lp plan Office

2000
deployments and upgrades, and ensures that target systems meet
minimum hardware and software r
e
quirements.

In addition, Site Server provides tools to maintain the integrity of a Web site:



Site Server Content Analyzer.

Allows administrat
ors to visually map any
Web site to conduct a wide range of searches (for broken links, etc.) and
generate content and usage reports.

With the release of Windows

2000 Professional, managing Office and BackOffice
applications will achieve a new level of eas
e of use and integration, further reducing
TCO in an enterprise environment. Some new features will include:



Microsoft IntelliMirror
™ Management Technologies.

IntelliMirror is a
collection of fe
a
tures that benefit both network administrators and individual
users. When Office

2000 is set to
run from source
, Windows

2000
Professional caches Office files as Office is used, which improves
performance and makes Office easier to maintain.
(Requires both
Windows

2000 Professional and Windows

2000 Server).



Full Support

for Roaming Users.

Windows

2000 Professional stores
personal settings and profile information in the registry by user instead o
f
by machine. This allows an Office

2000 user to roam to a different machine
on the network and still see their customized interface and settings.
(Requires Windows

2000 Professional only

also works on Windows 95,
Windows 98, and Windows

NT 4.0 with the Mi
crosoft Internet Explorer
Web
-
Aware User Interface i
n
stalled).



Enables roaming profiles.
Through the Roaming User Profiles wizard,
Windows

2000 simplifies the creation of user profiles that can be used at
any Windows

2000 Professional.


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
25

25

Deployment

IT mana
gers who build solutions on the Microsoft platform can take advantage of
numerous technologies that make the process of deploying infrastructure and cu
s
tom
intranet applications in the enterprise easy and cost effective. These include software
distribution

via Systems Management Server, delivering a Windows

NT and Office

2000
desktop environment to legacy PCs via Windows

NT Server 4.0, Terminal Server
Edition, and Web site d
e
ployment via Site Server.

Deploying applications in an enterprise can be a time con
suming and costly a
f
fair. But
by using Systems Management Server to deploy and manage Office

2000 on the
desktop (in addition to using built
-
in Office

2000 tools for publishing and i
n
stalling
components), organizations can significantly reduce the time and

money involved. One
study indicated that this could be by as much as $1200 per PC, per year.
1

Customers who choose to use the BackOffice Server suite will be able to take
advantage of unique tools for deploying and managing intranet servers and applic
a
tio
ns,
including integrated scenario
-
based setup, Web
-
based administration, and a simple,
cost effe
c
tive licensing model for servers and clients.



On
-
demand installation.
Users only have to load those components they
use, and if an assignment calls for an Offi
ce

2000 function they don’t
currently have installed, it can be automatically loaded from a network or
other installation source.



Legacy desktop access and terminal deployments.

IT managers don’t
have to face simultaneously upgrading thousands of older 803
86
-

to 80486
-
based PCs to run new software. By using Terminal Server, full Windows

NT
Workstation and Office

2000 functionality can be delivered to these
desktops with no change to existing infrastructure, and only the addition of
Windows

NT
-
based Servers
to host user sessions.

When the hardware
refresh cycle finally comes up for those older PCs, managers can distribute
Office

2000 to new desktops with Systems Management Server.



Pre
-
defined Package Definition Files (PDF) for Office

2000.

System
admi
n
istrato
rs won’t need to manually create these
software distribution
rules

files, because they will be included with Office

2000.



Targeted per
-
user and per
-
PC software distribution based on
hardware, network, OS, user attributes and group memberships, or
other req
uirements.

Systems Management Server 2.0 provides a wide
range of criteria upon which software can be distributed, so that users
within departments or functional a
r
eas can be selected for upgrade based
on need, job requirements,
user and group attributes,
or inventoried system
characteristics (hardware configuration, sof
t
ware configuration
).



Managed software distribution.
Systems Management Server provides
push
-
model and conditional software distribution, and comprehensive
scheduling. Administrators can set

up unattended installs and do status
checks to make sure an Office

2000 deployment is proceeding as planned,



1

Northeast Consulting Resources, Inc., “Investing in Desktop Management Productivity”, 1997,
http://www.microsoft.com/smsmgmt/guide/roi.asp



Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
26

26

and roll it back if it fails. (In a Windows

2000 Professional environment,
rollback is automatic using the Windows I
n
staller service.)



Site Server
.

Site Server allows customers to safely and reliably replicate
data across the Internet. End users can easily post content to a staging
server over standard protocols, such as Hypertext Transfer Protocol
(HTTP) Post Request for Comments (RFC 1867), by usi
ng the Web
Publishing Wizard. The Posting Acceptor feature accepts these posts and
the Content Replication System fe
a
ture allows sophisticated and reliable
replication between staging and destin
a
tion servers.

Microsoft Windows

2000 Professional supports ad
ditional features in Office

2000 for:



Assign and Publish.

The Windows Installer service provided in
Windows

2000 Professional allows an application to be
Assigned

to a user
or computer (so that it can be installed on demand), or
Published
to a user.
When a
n application is
Assigned
, the application is advertised on the
computer in the form of a shortcut that will install the application the first
time it is used. When an application is
Published
, it will be displayed in the
new Windows

2000 Professional
Add/
Remove Programs

control panel.
Office

2000 applications can be either
Assigned

or
Published
.
(Requires
both Windows

2000 Professional and Wi
n
dows

2000 Server).



OLE
-
Level Advertising.
Using the Windows Installer service provided by
Wi
n
dows

2000 Professional
, Office

2000 will automatically install an
application if needed to activate an OLE object. For example, if a user
clicks on an Excel chart (OLE object) embedded within a Microsoft Word
document and the user doesn’t have Excel installed, the Windows Insta
ller
service will install it on the fly.
(Requires Windows

2000 Professional).


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
27

27

Enterprise Integration and Interoperability

One of the most important features that BackOffice provides Office desktop users is
access to data, applications, and services resid
ing on heterogeneous legacy sy
s
tems in
the enterprise, such as AS/400s, MVS mainframes, UNIX hosts, and Ne
t
Ware servers.

Windows

NT Server, SNA Server, Exchange Server, SQL Server, and Proxy Server
deliver capabilities for:

Note
More details are provided
in Appendix A: Ben
e
fits of an Integrated Server Platform.



Directory integration.

Windows

NT Server and Exchange Server support
int
e
gr
a
tion with NetWare NDS, Lightweight Directory Access Protocol
(LDAP)
-
based, and Kerberos realms.



NetWare integration.

Windo
ws

NT Server offers several tools for
interopera
t
ing with, or migrating from, NetWare environments.



UNIX integration.

Windows

NT Server offers support for common
networking, file system, and printer services, allowing Office users to
access resources in a
Unix enviro
n
ment.



Macintosh integration.

Services for the Macintosh allow Windows

NT
Server to provide a powerful integrating platform for mixed PC and
Macintosh ne
t
works.



E
-
mail integration.

Through broad messaging standards support and tools
for interope
rability and coexistence, Office

2000 users can connect to, use,
or migrate from exis
t
ing enterprise messaging platforms.



Database integration.

Office

2000 users can access a wide range of
existing data sources via SQL Server replication, direct connectivi
ty, and
application services, tying desktop users into the enterprise data
env
i
ronment.



Legacy host integration.

Through Microsoft SNA Server, Office

2000
users can access mainframe
-

and AS/400
-
based data and application
services, such as DB2 databases, tr
ansactional applications, printer
resources, and files, with integration with the legacy security environment.


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
28

28

Application Development

The Microsoft platform delivers comprehensive services for building Digital System
solutions, designed to make it easy f
or developers to bring products to ma
r
ket quickly

either internally or externally. In addition to the broad range of comm
u
nication,
application, and infrastructure services that comprise the platform, there is a variety of
tools and features such as starte
r applications and Web sites, included components
(Microsoft ActiveX


controls, for example), and wizards aimed at streamlining the
development process. Since developers can use almost any programming language
with the Microsoft platform, they are not tied

to a specific tool, allowing them to work in
the environment with which they are familiar.



Microsoft Visual Basic for Applications 6.0.
The latest version of the
most widely used development environment is included with Office

2000.
Visual B
a
sic for Appli
cations 6.0 is on a par with the latest version of Visual
Studio deve
l
opment system, allowing developers to include Visual Basic
code and ActiveX controls in their custom applications and forms. This
makes it easy for develo
p
ers and desktop users alike to
create custom
solutions on Office

2000, and link them to BackOffice and existing legacy
sy
s
tems.

Further enhancements are possible when Office

2000 is used with Web
-
based intranet
applications on BackOffice, simplifying application deployment scenarios, ea
sing
d
e
velopment requirements, and quickening time to market.



By using new specialized ActiveX controls

the Office Web Components

Web developers can build applications that capitalize on the power of the
Office suite, and provide functionality such as spre
adsheets, charts, and
PivotTable or Microsoft PivotChart
™ dynamic views in a Web browser,
without installing Office on the desktop. (Note, however, that an Office

2000
software license is still required for that desktop.) This enables a cross
-
platform solution by providing Office functionality to a wide range o
f clients.

Office also integrates with the universal data access model in BackOffice, allo
w
ing
desktop users to interact seamlessly with all varieties of data residing in multiple back
-
end data stores such as databases, file systems, e
-
mail stores, and Web

servers

including those residing in other environments such as Oracle and AS/400.



Developers can work with a single object library (Active Data Objects and
Collaboration Data Objects) for creating Web
-
based applications, instead of
learning numerous low
-
level protocols and application programming
interface (API) sets. At the same time, transaction and data services are
managed by the server applic
a
tions.


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
29

29

Customers using Office

2000 in branch office, departmen
tal, and intranet settings can
benefit by deploying BackOffice family components using the BackOffice Server suite
and BackOffice Client Access License. These products provide integrated setup,
administration, and intranet starter applications, and a singl
e license for client and
server, making it faster and more cost effective to deploy server sol
u
tions.

Deployment Scenarios

Microsoft BackOffice Server 4.0 will be used by businesses of all sizes for a variety of
infrastructure and application scenarios. S
ome common scenarios for using BackOffice
Server 4.0 and BackOffice family applications, with Office

2000 and M
i
crosoft Internet
Explorer as the users’ primary vehicles for interacting with data, are:

Branch Office

BackOffice Server is ideal as a complete
branch office applic
a
tion and communications
server. You can use Windows

NT Server to provide local networking and wide
-
area
network connectivity, and Sy
s
tems Management Server to inventory and manage local
desktop hardware and software. In addition, Excha
nge Server allows you to share local
messages and collaborative applications, Proxy Server provides secure, high
-
performance Internet access for your branch office, and SNA Server provides access to
AS/400 or mai
n
frame resources on your WAN. BackOffice Ser
ver reliably replicates user
account information, desktop inventories and messages back to your corp
o
rate data
center.

Departmental

BackOffice Server lets you standardize on a single application platform that a business
can deploy at the workgroup, branch,

department or corporate level. Windows

NT
Server provides all the essential ser
v
ices needed to deploy networked, mission
-
critical
business applications. Microsoft SQL Server provides users with advanced database
services and interoperability with database
s from Oracle, Sybase and others. SNA
Server provides easy access to mainframe and AS/400 databases, VSAM files and
CICS applications. Exchange Server adds routing, notification and workflow
-
type
capabil
i
ties.

Corporate vs. Workgroup

Today, corporate intra
nets are becoming more prevalent but are often nothing more than
a place to dump files

and this place happens to be a Web server, perhaps even
residing in a small workgroup. Companies can change this paradigm so that Web
servers b
e
come interactive and empl
oyees value them as places to share information
and collaborate with others. Using Microsoft Internet Information Services (IIS)

the
Web application services integrated with Windows

NT Server

is a great way to
facilitate this workstyle change, allowing use
rs to benefit from the rich services provided
by a Web server.

OFFICE AND
BACKOFFICE SERVER IN

THE ENTERPRISE


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
30

30



Universal Viewing.

In a Web
-
based environment, information and files are
easily accessible to
any user on any pla
t
form
via their browser.



Web Workspace.

IIS enables workgroups to have one comm
on place (on
a Web server) as their
workspace

for sharing information, managing files
and organizing projects. This workspace becomes the central place for
collaboration within teams. Today, users often have trouble locating
information that might be store
d on network servers, personal hard drives,
or various other locations. Having one central place to post and find
information will alleviate this problem.



Indexing Services.

Indexing Services allow users to query indexes and
entire documents on Internet or

intranet sites that are stored on Microsoft
Internet Information Services. The search engine has a unique ability to find
documents in just about any format: text in a Word document, statistics on
an Excel spreadsheet, or the content of an HTML page.
Usin
g a browser,
users are pr
e
sented with an intuitive interface for navigating and finding
specific information or files.

In the corporate data center, BackOffice provides the infrastructure through which users
can access a wide range of legacy data and appli
cations services, and at the same time
provide scalable and reliable database, e
-
mail, systems manag
e
ment, Internet access,
and other services.

In addition, Office

2000 can be deployed to corporate users in a variety of ways:



By direct installation on cli
ent PCs.



Users can gain Office

2000 functionality through Web
-
based applications.



Legacy desktops (such as older PCs not capable of running Windows 95 or
later operating systems) can be fully utilized by deploying
Windows

NT

and
O
f
fice environments via
Win
dows

NT

Server 4.0, Terminal Server Edition
(which also enables remote access to such applications ser
v
ices).

In the enterprise, Office

2000 desktops can gain access to data and applications
residing anywhere in the organization, whether on
Windows

NT
-
base
d servers,
companion workstations, or legacy and heter
o
geneous systems.


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
31

31

Figure 3: Office and BackOffice in the Enterprise


Office 2000 enables desktop users to easily access and interact with data across the
enterprise, including Web servers, BackOffice f
amily application servers in the data
center, BackOffice intranet application servers, and legacy systems.


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
32

32

Integration also lies at the core of the design philosophy for the BackOffice family of
applic
ations and BackOffice Server, so that the platform delivers many benefits to a wide
audience. Microsoft’s family of server products is fully integrated with
Windows

NT

Server, with each other, with heterogeneous legacy systems, and with the Inte
r
net. IT
Ma
nagers and Administrators can take advantage of centralized administr
a
tion, using
consistent tools to manage applications and resources. Users are more productive with
seamless access to information via Windows
-
based and Web
-
based applications, all
with a
single network
-
logon. And, solution developers benefit from an integrated
application development framework, allowing them to focus on deli
v
ering business
solutions, instead of designing an application infr
a
structure.

This integration also enables other ke
y benefits in a Digital System: r
e
duced Total Cost
of Ownership (TCO), enhanced interoperability in the enterprise, and simplified
ma
n
agement.

Reducing TCO

Reducing a solution’s Total Cost of Ownership is important to every IT manager.
Microsoft helps mak
e this a reality by delivering a unified a
p
plications and services
platform that is easier to learn and use, and easier to deploy and manage. It is also
easier and faster to develop applications on this platform, resulting in higher user
productivity, fast
er time to market, and lower management costs.

Unified Environment

To deliver effective business solutions, a Digital System needs a unified platform with a
single s
e
curity model, single network infrastructure, single data access model, and
single applicat
ion development framework. The end result is that the platform is easier to
use, manage, and develop applications on, which of course has a positive impact on
cost of owne
r
ship.

The single security model that all applications and services leverage provides

users with
a common entry point (a single logon) for all network access. This way, desktop users
don’t have to maintain multiple accounts, passwords, and profiles for different enterprise
systems or applications. In addition, Web security and integrity ca
n be maintained by
enforcing permissions for files and directories on the wor
k
group or enterprise Web
server(s). This also makes it easier for a
d
ministrators to:



Manage user rights and policies.



Assign security to o
b
jects, data, and applications.



Enforce c
ompany
-
wide security policies, with complete auditing and
tracking.



Protect information investments through digital certificates, signatures, and
encryption.



Provide secure Internet access via Secure Sockets Layer (SSL), Point
-
to
-
Point Tunneling Protocol (
PPTP), and virtual private networks (VPNs) using
Proxy Server.


APPENDIX A: BENEFITS

OF AN INTEGRATED
SERVER PLATFORM


Microsoft BackOffice Server 4.5 and Office

2000

White Paper

Page
33

33

This all happens in a comprehensive and consistent manner across server, host, and
desktop environments. In addition, BackOffice provides Office desktops with services for