Switching Data Source Configuration

The following configuration is for the optional switching data source add-on for ServiceSwitchingDataSourceA and ServiceSwitchingDataSourceB.

SQL Files

The following SQL scripts create the switching data source schema. You must run the scripts in the order they are listed.

  1. <ATG10dir>/Service10.1/Service/sql/install/vendor/
    service_framework_switching_all.sql

  2. <ATG10dir>/Service10.1/Service/sql/install/vendor/
    service_switch.sql

Run these scripts on both switching data source schemas.

If you are not using a switching data source in your installation, run these scripts on the production schema. See JTDataSource for Production Server Instance.

Data Imports

The following switching data source files are imported from the Service.common start up module:

Repository

Import File

/atg/svc/userprofiling/
ServiceSegmentRepository 

<ATG10dir>/Service10.1/Service/common/
data/initial/svc_segment_data.xml 

/atg/svc/option/
OptionRepository 

<ATG10dir>/Service10.1/Service/Framework/
data/initial/svc_option_data.xml 

/atg/svc/ServiceRepository 

<ATG10dir>/Service10.1/Service/common/
data/initial/svc_solution_data.xml

/atg/svc/OfferRepository 

<ATG10dir>/Service10.1/Service/common/
data/initial/svc_initial_data_shared.xml

/atg/userprofiling/
ProfileAdapterRepository 

<ATG10dir>/Service10.1/Service/common-pub/data/initial/svc_profile.xml 

Copyright © 1997, 2012 Oracle and/or its affiliates. All rights reserved. Legal Notices