The Service applications use the following connections:
A connection for the agent schema that contains all the versioned tables edited by Knowledge and Service Admin
A connection for the production schema that contains all the data deployed from Knowledge and Service Admin along with the non-versioned data shared between Knowledge 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 must be configured:
/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 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
ServiceRepositoryresides.Management Database – This database defines the BIZUI database for the Management server so the BCC 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 for publishing deployment.ServiceSwitchDataSource_readpoints to the live production data source. The repository components used by both Knowledge and Self Service to read production data for use in the applications are configured to use this data source.
