Administer > Manage WebSphere Commerce features > Marketing > Collaborative filtering > WebSphere Commerce Recommendation Engine powered by LikeMinds > Background LikeMinds utilities
Test LikeMinds Personalization Server
After configuring WebSphere Commerce to use the LikeMinds Personalization Server, and publishing a sample store in WebSphere Commerce, you can test LikeMinds Personalization Server.
Procedure
- Register two different users with the sample store.
- For each user, browse the store catalog, add some items to the shopping cart, and then exit the store.
- On the LikeMinds Personalization Server machine, do the following:
If the SQL queries return the results described, your installation and configuration was successful.
- Start a DB2 command session or an Oracle SQL*Plus session, depending on the database management system used for the LikeMinds Personalization Server database.
- Connect to the LikeMinds Personalization Server database.
- Issue the following SQL query:
select * from lps_user_data where resource_id is not null;This query should show two new records for the two different users registered in the sample store earlier.
- Issue the following SQL query:
select * from lps_item_data where resource_id is not nullThis query should show new records inserted for the items that the users viewed in the catalog or added to their shopping carts.