Database repositories

In addition to the parameters that apply to all repository types, you can configure the parameters in this section for database repositories.

NOTE:

If you want to set up multiple database repositories, you can also configure these parameters in the [Default] section (if you also have other repository types set up, they are not affected by these settings).

The configuration for each type of database connection is identical, except that:

The following example shows how to retrieve user and group information from a database:

[ODBC]
GroupServerLibrary=ogs_dbodbc
ConnectionString=DSN=Groups
SQLStatement=SELECT DISTINCT Username FROM Groups
AddType=USER
UserColumn=Username
[Oracle]
GroupServerLibrary=ogs_dboracle
ConnectionString=USER/PASSWORD@TNS_ALIAS
SQLStatement=SELECT DISTINCT Username FROM Groups
AddType=USER
UserColumn=Username

_HP_HTML5_bannerTitle.htm