Configuring the Data Warehouse Data Sources

Define the following components on the svcss, svcagent and searchadmin servers:

  1. Edit the localconfig/atg/reporting/service/ARFJTDataSource.properties file to contain the following:

    $class=atg.nucleus.JNDIReference
    JNDIName=java:/MSSQL_atgdwDS

  2. Edit the localconfig/atg/reporting/service/ARFIdGenerator.properties file to contain the following:

    $class=atg.service.idgen.SQLIdGenerator
    dataSource=/atg/reporting/datawarehouse/loaders/JTDataSource
    transactionManager=/atg/dynamo/transaction/TransactionManager
    XMLToolsFactory=/atg/dynamo/service/xml/XMLToolsFactory
    # all properties of type XMLFile *MUST* use an absolute
    # component path. Applications should append generally
    # append to this property.
    initialIdSpaces=/atg/reporting/service/arf_idspaces.xml
    tableName=arf_id_generator

  3. Edit the localconfig/atg/reporting/service/
    ARFClientLockManager.properties     files to contain the following:

    $class=atg.service.lockmanager.ClientLockManager
    lockServerAddress=localhost
    lockServerPort=9012
    useLockServer=true

  4. Edit the localconfig/atg/reporting/datawarehouse/
    JTDataSource.properties     to reference the following:

    $class=atg.nucleus.GenericReference
    componentPath=/atg/reporting/service/ARFJTDataSource

  5. Modify the localconfig/atg/reporting/datawarehouse/
    loaders/JTDataSource.properties     to reference the following:

    $class=atg.nucleus.GenericReference
    componentPath=/atg/reporting/service/ARFJTDataSource

  6. Modify the following repositories on the svcagent and searchadmin servers:

    localconfig/atg/reporting/datawarehouse/loaders/
    DataWarehouseLoaderRepository.properties
    localconfig/atg/reporting/datawarehouse/loaders/
    DataWarehouseExtractRepository.properties
    localconfig/atg/reporting/datawarehouse/loaders/
    WarehouseRepository.properties

    Edit each file to contain the following:

    dataSource=/atg/reporting/service/ARFJTDataSource
    idGenerator=/atg/reporting/service/ARFIdGenerator
    lockManager=/atg/reporting/service/ARFClientLockManager

  7. Configure the following files on the searchadmin server:

    localconfig/atg/assetregistry/AssetRegistry.properties
    localconfig/atg/svc/logging/SelfServiceLoggingRepository.properties
    localconfig/atg/svc/OfferRepository.properties
    localconfig/atg/svc/ServiceRepository.properties
    localconfig/atg/svc/shared/ServiceSharedRepository.properties
    localconfig/atg/ticketing/TicketingRepository.properties
    localconfig/atg/search/repository/
      IncrementalItemQueueRepository.properties
    localconfig/atg/search/repository/ConfigStatePerister.properties
    localconfig/atg/userprofiling/LogicalOrganizationRepository.properties

    Edit each file to contain the following:

    # /atg/svc/logging/SelfServiceLoggingRepository
    # ensure data and locking properties use production-side components
    dataSource=/atg/dynamo/service/jdbc/JTDataSource_production
    idGenerator=/atg/dynamo/service/IdGenerator_production
    lockManager=/atg/dynamo/service/ClientLockManager_production
    # ensure cache invalidation properties use production-side components
    eventServer=/atg/dynamo/server/SQLRepositoryEventServer_production
    subscriberRepository=/atg/dynamo/service/jdbc/SQLRepository_production

 
loading table of contents...