Skip to main content

Preparation

Before Bravura Security Fabric can manage accounts on an ODBC-based database management system, you must:

  1. Install the client software.

  2. Either:

    • Define a data source.

      or

    • Find installed ODBC drivers.

  3. Configure a target system administrator.

  4. Create at least one template account to provision accounts for this target.

  5. Write a script to configure connector behavior

Installing client software

Bravura Security Fabric communicates with the ODBC-based database management systems via APIs provided by the ODBC client. Before you target an ODBC-based database management application, install and configure the ODBC client software on the Bravura Security Fabric server.

Defining a data source

Bravura Security Fabric can target an ODBC database hosted application either using the data source name or via the driver. If using a data source name, you must specify this in the Server parameter in the target address. To define the data source:

  1. Start the ODBC data source administrator tool (odbcad32.exe).

    Depending on your system, this is located at:

    • c:\Windows\System32\odbcad32.exe (64-bit)

    • c:\Windows\SysWow64\odbcad32.exe (32-bit)

  2. Select the System DSN tab.

    The ODBC data source administrator tool displays a list of data sources.

    If a data source does not exist for the ODBC-based database management system that you want Bravura Security Fabric to target, click Add… and create a new data source. See your Windows or ODBC-based database management software help for more information. If you are targeting CSV files, see Preparation for targeting CSV files using the ODBC connector .

  3. Note the system data source name (DSN). You will need this name when adding the target to Bravura Security Fabric . This is usually the same as the ODBC-based database name.

  4. ( Optional) Test the connection to the target system database.

  5. Click OK to close the ODBC data source administrator tool.

See your ODBC-based database management documentation for more information on configuring the ODBC client software.

Finding installed ODBC drivers (Optional)

Bravura Security Fabric can target an ODBC database hosted application via an ODBC driver or a data source. If connecting to a driver, the driver name and connection parameters are required in the ODBC driver and Connection string settings in the target address. To find drivers:

  1. Start the ODBC data source administrator tool.

  2. Select the Drivers tab.

You can also find installed ODBC drivers in the following registry entries:

  • 32-bit ODBC drivers:

    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC Drivers

  • 64-bit ODBC drivers:

    HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers

Configuring a target system administrator (Optional)

Bravura Security Fabric uses a designated account (for example, psadmin) on the ODBC-based database target system to manage accounts passwords. The target system administrator requires ODBC-based database back end 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 ODBC-based database target system to Bravura Security Fabric .

This step is optional if the target system administrator is same as the database user or login id used in the ODBC data source configuration in previous step.

Normally connectors run on the Bravura Security Fabric server under the service account that runs the application services. If the connection to the target database files (for example on a network share) requires the connector to run using the target administrator credentials, check the Run as option.

Creating a template account

Bravura Security Fabric uses template accounts as models or "blueprints" for creating new application accounts in an ODBC-based database managed application.

The steps required to create a template account depend on your application. Consult your systems administrator or application documentation for more information.

Writing a script to configure connector behavior

Write a script file to define SQL commands used in the interaction between the ODBC connector and the ODBC-based database.

Learn about writing script files for SQL application connectors.

In this section: