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. This schema is accessed from the agent-facing servers. |
| Unversioned repository tables. Referred to in this document as the production schema. This schema is accessed from the customer-facing servers. |
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 Commerce | Production |
| ATG CSC | Production |
| ATG CSC | Agent |
| ATG CSC | Production |
| ATG Service | Agent |
| ATG Service | Production |
| ATG Service | Production |
| ATG Reporting | Data warehouse |