This chapter describes how to integrate Serena PVCS Dimensions with Oracle Enterprise Repository, which enables the use of a webdav-enabled PVCS repository within Oracle Enterprise Repository.
This chapter contains the following sections:
To add Serena Changeman Plug-ins:
Navigate to this Oracle_HOME\repositoryXXX\core\tools\solutions directory on your computer. A list of all the solution packs for Oracle Enterprise Repository is displayed.
Unzip the OER30-RC-Enhanced-SCM-Integrations.zip file to a temporary directory.
Using an SQL tool appropriate for your database, run the SQL script located in the temporary directory to add Serena Changeman to your Oracle Enterprise Repository database.
This procedure is performed in the Oracle Enterprise Repository Asset Editor.
Select Configure Artifact Stores from the Actions menu.
Click Add to open the Create a new Artifact Store dialog.
Create a new SCM repository using the following parameters:
Hostname: <app server name with port> where Harvest-HTTP Artifact Store Integration was installed.
Path: harvest_rep/retrieve/<harvest_broker_name>
Leave Username and Password blank.
Click OK.
To configure a PVCS artifact store:
Login to Oracle Enterprise Repository as a user. (Requires assignment to a role that includes the Edit Artifact Stores permission.)
Click the Edit/Manage Assets link in the sidebar on the Assets screen. The Asset Editor launches.
Select Configure Artifact Stores in the Actions menu. The Configure Artifact Stores dialog is displayed.
Click the Add button. The Create a new Artifact Store dialog is displayed.
Enter a descriptive name for the repository.
In the Type list, select the PVCS repository type for this repository definition.
Enter a host name and path for the server.
If necessary, enter a username and password.
Note:
This is an option; entering a username and password enables automatic login. To add a database password, add the "+" character and the database password. An example PVCS URL used to reach a specific file in PVCS through webdav resembles the following: http://repositoryName+databaseName:password@host.server.com:port/webdavPath/additionalPathStructure/filename
If a username and/or a password is used to access this repository, check the option to Proxy Download Requests.
When finished, click Save.
To add a file to an asset using a PVCS repository:
Launch the Asset Editor.
Select the appropriate asset.
Navigate to the File Information section on the asset's Overview tab.
Click Add.
In the dialog, enter a name and description, if necessary.
Click Edit. The Edit URL dialog is displayed.
Select the Repository File option.
From the Host drop-down list, select PVCS Repository.
In the File Name box, enter the file name or browse to the file in the PVCS repository and select it.
Select View to test the URL.
Depending on the specific configuration, user names and passwords may be visible in URLs. Forcing individual user authentication at the file level solves the issue, but disables the Serena PVCS Dimensions browser in the Oracle Enterprise Repository Asset Editor. Using the Proxy Download Requests option in the artifact store definition eliminates the possibility of the user gaining access to these details.
Users may be able to exploit certain Serena PVCS Dimensions filepath characteristics to gain unauthorized access to restricted files when the Proxy Download Requests option is not selected in the artifact store definition.