The data extraction utility for IBM Product Recommendations, formerly
known as Coremetrics Intelligent Offer invokes
the Catalog services to retrieve service data objects for the CatalogEntry
noun. When you make a service call, you must specify an access profile
to define the amount of data that you want the server to return. The
data extraction utility uses a default access profile, IBM_Admin_DataExtract.
To return non-attribute-dictionary attributes, you must create an
access profile in a query template file.
Before you begin
Review the following topics to learn more
about query template files and access profiles:
You can also review the default query template file that the
data extraction utility uses at the following path:
workspace_dir\WC\xml\config\com.ibm.commerce.catalog-fep\wc-query-CatalogEntry-admin-get-fep.tpl
About this task
The code for the custom query template file is provided for
you in the steps of the procedure.
Procedure
- Open
WebSphere Commerce Developer and switch to the Enterprise Explorer
view.
- Create a custom Get query template file to extract the
non-attribute-dictionary attributes:
- Create a workspace_dir\WC\xml\config\com.ibm.commerce.catalog-ext folder,
if one does not exist.
- Right-click the com.ibm.commerce.catalog-ext folder.
- Click .
- Name the custom query template file by using this syntax:
wc-query-name_of_your_custom_template.tpl
For example:
wc-query-DataExtract-ABCcompany-NonAttrDict-get.tpl
- Click Finish.
- Paste the following query template file contents into the
empty custom query template you created in the previous step:
BEGIN_PROFILE
name=MyCompany_Admin_DataExtract_Nonattributedictionary_Attributes
extends = IBM_Admin_DataExtract
BEGIN_ENTITY
className=com.ibm.commerce.catalog.facade.server.services.dataaccess.graphbuilderservice.CatalogEntryGraphComposer
associated_sql_statement=IBM_CatalogEntryAttributeSchema
associated_sql_statement=IBM_AttributeAllowedValue
associated_sql_statement=IBM_CatalogEntryAttributeValue
associated_sql_statement=IBM_AttributeSchema
END_ENTITY
END_PROFILE
This query template file defines a new
MyCompany_Admin_DataExtract_Nonattributedictionary_Attributes
access
profile that extends the default
IBM_Admin_DataExtract
access profile
that is provided with the data extraction utility. The associated
SQL statements that are defined in the file retrieve the non-attribute-dictionary
attributes from the respective database tables. These associated SQL
statements exist in the default query template file that the data
extraction utility uses (
wc-query-CatalogEntry-admin-get-fep.tpl),
but the statements must be redefined in this custom query template
file.
- Save and close the new query template file.
- Deploy
the query template file to the WebSphere Application Server.