Skip to main content

InterSystems Caché Hosted Applications

Connector name

agtcachescript

Connector type

Executable

Type (UI field value)

InterSystems Caché/Server (Script)

Target system versions supported / tested

Bravura Security Fabric can manage passwords and accounts defined wholly inside an InterSystems Caché application table space. The connector uses the InterSystems Caché client software to bind to the InterSystems Caché database server and issue SQL commands.

Connector status / support

Customer-Verified

Clients may contact Bravura Security support for assistance with this connector. Troubleshooting and testing must be completed in the client's test environment as Bravura Security does not maintain internal test environments for the associated target system.

Installation / setup

Write a script file to define SQL commands used in the interaction between the agtcachescript connector and the InterSystems Caché database. A sample script, agtcachescript.cfg is contained in the samples directory.

No connector software is installed on the InterSystems Caché server.

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

  • user verify password

  • administrator reset password

  • enable account

  • disable account

  • check account enabled

  • create account

  • delete account

  • update attributes

  • add user to group

  • delete user from group

  • add group to group

  • remove group from group

  • 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 .

Bravura Security Fabric can also manage InterSystems Caché database-level accounts using the connector for InterSystems Caché (agtcache). See InterSystems Caché for details.

The following sections show you how to:

  • Define an account for the target system administrator

  • Install the required software components

  • Set the InterSystems Caché target system address in Bravura Security Fabric

  • Create template accounts

Preparation

Before Bravura Security Fabric can manage application accounts on InterSystems Caché, you must:

  1. Install the client software.

  2. Configure a target system administrator.

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

  4. Write a script to configure connector behavior.

Installing client software

Bravura Security Fabric communicates with the InterSystems Caché server via APIs provided by the InterSystems Caché client. Before you can target InterSystems Caché, you must install and configure the InterSystems Caché client on the InterSystems Caché server.

Consult the documentation included with your InterSystems Caché client software for more information.

Configuring a target system administrator

Bravura Security Fabric uses a designated account (for example, psadmin) on the InterSystems Caché target system to perform operations. The target system administrator require InterSystems Caché 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 InterSystems Caché 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 InterSystems Caché database.

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 agtcachescript connector and the InterSystems Caché database. A sample script, agtcachescript.cfg is contained in the samples directory. Note that any sample script may need customizations in order to work with your system.

Learn about writing script files for SQL application connectors.

Targeting a Caché database hosted application

For each InterSystems Caché hosted application, add a target system (Manage the system > Resources > Target systems):

  • Type is InterSystems Caché/Server (Script) .

  • Address requires the following:

    Database server address DNS hostname

    Port number

    Database namespace

    Script file Name of the script file to configure connector behavior .

    The address is entered in KVGroup format:

    {server=<serverAddress>;port=<serverPort>;namespace=<namespace>;script=<script>}

  • Administrator ID and Password are the login ID and password for the target system administrator you configured.

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

Handling account attributes

In order for Bravura Security Fabric to manage attributes, you must first add the attributes to Bravura Security Fabric.

See Account attributes in the Bravura Security Fabric configuration documentation for more information.

In this section: