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.