Required Databases and Users

ATG Commerce Service Center requires two different database user accounts for database configuration. Create the following accounts before configuring the database

Database Schema

Contents

svcagent
(Agent)

Versioned repository tables. Referred to in this document as the agent schema. This schema is accessed from the agent-facing servers.

svcadmin (Production)

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

DCS_ddl.sql

ATG Commerce

Production

DCS-CSR_ddl.sql

ATG CSC

Production

DCS-CSR_logging_ddl.sql

ATG CSC

Agent

DCS-CSR_ticketing_ddl.sql

ATG CSC

Production

service_agent.sql

ATG Service

Agent

service_self_service.sql
(optional – required if running Knowledge)

ATG Service

Production

service_shared.sql

ATG Service

Production

service_datawarehouse.sql

ATG Reporting

Data warehouse

 
loading table of contents...