The Oracle ATG Web Commerce SQL repository can be used to connect Oracle ATG Web Commerce applications to an SQL database. An SQL database provides fast, scalable storage and retrieval of persistent information. The SQL repository works with an SQL database to store objects and make those objects visible inside an Oracle ATG Web Commerce application as Dynamic Beans. The uses of an SQL repository can be as varied as the uses of a relational database.

The Oracle ATG Web Commerce platform includes SQL repositories that store:

In addition, an ATG Commerce site uses repositories that store:

  • Store catalog

  • In-process orders

  • Inventory

  • Gift lists and wish lists

  • Pricing and promotions

Refer to the ATG Commerce Programming Guide for information about these repositories.

The Oracle ATG Web Commerce platform includes a component at /atg/registry/ContentRepositories that instantiates the class atg.repository.nucleus.RepositoryRegistryService, which maintains a list of all registered SQL content repositories.

Repository setup steps

You set up an SQL repository on the Oracle ATG Web Commerce platform in the following steps:

  1. Create the repository definition file to be used by the SQL repository.

    This template is an XML file that defines repository item descriptors and their attributes, and describes the relationship of your SQL repository to the SQL database. While the SQL repository can represent a variety of data models, it cannot easily represent any arbitrary data model. Thus, 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 item descriptors and other SQL repository elements. See also the SQL Repository Definition Tag Reference for details about the XML tags used to create the SQL repository definition file.

  2. Configure an SQL Repository component.

    This component’s definitionFiles property points to the repository definition file. For detailed information, see Configuring the SQL Repository Component.

  3. 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, then edit the output to optimize the database schema.