Chapter 1. IBM WebSphere Information Analyzer overview 339
These rules establish the relationship of two or more conditions. An example
of such a rule is if the account status is closed, then there must not be any
For complete details on IBM WebSphere AuditStage functionality, refer to
Ascential AuditStage Version 7.0.1 User’s Guide, Part No. 00D-001AS701.
In the following sections, we describe briefly the configuration of the data source
name (DSN) followed by some business rule examples using the sample set of
tables described in Figure 1-11 on page 31.
1.12.1 Configure the DSN
You need to configure the data source which will be accessed by IBM
WebSphere AuditStage during business rule validation.
Figure 1-263 on page 341 through Figure 1-275 on page 347 show the
configuration of a data source using an ODBC driver as follows:
1. Launch IBM WebSphere AuditStage by clicking Start → All Programs →
Ascential AuditStage™ → AuditStage. Then, log in by supplying the user
ID and password. This action is not shown here.
2. From the File menu, select New to create a new project as shown in
Figure 1-263 on page 341.
3. Provide the File Name (IA_SAMPLE) for the name of the project and click
Save as shown in Figure 1-264 on page 341.
4. In the Select Data Source Type window, check External database (through
ODBC) and click OK as shown in Figure 1-265 on page 342.
5. In the Select Data Source window, click New to add a new file data source as
shown in Figure 1-266 on page 342.
Attention: In the following sections, to avoid overburdening the text with
excessive figures, we have
not included all the panels that you would navigate
through typically to perform the desired functions. Instead, we focus on
including select panels (and in some cases, just portions of these panels) that
highlight the key items of interest, thereby skipping the initial panels, as well as
some intervening ones, in the process.
340 IBM WebSphere Information Analyzer and Data Quality Assessment
6. We are creating a machine data source. Therefore, in the Select Data Source
windows, click the Machine Data Source tab and click New to create a new
data source as shown in Figure 1-267 on page 343.
7. In the Create New Data Source window, check System Data Source (Applies
to this machine only) which creates a data source which is specific to this
machine, and usable by any user who logs on to this machine as shown in
Figure 1-268 on page 343. Click Next.
8. In the next window, select the IBM DB2 ODBC DRIVER as the driver for which
you want to set up a data source as shown in Figure 1-269 on page 344, and
9. Click Finish in the new Create New Data Source window as shown in
Figure 1-270 on page 344 to create the data source.
10.The ODBC IBM DB2 DRIVER prompts for information about the DB2
database to register. Provide the Data source name (IA_SAMPLE) and
Database alias (IA) as shown in Figure 1-271 on page 345, and click OK.
11.In the Select Data Source window, select the Data Source Name
(IA_SAMPLE) and click OK source name to connect to it as shown in
Figure 1-272 on page 345.
12.In the Connect to DB2 Database window, provide the user ID and Password
to connect to the database in Share mode as shown in Figure 1-273 on
page 346, and click OK.
13.In the Select a Source Database window, select DB2 (UDB) as shown in
Figure 1-274 on page 347.
Note: The File Data Source tab lets you connect with a data source that
has file data source names (DSNs). A file-based data source, not
necessarily user-dedicated nor local to a computer, can be shared among
all users who have the same drivers installed.
The File Data Source tab displays all file DSNs and subdirectories of the
directory indicated in the Look in box. Double-clicking a DSN connects to
the data source.
The Look in field indicates the directory for which the subdirectories and
file DSNs are listed in the window below. Clicking the down arrow
alongside this text box displays the entire directory structure.
Note: User Data Sources are specific to a user on this machine, while
System Data Sources are usable by any user who logs on to this machine.