Creating and testing a database connection

Note: Currently master data cannot be used with Web Verification.

Before you create a database query, you must set up a database connection.

Note: One database connection can be used in multiple queries. Database connections configured using this procedure are used only for database queries.

Prerequisites for connecting to an IBM DB2 database:

Use this procedure:

1. Using the XBOUND Management Center, open a console containing the Validation Designer. (For information about working with consoles, see XBOUND Help.)
2. Under Process Navigation, select a process.

3. Click the Check out button ().

4. Select File > Connections.

5. Click Add. Or select a connection and click Edit.

6. The Edit connection dialog is displayed. Specify the settings:

   Name	Name of the connection.
   Display name	Display name of the connection.
   Database type	SQL Server, DB2 or Oracle.
   Database server	Name of the database server.
   Port	Connection port (DB2 only). By default this is set to the standard port for DB2, 50000.
   User name	Name of the user. Needed only if Windows Security or Trusted connection is not used.
   Password	Password of the user. Needed only if Windows Security or Trusted connection is not used.
   Trusted connection	The connection uses the account of the user logged on to Windows (SQL Server only).
   Database name	Name of the database (SQL Server only).
   Schema	The database schema (DB2 only). Note: The schema must also use the same case sensitivity as is used in the database.
   Test connection button	Tests the connection to the database. Note: If you use Oracle, you must install Oracle Client and configure TNSNames.ora.

7. Click the Test connection button to check that the connection succeeds.

Related topics

Querying master data: Overview