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:
In order to use DB2 at design time (that is, in this procedure) and at runtime (in the Verification and Business Logic activities), IBM Data Server Runtime Client must be installed on each XBOUND workstation and server that may need to access DB2.
Note: XBOUND uses DB2 .NET Provider.
Otherwise, the same conditions apply as for XBOUND's support of DB2 (see XBOUND Installation Guide).
Use this procedure:
- Using the XBOUND Management Center, open a console containing the Validation Designer. (For information about working with consoles, see XBOUND Help.)
- Under , select a process.
Click the button (
).Select > .
Click . Or select a connection and click .
The dialog is displayed. Specify the settings:
Name of the connection.
Display name of the connection.
SQL Server, DB2 or Oracle.
Name of the database server.
Connection port (DB2 only). By default this is set to the standard port for DB2, 50000.
Name of the user. Needed only if Windows Security or is not used.
Password of the user. Needed only if Windows Security or is not used.
The connection uses the account of the user logged on to Windows (SQL Server only).
Name of the database (SQL Server only).
The database schema (DB2 only).
Note: The schema must also use the same case sensitivity as is used in the database.
button
Tests the connection to the database.
Note: If you use Oracle, you must install Oracle Client and configure TNSNames.ora.
Click the button to check that the connection succeeds.