The ATG SQL repository can be used to connect ATG applications to a SQL database. A SQL database provides fast, scalable storage and retrieval of persistent information. The SQL repository works with a SQL database to store objects and make those objects visible inside an ATG application as Dynamic Beans. The uses of a SQL repository can be as varied as the uses of a relational database. The ATG platform includes SQL repositories used to store:
User profiles (the Personalization module’s SQL Profile Repository). See the SQL Profile Repositories chapter in the ATG Personalization Programming Guide.
Content to be displayed on a Web site (the SQL content repository). See this chapter and the SQL Content Repositories chapter.
Security profiles used by the Administrative Security system. See the Managing Access Control chapter of the ATG Programming Guide.
In addition to these, an ATG Commerce site uses repositories for:
The store catalog. See the Using and Extending the Default Catalog chapter in the ATG Commerce Programming Guide.
In process orders. See the ConfiguringPurchase Process Services chapter in the ATG Commerce Programming Guide.
Inventory. See the Inventory Framework chapter in the ATG Commerce Programming Guide.
Gift lists and wish lists. See the Configuring Merchandising Services chapter in the ATG Commerce Programming Guide.
Pricing and promotions. See the Using and Extending Pricing Services chapter in the ATG Commerce Programming Guide.
The ATG platform includes a component at /atg/registry/ContentRepositories
that lists all SQL content repositories that have been registered with it.