4.5 Configuring Database for Audit/Data Space

Note: You must con­figure a database before enabling audit­ing.

You can use a database for persistent storage of the following items:

Data space (report templates, datasource.xml, query.xml, etc.)

Asset repository (asset.dat)

Audit Records

To configure storage for these elements, use the 'Repository' > 'Data Space' and 'Repository' > 'Audit' pages. (See the Data Space and Audit sections for more information.)

To configure a database for persistent storage, open the 'Configuration' > 'Database' page (under the Server tab), and specify the database type, connection information, and the transaction isolation level.

Figure 5. Database Setup Page

 

Note: Cache and temporary files cannot be stored in a database.

The 'Default DB' field indicates the name of the database schema to be used. If left unspecified, the default database schema for the particular user profile will be used. When you have entered the required information, test the connection by clicking on the 'Test Connection' button.

The following databases are supported for data space and auditing purposes: Oracle, DB2, SQL Server, PostgreSQL, MySQL, and Derby. For your convenience, a sample Derby database is included with the default installation. To run this database, select 'Audit Database' from the Style Intelligence program group in the Windows 'Start' menu.

 

<< 4.4 Specifying Data Source Information © 1996-2013 InetSoft Technology Corporation (v11.5) 4.6 Configuring Server Email >>