This server is responsible for the components that load data into the Oracle Commerce Platform data warehouse. Note that the data loaders must run on dedicated servers.
First, enable data collection on the loader server. This step is only necessary if you intend to pre-load data into the warehouse (see the “Preparing to Use Commerce Reporting” chapter of the Core Commerce Programming Guide for information). Create a <ATG11dir>/home/servers/
server_name
/
file and set the following content:
localconfig/atg/dynamo/service/DWDataCollectionConfig.properties
enabled=true
defaultRoot=path
to
log
file
directory
Next, configure the data sources for the data warehouse repository, production schema, and local loader machine. Create the following properties file in your loader server’s localconfig
directory:
/atg/reporting/datawarehouse/DirectJTDataSource.properties
$class=atg.nucleus.JNDIReference
JNDIName=JDNI
name
for
warehouse
datasource
/atg/dynamo/service/jdbc/DirectJTDataSource_production.properties
$class=atg.nucleus.JNDIReference
JNDIName=JDNI
name
for
production
datasource
/atg/dynamo/service/jdbc/DirectJTDataSource.properties
$class=atg.nucleus.JNDIReference
JNDIName=JDNI
name
for
local
datasource
/atg/dynamo/service/jdbc/DirectJTDataSource_agent.properties
$class=atg.nucleus.JNDIReference
JNDIName=JDNI
name
for
agent
datasource
/atg/dynamo/service/jdbc/DirectJTDataSource_management.properties
$class=atg.nucleus.JNDIReference
JNDIName=JDNI
name
for
management
datasource
Note that the DirectJTDataSource_agent
datasource is only required if you are using ATG Service applications.
The data loaders use a lock manager to ensure that only a single loader processing a given file. To configure your loader server as a lock management client, create the following files:
<ATG11dir>/home/servers/
server_name
/localconfig/atg/dynamo/service/
ClientLockManager.properties
<ATG11dir>/home/servers/
server_name
/localconfig/atg/dynamo/service/
ClientLockManager_production.properties
<ATG11dir>/home/servers/
server_name
/localconfig/atg/dynamo/service/
ClientLockManager_agent.properties
<ATG11dir>/home/servers/
server_name
/localconfig/atg/dynamo/service/
ClientLockManager_management.properties
Each of these files should include the following configuration:
lockServerAddress=lock
server
hostname
lockServerPort=lock
server
port
useLockServer=true