The following modifications occur to the server instances when using these optional add-ons:

Add On

Server Instance

Changes to Server Instance

Data Warehouse

Data Warehouse

Add DW, Service.DW , Service.SelfServiceDataWarehouse and Service.KnowledgeDatawarehouse schemas 
Add Service.SelfServiceDataWarehouse and Serivce.KnowledgeDataWarehouse to module list

Note: This adds the Data Warehouse server instance listed above.

Switching Data Source

Production

Add two new switching schemas on the production server instance. Add ServiceSwitchingDataSource_read (online)

Switching Data Source

Agent

Add ServiceSwitchingDataSource_read (online) and ServiceSwitchingDataSource_production (offline)

Note: New modules are not required for switching data sources. However, two new initially identical Production switching schemas (in addition to the existing Production schema) are required on the Production server(s) for the deployed repositories. For both Agent and Production server instances, ServiceSwitchingDataSource_read points to the online data source and ServiceSwitchingDataSource
_production
points to the offline data source.

For data import, use ServiceSwitchingDataSourceA and ServiceSwitchingDataSourceB as the underlying data sources for the import.