Skip to main content

ODBC script

Connector name

  • agtodbcscript

  • agtodbcscript-32

Connector type

Executable with configuration SQL script

Type (UI field value)

  • ODBC Database (Script)

  • ODBC Database (32-bit) (Script)

Target system versions supported / tested

Bravura Security Fabric can use Open Database Connectivity (ODBC) to access data from a variety of database management systems using the scripted connector for ODBC (agtodbcscript or agtodbcscript-32 ). Supported database management systems include: DB2, Oracle Database, Microsoft SQL Server, and SAP (Sybase) Adaptive Server Enterprise (ASE). You can also use the ODBC connector to target CSV file systems.

Connector status / support

Bravura Security-Verified

This connector has been tested and is fully supported by Bravura Security.

Installation / setup

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

No connector software is installed on the ODBC-based database application server or the back end database.

Bravura Security Fabric can perform operations on ODBC-based database management systems. The ODBC connectors uses ODBC client software to bind to the ODBC-based database server and either directly updates user records (for example, SQL UPDATE) or calls stored procedures.

The following Bravura Security Fabric operations are supported by this connector:

  • user verify password

  • get server information

  • user change password

  • administrator reset password

  • administrator reset+expire password

  • expire password

  • unexpire password

  • administrator verify password

  • verify+reset password

  • enable account

  • disable account

  • check account enabled

  • create account

  • delete account

  • lock account

  • unlock account

  • check account lock

  • expire account

  • check account expiry

  • unexpire account

  • add user to group

  • delete user from group

  • create group

  • delete group

  • add group to group

  • remove group from group

  • move contexts

  • rename account

  • update attributes

  • list account attributes

  • List:

    • accounts

    • attributes

    • groups

    • members

For a full list and explanation of each connector operation, see Connector operations.

This connector also supports custom operations, as defined in the configuration script.

When targeting a CSV file system using the ODBC scripted connector, only the read-only list operations are supported.

In this section: