Creating a Database Repository
A database repository stores reports and configuration files in a database schema. To create a database repository, follow the steps below:
1. From the Style Studio 'File' menu, select 'Configure'. This opens the 'Style Studio Configuration' dialog box.
2. Select the Repository tab.
3. On the Repository tab, press the 'New' button. This opens the 'New Repository' dialog box.
4. In the 'Name' field, enter the label under which the repository should be listed.
5. Select the 'Database' option from the 'Type' listing, and press 'OK'.

A green check-mark indicates the working repository.
This adds a new database repository to the listing in the Repository tab, and automatically sets this new repository to be the working repository. (See Selecting the Working Repository for information on manually setting the repository.)
The specified directory cannot be used for any other repository.
6. In the 'Configuration Directory' field, enter the full path to a directory which will store the database connection information.
7. In the 'Database' menu, select the type of database to use for storage of the repository files. The options are 'SQLServer', 'Oracle', 'Derby', 'DB2', PostgreSQL, MySQL. (To use the sample audit database of the default installation, select 'Derby'.)
Your database administrator can provide the connection URL.
8. In the 'URL' field, enter the connection information for the database schema. (To use the sample audit database, enter jdbc:derby://localhost:1527/database;create=true. To run the audit database, expand the 'Style Intelligence' program group in the Windows 'Start' menu, and select 'Audit Database'.)
9. In the 'Driver' field, enter the appropriate class name for the Java driver. (This field may already be populated based on your selection in the 'Database' menu. To use the sample audit database, enter org.apache.derby.jdbc.ClientDriver.)
10. Select 'Requires Login' if the database requires a user name and password to open a connection. In this case, also enter the desired 'User Name' and 'Password' credentials. (To use the sample audit database, enter “app” for the 'User Name' and “password” for the 'Password'.)

11. (Optional) In the 'Default DB' field, enter the name of the default database schema to receive the connection.
12. In the 'Isolation Level' field, select the desired isolation level.
13. (Optional) If an existing schema contains multiple asset (Worksheet/Viewsheet) packages, specify the desired package in the 'Asset File Key' field.
14. Press 'OK' to close the dialog box.
This new 'Database' repository can be used either as the working repository or as a remote repository.
See Also
Selecting the Working Repository, to manually select the working repository.
Creating a New Repository, for information about different repository types.
| << Creating a Local Repository | © 1996-2013 InetSoft Technology Corporation (v11.5) | Creating a Server Repository >> |