The Edit connection dialog

ClosedTo access this dialog:

  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.

Use these settings to create and test a database connection:

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.

Querying master data: Overview

Validation Designer plug-in