Preparation
Before Bravura Security Fabric can manage application accounts in a DB2 database, you must:
Install the client software.
Define a data source.
Configure a target system administrator.
Create at least one template account to provision accounts for this target..
Write a script to configure connector behavior.
Installing client software
Bravura Security Fabric communicates with the DB2 server via APIs provided by the DB2 Connect client. Before you can target a DB2 application, you must install and configure the DB2 Connect client on the Bravura Security Fabric server.
Defining a data source
After you have installed the DB2 client, ensure that an ODBC system data source exists for each DB2 back end database that Bravura Security Fabric will target. To do this:
Open Control Panel and select Administrative Tools > Data Sources (ODBC).
Select the System DSN tab .
The ODBC Data Source Administrator displays a list data sources. DB2 data sources are indicated by the driver "IBM DB2 ODBC DRIVER".
If a data source does not exist for the DB2 database that you want Bravura Security Fabric to target, click Add and create a new data source. See your Windows or DB2 help for more information.
Note the system data source name (DSN). You will need this name when adding the target system to Bravura Security Fabric . This is usually the same as the DB2 database name.
(Optional) You can test the connection to the target system database.
Click OK to close the ODBC Data Source Administrator.
See your DB2 documentation for more information on configuring the DB2 client software.
Configuring a target system administrator
Bravura Security Fabric uses a designated account (for example, psadmin) on the DB2 target system to perform operations. The target system administrator require DB2 back end database privileges that grant execution of SQL commands used in the written script.
Ensure that you set and note the account’s password. You will be required to enter the login ID and password when you add the DB2 target system to Bravura Security Fabric .
Creating a template account
Bravura Security Fabric uses template accounts as models or "blueprints" for creating new application accounts in a DB2 database.
The steps required to create a template account depend on your application. Consult your systems administrator or application documentation for more information.
To learn how to create a template for DB2 database-level accounts, see DB2 creating a template account .
Writing a script to configure connector behavior
You write a script file to define SQL commands used in the interaction between the agtdb2script connector and the DB2 database.
Learn about writing script files for SQL application connectors.