Skip to main content

Targeting an ODBC database hosted application

For each ODBC-based database system, add a target system (Manage the system > Resources > Target systems):

  • Type is:

    • ODBC Database (Script) for 64-bit data sources.

    • ODBC Database (32-bit) (Script) for 32-bit data sources.

  • Address uses syntax described in the table below.

  • Administrator ID and Password is the login ID and password for the target system administrator you configured in earlier.

    The target system credential is optional if the ODBC data source contains the password needed for connection.

    Check the Run as option to use the target credentials to run the connector.

The full list of target system parameters is explained in Target system options .

Table 1. ODBC-based database address configuration

Option

Description

Options marked with a redstar.png are required.

Server redstar.png

ODBC-based database system DSN or database server.

See Defining a data source to learn how to find the ODBC system DSN for your ODBC-based database application. Use the server name if connecting via ODBC Driver.

(key: server)

Instance

Optional script variable instance name.

(key: instance)

Script file redstar.png

The script file must be in the <Program Files path>\Bravura Security\Bravura Security Fabric\<instance>\ script\ directory and describes the SQL commands used in the interaction between the connector and the database.

(key: script)

ODBC driver

The ODBC driver used to access the ODBC-based database. If this value is empty, the Server parameter is treated as the ODBC system DSN, otherwise, the Server parameter is treated as the database server to connect to.

(key: driver)

ODBC connection string

Specifies options to use with ODBC Driver. It consists of a series of keyword/value pairs separated by semicolons:

<keyword1>=<value>; <keyword2>=<value>

(key: params)



The ODBC target system address syntax is as follows when using the system DSN:

{server=<system DSN>;[instance=<script_variable_instance>;]script=<script filename>;}

The ODBC target system address syntax is as follows when connecting to the database driver:

{server=<DatabaseServer>; [instance=<script_variable_instance>;]script=<script filename>; driver=<ODBC driver>;[params=<keyword1=value;...>]}

In this section: