Preparation
Before you can target with the SQLite database connector, you must:
Create a SQLite database file.
Create a SQLite database configuration file.
Set up a target system administrator
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.