If you want to use reporting with your Search installation, perform the steps in this section after you have installed and configured Search Administration. The steps provided are for an Oracle database with JBoss as the application server, and assume that you have already installed ACI.
Add a data warehouse datasource for JBoss. To do this, add following text to the
<JBOSS_HOME>\server\atg\deploy\atg-search-ds.xmlfile just before the</datasources>tag, replacing the italic text with the correct information for your data warehouse database.<local-tx-datasource>
<jndi-name>name</jndi-name>
<connection-url>url</connection-url>
<driver-class>class</driver-class>
<user-name>your_dw_name</user-name>
<password>your_dw_password</password>
<min-pool-size>10</min-pool-size>
<max-pool-size>10</max-pool-size>
</local-tx-datasource>Configure your
<ATG2007.3Dir>/home/localconfig/atg/reporting/datawarehouse/JTDataSource.propertiesdatasource to point to the schema in which your data warehouse tables will be created.Configure
/atg/reporting/datawarehouse/loaders/JTDataSource.propertiesto point to your data warehouse loader tables.Make the following changes to the
<ATG2007.3Dir>\Search2007.3\SearchAdmin\datawarehouse\install\search-dw-env.bator.shfile:Note: This script imports data using
StartSQLRepository. Make sure yourJTDataSourceandFakeXADatasourceare configured to permit this.Add the following to the beginning of the file. For the value, use your
<ATG2007.3Dir>\homedirectory.set DYNAMO_HOME=valueChange the
DB_TYPEfromsolidto your database typeChange the
DB_USERandDB_PWDvalues to the correct values for your database.Change the
ORACLE_TNSvalue to the correct value for your database.
Run the
<ATG2007.3Dir>\Search2007.3\SearchAdmin\datawarehouse\install\all-create.batfile to create the database tables.
Create files with following folder structure and content on the server running your Search client application, such as your Commerce store:
/atg/dynamo/service/DWDataCollectionConfig.propertiesenabled=true
If you are using Search with Commerce, create files with following folder structure and content on the server running your Search client application:
/atg/commerce/search/ProductCatalogQueryFormHandlerrequestLogging=true/atg/commerce/search/ProductCatalogQueryFormHandlerenableReportData=true
Install the Search reports:
Go to
<ATG2007.3dir>\Search2007.3\SearchAdmin\datawarehouse\deployment.Copy
Search.zipto the<ATG2007.3dir>\ACI2007.3\c8\deploymentdirectory.Open the ATG Reporting Center and navigate to Tools > Content Administration.
Click the New Import link. The next screen lists the deployment archives that are available for importing.
Select
Search.zipand complete the import process, accepting all the defaults.Once the import is complete, you will see a folder called
ATGin the home page of the Reporting Center.
When you assemble your EAR file to include Search, include the following modules:
SearchAdmin.AdminUI SearchAdmin.Datawarehouse
