ATG Commerce Service Center requires two different database user accounts for database configuration. Create the following accounts before configuring the database
Database Schema | Contents |
---|---|
| Versioned repository tables. Referred to in this document as the Agent schema |
| Unversioned repository tables. Referred to in this document as the Production schema. |
Databases can be configured with the tables on separate machines, separate table spaces or partitions, or in other configurations.
The following table outlines the SQL files used, the product that the file references, and the schema to which the file should be pointed:
SQL | Product | Schema |
---|---|---|
| ATG CSC | Production |
| ATV CSC | Production |
| ATG CSC | Agent |
| ATG CSC | Production |
| ATG Service | Agent |
| ATG Service | Production |
| ATG Service | Production |
| ATG Reporting | Datawarehouse |