Configuring WebSphere Commerce to interact with LikeMinds

To enable WebSphere Commerce Server to access the LikeMinds database configure WebSphere Commerce in WebSphere Application Server. LikeMinds cannot be installed in WebSphere Commerce Developer.

About this task

The configuration script performs the following tasks:

Creates a LikeMinds datasource
Configures WebSphere Commerce to access the LikeMinds datasource
Tests the LikeMinds datasource
Enables the LikeMinds component within WebSphere Commerce

Procedure

Navigate to the following directory:
- /WC_profiledir/bin
- \WC_profiledir\bin
Launch the wsadmin shell using the following command:
- ```
wsadmin.sh -f setupLikeMindsConnection.jacl NodeName WCServerName 
    JDBCProviderName DbType JDBCDriver 
    DatasourceName DataBaseName DataBaseUser 
    DataBasePassword DataBaseServer DataBasePort
```
- ```
wsadmin.bat -f WC_installdir/bin/setupLikeMindsConnection.jacl NodeName 
    WCServerName JDBCProviderName DbType 
    JDBCDriver DatasourceName DataBaseName 
    DataBaseUser DataBasePassword DataBaseServer DataBasePort
```
Where:
NodeName

The WebSphere Application Server node name.

ServerName

The name of the WebSphere Commerce server to configure.

JDBCProviderName

The name to of the JDBC provider associated with the LikeMinds Personalization Server.

DbType
The type of database to use. This must be one of:
- db2
- db2_iseries_toolbox
- db2_iseries_native
- oracle
JDBCDriver

The fully qualified path of the JDBC driver. This should be the same JDBC driver.
Note: Windows users must use forward slashes '/' to denote path structures, instead of backslashes '\'.

DatasourceName

The name of the LikeMinds datasource. This should be the same LikeMinds datasource.

DataBaseName

The name of the LikeMinds database.

DataBaseUser

The ID to use to connect to the LikeMinds database.

DataBasePassword

The password associated with the ID.

DataBaseServer

Required: The name of the server on which the database resides.

DataBasePort

Required: The port number used during database creation. If a port number was not used during database creation, a port number of 50000 should be used if the DbType is db2 or 1521 should be used if the DbType is oracle.
For example:
```
./wsadmin.sh -f /usr/WebSphere/CommerceServer70/bin/setupLikeMindsConnection.jacl WC_demo_node server1 "demo - WebSphere Commerce JDBC Provider" 
db2 "/opt/IBM/db2/V9.5/java/db2jcc.jar" "WCS LikeMinds Data Source" dbName dbUser dbPassword DatabaseServername 50000 
```
```
wsadmin.bat -f c:/WebSphere/CommerceServer70/bin/setupLikeMindsConnection.jacl WC_demo_node server1 "demo - WebSphere Commerce JDBC Provider" 
oracle "C:/oracle/product/11.1.0/db_1/jdbc/lib/ojdbc6.jar" "WCS LikeMinds Data Source" dbName dbUser dbPassword DatabaseServername 1521 
```