IBM WebSphere Information Analyzer and Data Quality Assessment

Chapter 1. IBM WebSphere Information Analyzer overview 339

򐂰 If…Then…Else rules

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

orders pending.

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

click Next.

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.