Data Access Tool
The Data Access Tool (DAT) is a new feature in Host Integration Server 2004 designed to streamline the process of creating and managing connections to data sources on host environments. Whereas this used to be divided into multiple feature sets and programs, the DAT provides a single mechanism to guide you through configuring network, security, and database information, and creating packages on the DB2 system.
The DAT consists of two items:
The Data Source Browser displays all data sources in familiar MMC format for configuration and management.
The Data Source Wizard guides you step by step through the configuration process. The wizard dynamically adapts to both DB2 and File System data sources, and displays the appropriate screens.
Note The Data Access Tool and DB2 data providers create DB2 packages for use by all DB2 users, by setting the execute privilege on the DB2 packages to PUBLIC. It is recommended that you revoke execute privileges to PUBLIC on these packages, and then grant execute to selected DB2 users or groups.
This section contains:
- Editing a Configuration
- Displaying an Initialization String
- Testing a Connection
- Creating Packages
- Running a Sample Query
- Converting Data Sources
- Adding a Table
- Creating a New Data Source or Data Description
- Opening a File
- Importing a File
- Other Tasks
All rights reserved.