A
access control lists (ACLs), 47
action, as a measurable objective, 256
activation, BizTalk orchestrations vs. WF workflows, 201
activities, 119
BAMActivity element and, 169
composite, 198
creating, 40, 51–56, 89, 92, 94
debugging projects and, 68
listing deployed, 115
removing, 115
searching for via Activity Search page (BAM Portal), 138, 144
updating, 115
views and, 150
workflows and, 198
activity events, 206
activity fields, 101
activity ID nodes, 119
Activity Search page (BAM Portal), 138, 144
WCF/BizTalk integration and, 164
WCF/WF and, 160
AddReference() method, 168
AddRelatedActivity() method, 237, 328
Administration Console
Health and Activity Tracking data and, 14
BizTalk orchestrations vs. WF workflows, 205
aggregation management commands, 308
Aggregations page (BAM Portal), 139, 145
aggregations. See data aggregations
alert commands, 308
Alert Management page, 140, 146
cleaning up chronicle table and, 305
creating from queries, 138, 144
purchase processes and, 78
SQL Server Notification Services for, 28
Analysis Services for BAM Aggregations, 28
app.config file
creating, 46
editing, 217
archive management commands, 308
asynchronous data capture, 7
auction sites, C2C business model and, 74
AWO Corp. (sample application), 90–94, 120–133
BAM/SSAS integration and, 262
COO view for, 110
installing, 120
managing alerts and, 141
manufacturing scheduler view for, 104
marketing cube for, 142
marketing specialist view for, 106
using BAM and WF as complements, 217–232
B
B2B (business-to-business model), 71
B2C (business-to-consumer business model), 72
backing up databases, 305
Backup BizTalk Server job, 305
BAM (Business Activity Monitoring), 3–21
benefits of, 6
BizTalk vs. WF debate and, 200–205
designing/optimizing your own architecture for, 28–36
licensing and, 35
multiple implementations of, 147
new features and, 14
past/future evolution of, 336–344
posters illustrating concepts of, 24
structure of software components for, 24–28
where it fits in your business, 71–81
BAM Add-In for Excel, 24, 40, 67
BAM API exercise and, 237
creating activities via, 89, 92
regenerating live data workbooks via, 313
viewing aggregations via, 147
BAM Alerts Application database, 294
BAM Alerts Main database, 294
BAM Analysis database, 142, 149, 151, 293
BAM Eventing and, 26
loading WCF interceptor via, 191
reasons for using, 235
relationships and, 289
BAM Archive database, 149, 294, 299
BAM Client, installing, 24
“BAM deployment failed” error message, 67
BAM Event Bus Service, 295, 297, 311
BAM Eventing, 26
BAM Excel client, 20
BAM infrastructure, BAM stack and, 259
BAM Management utility (bm.exe), 24, 42, 85
activities and, 114
changing BAM runtime settings via, 314
commands implemented by, 301, 306–309
DTS packages and, 261
live data workbooks and, 147
tracing behavior of, 309
views and, 114
BAM Management Web Service, 251
BAM Portal, 20, 43, 138–147, 328
BAM stack and, 259
customizing appearance of, 146
Home page and, 147
installing, 24
Instruction page, adding to, 147
using, 64
BAM Primary Import database, 20, 66, 149, 293
BAM Portal and, 138
encrypting traffic and, 315
reading data from, 151
TPE and, 135
BAM Query Service, 252
BAM solutions, setting up, 85–88
BAM Star Schema database, 149, 293
BAM Web Services (BizTalk Server 2006), 27
BamTrackingChannel mechanism, 206
BamTrackingService, 206
BeginActivity() method, 168, 237, 240
benchmark, as a measurable objective, 256
BizTalk Administration Console, 13
BizTalk applications, 18
BizTalk Management database, 293, 305
BizTalk Management Pack for System Center Operations Manager (SCOM), 317
BizTalk Message Box database, 149, 293, 305
BizTalk Orchestration. See orchestrations
BizTalk Primary Import database, backing up, 305
backing up, 305
BAM and. See BAM
customer base and, 7
history of, 7
installation/configuration guides for, 23
integration with WCF and, 164–166
licensing and, 35
posters illustrating concepts of, 24
status monitoring, for, 317–332
systems integration and, 7
tracking profiles and, 117–136
virtualization guide for, 35
BizTalk Server 2009 Administration Console, 316
BizTalk Tracking database, backing up, 305
BizTalkServerApplication (BizTalk default host), 295
bm.exe. See BAM Management utility
BPM. See business process management
BPMS (business process management systems), 78
.btt file extension, 117
bttdeploy tool, 117
applying tracking profiles with, 133
removing tracking profiles with, 132, 135
buffered event streams, 7
BufferedEventStream class, 236, 239
Business Activity Monitoring. See BAM
business analyst role, 40, 117
Business Data Catalog (SharePoint service), 274
business event nodes, 120
business intelligence (BI), 255–277, 338
limitations of BI systems and, 5
business milestones, data capture and, 89
business models, 71
business process management (BPM), 3, 78, 337
business process management systems (BPMS), 78
business processes
BAM implementation and, 89
BizTalk monitoring and, 332
continuations and, 92
creating, 94
alerts and, 141
BizTalk orchestrations vs. WF workflows, 203
BRE tool and, 12, 78, 141, 203
business-to-business model (B2B business model), 71
business-to-consumer business model (B2C model), 72
C
C2C business model (consumer-to-consumer business model), 74
Center of Excellence (COE), 333–336
CEP (complex event processing), 260, 342
Chart View (Aggregation page, BAM Portal), 140
Clear() method, 237
clients
for BAM data, 20
COE (Center of Excellence), 333–336
Commerce Server, 276
CommonInterceptorConfiguration schema, 167
CompensatableSequenceActivity, 199
compensation, orchestration and, 10
complex event processing (CEP), 260, 342
composite activities, 198
composite applications, 79
CompositeActivity class, 198
Configuration element, of app.config file, 217
consumer-to-consumer business model (C2C model), 74
context property schemas, 118
continuation ID nodes, 120
COO view (AWO Corp. sample application), 110
Corporate Performance Management (CPM), 273
correlation, orchestration and, 10
CPM (Corporate Performance Management), 273
CPM tools, 5
create-index command, 146
credit card processing service, IC file examples and, 184–187
Crystal Reports, 259
cubes, 262
D
dashboards, 275
data
examining via Aggregations page, 145
providing additional data to users, 155
data aggregations and, 40, 139, 145
providing additional data to users and, 155
viewing via BAM Add-In for Excel, 147
asynchronous, 7
for AWO Corp. sample application, 286
data consumer role, 42
data dimensions, 102
data expressions, 174
data extraction/data manipulation, WF operations and, 216
categories of, 295
data items, capturing, 124–132
Data Transformation Services (DTS), 261
database category of BAM software, 27
backing up, 305
BAM Primary Import. See BAM Primary Import database
commands for, 306
data flows between, 294
message box, 8
OLAP, 262
date and time, business milestones data capture and, 89
debugging projects, WCF services monitoring project and, 67–69
decimals, data capture and, 89
default view, 40
DefaultWorkflowSchedulerService, 200
dehydrated orchestrations, 296
delete-index command, 308
deploy-all command, 307
deploy-interceptor command, 309
deploying
deployment topology, 29
design-time environment (DTE), BAM and, 32
developer role
BAM projects and, 41
Tracking Profile Editor and, 117–136, 292
dimensions, 101
Biztalk Server monitoring and, 319
cubes and, 262
Direct Event Bus (DirectEventStream), 160
DirectEventStream class, 206, 236
disable-alerts command, 308
disable-reference command, 306
document reference URL nodes, 120
downloads
installation/configuration guides for BizTalk Server, 23
optimization guides for BizTalk Server, 36
posters illustrating the concepts of BizTalk and BAM, 24
sample code for this book, 121
virtualization guide for BizTalk Server, 35
DTE (design-time environment), 32
DTS (Data Transformation Services), 261
DTS packages, 295
dtutil utility, 300
Dublin, WCF/WF technologies and, 198, 200
E
EDA (event-driven architecture), 341
EDI (electronic data interchange), 12, 14
EDIFACT, 12
electronic data interchange (EDI), 12, 14
enable-alerts command, 308
enable-reference command, 147, 306
EnableContinuation() method, 168, 237
encrypting traffic to SQL Server Analysis Services, 315
EndActivity() method, 168, 237, 240
Enterprise Performance Management, 255
Enterprise Service Bus (ESB), 14, 76
Equals() method, 237
error messages, debugging projects and, 67
ESB (Enterprise Service Bus), 14, 76
ESB Guidance 2.0, 14
Event Bus (Event Stream), 160
event-driven architecture (EDA), 341
BAM Add-In and. See BAM Add-In for Excel, 40
installing, 25
views and, 40
Excel client, 20
Excel Services, SharePoint Server and, 275
Execute() method, 327
exercises, 36
aggregations, viewing via BAM Add-In for Excel, 148
alerts, managing, 146
AWO Corp. (sample application), 120–133, 280–292
BAM Management utility (bm.exe), tracing behavior of, 309
BAM solutions, 86
BAM Virtual PC for, creating, 36
BAM WCF interception configuration, 166
business processes, 95
continuations, 241
COO view (AWO Corp. sample application), 110
creating interceptor configuration files, 229
data archiving, scheduling, 302
data capture, 286
data, examining via Aggregations page, 145
live data workbooks, regenerating, 313
machine.config file, adding BAM interceptor behavior to, 165
manufacturing scheduler view (AWO Corp. sample application), 104
marketing cube, for AWO Corp. sample application, 142
marketing specialist view (AWO Corp. sample application), 106
SQL Server Management Studio and, 152, 288
SSRS, reporting data via, 263–271
TDDS, tracing behavior of, 311
tracking hosts, 297
tracking profiles, 132, 134, 283
traffic, encrypting to SQL Server Analysis Services, 315
views, querying, 144
WCF services, monitoring, 43–66
WF interceptor runtime, loading, 232
WF observation models, 226–229
WF sequential workflows, 219–225
Expression elements, 172
F
fault handling, for WCF interception, 187–190
FileMove.bat file, 123
G
GenerateEventForArtifact() method, 252
get-accounts command, 146
Get-Accounts command, 307
get-activities command, 115, 307
get-activitywindow command, 308
GetActivityEvent operation, 213
GetActivityName operation, 213
GetActivityProperty operation, 213
GetActivityType operation, 214
GetAlert() method, 252
get-alerts command, 308
GetAlertsSummary() method, 252
get-archive command, 308
GetCapabilities() method, 252
get-changes command, 306
get-config command, 306
GetContextProperty operation, 214
GetHashCode() method, 237
get-index command, 308
GetInstanceData() method, 252
GetPivotViewXml() method, 252
get-references command, 306
get-rtawindow command, 308
get-subscriptions command, 308
GetTrackingChannel() method, 206
GetType() method, 237
GetUserData operation, 214
GetUserDataType operation, 214
GetUserKey operation, 215
GetViewDetailsAsXml() method, 252
get-views command, 307
GetViewSummaryForCurrentUser() method, 252
GetWorkflowEvent operation, 215
GetWorkflowProperty operation, 215
globally unique identifiers (GUIDs), 239, 328
goods tracking, 12
groups, 295
GUIDs (globally unique identifiers), 239, 328
H
HAT (Health and Activity Tracking), 13, 317
“Hello World” (sample) application, for BAM events, 237–241
Health and Activity Tracking (HAT), 13, 317
Health Insurance Portability and Accountability Act (HIPAA), 12
health monitoring utilities for BizTalk, 317
healthcare industry, B2B business model and, 71
HelpSetupMetadata() method, 206
HIPAA (Health Insurance Portability and Accountability Act), 12
HOLAP (hybrid OLAP database), 262
hosts, 295
BizTalk orchestrations vs. WF workflows, 201
WCF services and, 193
WF workflows and, 198
HP’s OpenView, 317
Human Workflow Services (HWS), 78
hybrid OLAP (HOLAP) database, 262
I
IC file (interceptor configuration file), 18, 41
debugging projects and, 69
deploying, 60
for WCF services, creating, 56–59
for WF interceptor, 208–217, 229
IComponent interface, 327
inbound activities, for messages, 318
BAM portal and, 328
pipeline components and, 324
infix notation, 172
Informatica PowerCenter, 259
infrastructure commands, 306
integers, data capture and, 89
integration, BizTalk orchestrations vs. WF workflows, 203
interceptor configuration commands, 309
interceptor configuration file. See IC file
interceptor operations, 174, 213–217
interceptor runtime, loading, 232
interceptors. See also WCF interceptor; WF interceptor
BAM stack and, 259
configuration file for. See IC file
interchange ID, 321
inventory tracking, 12
IT Help Desk view, 17
itineraries, 77
K
KPIs (key performance indicators), 5, 275
defining, 256
SharePoint Server and, 275
L
licensing
BAM and, 35
BizTalk Server and, 35
listing deployed activities/views, 115
live data workbooks, 148
observation model commands and, 308
regenerating, 313
SharePoint Server/BAM integration and, 275
lookups, 155
M
machine.config file, adding interceptor behavior to, 165
Managed Services Engine, 277
management database, TPE and, 135
ManualWorkflowSchedulerService, 200
manufacturing scheduler view (AWO Corp. sample application), 104
ManufacturingTransmit application (AWO Corp. sample application), 122
marketing specialist view (AWO Corp. sample application), 106
mashups, 79
MDX (Multidimensional Expressions), 151
measurable objectives, 256
measures, 101
Biztalk Server monitoring and, 319
cubes and, 262
medical research, ESB and, 76
message box database, 8
MessageRefURL property, 120
messages, tracking and, 317–332
MessagingEventStream class, 236, 251, 327
Microsoft
Excel. See BAM Add-In for Excel; Excel
Office InfoPath, 25
Office Web Components, 272
PerformancePoint Server, 26, 259, 273
Software + Services vision and, 341
SQL Server Reporting Services, 26
Visio. See Visio
Microsoft Dynamics Suite, 277
Microsoft Exchange, 276
Microsoft Office applications, 272
Microsoft Office SharePoint Designer, 141
Microsoft Office SharePoint Server. See SharePoint Server
migrate-rta command, 306
migrate-sql command, 306
milestone groups, 101
MOLAP (multidimensional OLAP database), 262
monitoring
process monitoring and, 260
Monthly Claims Processed activity, 72
MOSS. See SharePoint Server
Multidimensional Expressions (MDX), 151
multidimensional OLAP (MOLAP) database, 262
N
NAICS (North American Industry Classification System), 16, 262
naming conventions, for projects, 88
custom, 26
nodes, TPE and, 119
North American Industry Classification System (NAICS), 16, 262
“No View to Display” error message, 68
numeric range dimensions, 102
O
observation model commands, 307
observation models
message tracking and, 318
WF observation models and, 226–229
ODBA (Orchestration Designer for Business Analysts), 40, 85, 94–101
creating activities via, 89
installing, 25
ODX files, 198
Office InfoPath (Microsoft), installing, 25
Office Web Components (Microsoft), 272
OLAP (online analytical processing), 259
OLAP database, 262
WCF interceptor file and, 174
WF interceptor file and, 210
online analytical processing (OLAP), 259
OpenView (HP), 317
operating systems, environments and, 34
Orchestration Designer for Business Analysts. See ODBA
orchestration (ODX) files, 198
OrchestrationEventStream class, 236, 243–250
dehydrated, 296
OrchestrationEventStream used within, 243–250
WCF/BizTalk integration and, 164
order fulfillment by region, IC file examples and, 177–183
Orders activity, 93
data archiving and, 304
Orders application (AWO Corp. sample application), 122
outbound activities, for messages, 318, 328
P
“The page cannot be found” error message, 67
parallel convoy design pattern, 10
partition tables, data archiving and, 300
PerformancePoint Server (Microsoft), 137, 273
permissions, 146
PersistenceService, 199
PersistOnCloseAttribute, 199
pipeline context, MessagingEventStream class and, 251
Pivot Table View (Aggregation page, BAM Portal), 140
pivot tables, 140
platform alignment, 14
platform services category of BAM software, 27
plus sign (+), in URLs, 48
postfix notation, 172
presentation category of BAM software, 24–26
process monitoring, 260
processing category of BAM software, 26
processing models, BizTalk orchestrations vs. WF workflows, 202
ProClarity Dashboard, 273
Program.cs file, 232
progress milestones, 111
purchase order process, 10, 16
purchasing workflows, 78
Q
R
radio frequency identification (RFID), 12, 14
real-time aggregations, 103, 115, 139
real-time visibility, 6
regenerate-livedataworkbook command, 308
relational databases, 149
relational OLAP (ROLAP) database, 262
remove-account command, 146, 307
remove-alerts command, 308
remove-all command, 307
remove-interceptor command, 309
removing activities, 115
reports, 262
SharePoint Server and, 275
models for, 263
resources for further reading
pipeline components, 323
WF sequential workflows, 219
reverse Polish notation (RPN), 172
RFID (radio frequency identification), 12, 14
ROLAP (relational OLAP database), 262
roles, BAM projects and, 39–43
RPN (reverse Polish notation), 172
rules engines. See BRE tool; WFRE untime settings for BAM, changing, 314
S
sales by region, IC file examples and, 177–183
sales manager view, 17
sales order process (AWO Corp. sample application), 90
sample code for this book, downloading, 121
SAP adapters, 9
scheduled aggregations, 139, 151, 155
scheduled views, 20
scheduling service, for WF, 200
SCOM (System Center Operations Manager), 13, 317
SDDL (Security Descriptor Definition Language), 48
Section element, of app.config file, 217
Security Descriptor Definition Language (SDDL), 48
security, WCF services and, 193
Send() method, tracking and, 206
sequential workflows, 196, 202, 219–225
Service-Oriented Architecture (SOA), 4, 75
set-activitywindow command, 308
set-archive command, 308
set-rtawindow command, 308
SetupMetadata() method, 206, 207
shared operations, 174
SharePoint Designer, 141
SharePoint Server (Microsoft), 274, 219
BAM API and, 235
installing, 25
SharePoint Services (WSS), 274
shipping manager view, 17
SMTP adapters, 9
SOA (Service-Oriented Architecture), 4, 75
SOA registry, 14
Software + Services, Microsoft and, 341
SQL Server
installing, 28
reading data from, 151
views and, 150
SQL Server Analysis Services (SSAS), 28, 262, 315
BAM/BI integration and, 259
encrypting traffic to
SQL Server Integration Services (SSIS), 259, 261
SQL Server Management Studio
relationships and, 288
using, 65
viewing data via, 152
SQL Server Notification Services
installing, 28
SQL Server Reporting Services Report Builder, 155
SQL Server Reporting Services (SSRS), 26, 259, 262
SqlTrackingService, 199
SqlWorkflowPersistenceService, 199
SSAS (SQL Server Analysis Services), 28, 262
BAM/BI integration and, 259
encrypting traffic to, 315
SSIS (SQL Server Integration Services), 259, 261
SSRS (SQL Server Reporting Services), 26, 259, 262
state-machine workflows, 196
status events, 206
status monitoring, for BizTalk Server, 317–332
StoreCustomEvent() method, 237
storefront businesses, B2C model and, 73
Strategy Map Designer, 273
strategy maps, 258
subscribing to reports, 263
system administrator role, 42
System Center Operations Manager (SCOM), 13, 317
systems integration, BizTalk Server and, 7
T
target, as a measurable objective, 256
TDDS (Tracking Data Decode Service), 295, 297, 311
TDDS_UpdateSetting stored procedure, 299
TestHarness application (AWO Corp. sample application), 122
text, data capture and, 89
time dimensions, 102
timeframe, as a measurable objective, 256
tips and tricks
for tracking profiles, 134
tools category of BAM software, 24–26
ToString() method, 237
TPE (Tracking Profile Editor), 41, 117–136
BAM API and, 235
GUIDs and, 239
installing, 25
limitations of, 134
vs. pipeline components, 323
removing orphaned tracking profiles and, 310
tracking profiles and, 283, 320
tracking, BizTalk orchestrations vs. WF workflows, 204
Tracking Data Decode Service (TDDS), 295, 297, 311
tracking inventory, 12
Tracking Profile Editor. See TPE
applying in production, 133
creating, 283
currently applied, 135
for messages, 320
recovering, 132
removing orphaned, 310
tips and tricks for working with, 134
WF tracking profiles and, 207
Tracking Service, 199, 204, 206
TrackingService class, 206
transactions, BizTalk orchestrations vs. WF workflows, 204
TransactionScopeActivity, 199
U
update-all command, 307
update-config command, 306
update-livedataworkbook command, 308
UpdateActivity() method, 168, 240, 328
UpdateAlert() method, 252
UpdateSubscription() method, 252
updating activities, 115
URLs, 47
usage-time environment (UTE), 34
user events, 206
users, 42
account viewing rights and, 115
presenting data to, 20
providing additional data to, 155
security and, 193
UTE (usage-time environment), 34
administration/management, for BizTalk orchestrations vs. WF workflows, 205
BAM Management (bm.exe). See BAM Management utility
BRE. See BRE tool
CPM tools, 5
dashboard, 259
tools category of BAM software and, 24–26
Visio. See Visio
V
debugging projects and, 68
deploying, 114
indexing, 146
items included with, 101
listing, 115
querying, 144
terminology considerations and, 150
for WCF services, creating, 51–56
virtualization technologies, 35
Virtual PC, creating to use for exercises in this book, 36
installing, 25
ODBA and. See ODBA
Visual Studio 2008 (Microsoft)
add-ins for, 13
installing, 25
SSRS and, 26
Visual Studio Report Designer, 263
W
WCF interceptor, 162
BAM Eventing and, 26
loading via BAM API, 191
WCF/BizTalk integration and, 165
WCF operations and, 176
WCF operations, 176
activities and, creating, 51–56
executing, 63
installing, 27
interceptor configuration file for, creating, 56–59, 187
integration with BizTalk and, 164–166
security/hosting considerations and, 193
web parts, 274
Web Services Description Language (WSDL), 4
WF interceptor, 206
BAM Eventing and, 26
interceptor configuration file for, 208–217, 229
monitoring WF workflows via, 208
WF interceptor runtime, loading, 232
WF observation models, 226–229
WFOperationTypes, 213
WF Rules Engine (WFRE), 200, 203
WF Scheduling Service, 200
WF sequential workflows, 219–225
WF Tracking Service, 199, 204, 206
vs. BizTalk orchestrations, 195–205
installing, 27
monitoring via WF interceptor, 208
run-time services for, 198
tracking profiles and, 207
WFRE (WF Rules Engine), 200, 203
Windows Communication Foundation. See WCF services
Windows Mobile, RFID and, 13, 14
Windows SharePoint Services (WSS), 274
Windows Workflow Foundation. See WF workflows
workflow events, 206
WorkflowInspector class, 206
WorkflowInstance, 199
WorkflowPersistenceService class, 199
WorkflowRuntime class, 217
workflows. See WF workflows
WSDL (Web Services Description Language), 4
WSS (Windows SharePoint Services), 274
X
X12, 12
XAML language, 195
XLANG language, 195