ATG Repository Guide

Create the repository definition file for the SQL repository to use. This template is an XML file that defines the item descriptors and repository item attributes contained in your SQL repository and describes the relationship of your SQL repository to the SQL database. While the SQL repository is flexible enough to represent a variety of different data models, it cannot easily represent any arbitrary data model. Therefore, it is usually a good idea to design the SQL repository schema before you design your SQL database schema.

The SQL Repository Data Models and SQL Repository Item Properties chapters describe how to design your item descriptors and other SQL repository elements. See also the SQL Repository Definition Tag Reference for full details of the XML tags used to create the SQL repository definition file.

Configure a SQL Repository component. The SQL Repository component’s class is atg.adapter.gsa.GSARepository, which implements atg.repository.MutableRepository and atg.repository.content.ContentRepository and which extends atg.repository.RepositoryImpl. The definitionFiles property of the SQL Repository component points to the repository definition file for the repository. See the Configuring the SQL Repository Component chapter.

Create the SQL database schema on your SQL database server. You can use the startSQLRepository script with the –outputSQL option to generate a preliminary form of the SQL needed to create the database schema, and then edit the output to optimize the database schema. See startSQLRepository Script and the Template Parser in the Development, Testing and Debugging with the SQL Repository chapter.