The ATG Service applications use the following connections:
A connection for the agent schema that contains all the versioned tables edited by Knowledge Manager and Service Administration
A connection for the production schema that contains all the data deployed from Knowledge Manager and Service Administration along with the non-versioned data shared between Knowledge Manager and Self Service or for Self Service alone
A connection for the data warehouse schema that is used for reporting
For data import via startSQLRepository, there are four components that are configured during the Configuration and Installation Manager (CIM) installation:
/atg/dynamo/service/jdbc/FakeXADataSource_production– the connection information for the production schema/atg/dynamo/service/jdbc/FakeXADataSource_agent– the connection information for the agent schema/atg/reporting/datawarehouse/FakeXADataSource– the connection information for the data warehouse schema/atg/dynamo/service/jdbc/FakeXADataSource– used on the agent server for importing the publishing roles into theInternalProfileRepository
A typical production configuration of ATG Service has the following databases:
Production Database – This Self Service database is where the repositories shared by the Management, Agent, and Self Service servers reside
Agent Database – This database and contains agent information and is where the versioned
ServiceRepositoryresidesManagement Database – This database defines the BIZUI database for the Management server so the Business Control Center can run on the Management server
Data Warehouse Database (optional) – If you are running Reporting, all data warehouses need to reside in a single database to generate cross application reports. Both the data warehouse and the data warehouse loader tables should reside in this database
Switching Database – The switching database is used during production to ensure that database updates do not interfere with the performance of a live site.
ServiceSwitchingDataSource_productionis the switching data source that always points to the offline production data source. The repository components that deploy solutions and other versioned data to production are configured to use this data source. This data source is used exclusively by Knowledge Manager for publishing deployment.ServiceSwitchDataSource_readpoints to the live production data source. The repository components used by both Knowledge Manager and Self Service to read production data for use in the applications are configured to use this data source
