Skip to main content

Preparation

Before you can target with the SQLite database connector, you must:

  1. Create a SQLite database file.

  2. Create a SQLite database configuration file.

  3. Set up a target system administrator

  4. Create at least one template account.

Creating a SQLite database file

You require a SQLite database file that contains the account, group, group membership, computer and subscriber information. This file can be placed in the <Program Files path>\Bravura Security\Bravura Security Fabric\<instance>\ script\ directory. Alternatively, you can use the existing extdb.db database contained in the \<instance>\db\* directory.

A sample SQLite database, agtsqlite.db is contained in the samples\* directory. This database shows the necessary tables, as well as the columns needed in order to work with the sample configuration file, along with some sample data.

Creating a SQLite database configuration file

You must create a configuration file that maps the SQLite database table data to Bravura Security Fabric attributes. The configuration file must be placed in the <Program Files path>\Bravura Security\Bravura Security Fabric\<instance>\ script\. A sample script, agtsqlite.cfg is contained in the samples\* directory. Note that any sample script may need customizations in order to work with your database.

Setting up a target system administrator

Bravura Security Fabric does not require a designated administrator account to perform Bravura Security Fabric operations using the SQLite database connector. You will still see a warning message saying that no administrator credentials are specified, however this can be ignored.

Creating a template account

Bravura Security Fabric uses template accounts as models or "blueprints" for creating new accounts in the SQLite database. Add a record in the account table in the SQLite database to designate as the template account.