Editing Streams and Opportunity Detect XML files
If you select manual database set up when you install Opportunity Detect, you must complete the tasks in this section after you run the HCL® EMM and the Opportunity Detect installer.
Procedure
-
In the
InteractService/wlp/usr/servers/InteractService
directory under your Opportunity Detect installation, modify the server.xml file to reflect the following settings. Replace the values shown in the example with values appropriate for your environment.<dataSource id="OpDetectionDS" jndiName="OpDetectionDS"> <jdbcDriver libraryRef="DB2JCC4Lib"/> <properties.db2.jcc currentSchema="SCHEMA_NAME" databaseName="DB_name" password="encrypted_database_password" portNumber="port_number" serverName="server_name" user="database_user_name"/> </datasource>
Important: The schema name must be capital letters. -
If you are using DB2 for your system tables, and if you have installed the DB2 client in a
location that is different from the default location, you must update the
function.xml file as follows.
The function.xml file is located in the /home/streamsadmin/OpDetection/toolkits/unica_db_access/db.access/native.function directory.
-
Locate the following section in the file.
<library> <cmn:description></cmn:description> <cmn:managedLibrary> <cmn:lib>UnicaDatabaseAccessLib</cmn:lib> <cmn:lib>db2</cmn:lib> <cmn:libPath>../../impl/lib</cmn:libPath> <cmn:libPath>/IBM_DB2_installation_directory/lib64</cmn:libPath> <cmn:includePath>../../impl/include</cmn:includePath> <cmn:includePath>/IBM_DB2_installation_directory/include</ cmn:includePath> </cmn:managedLibrary> </library>
-
Correct the path in the following lines to reflect the location of your DB2 client. In the
following example, the DB2 install path is /data/dbclient/DB2.
<cmn:libPath>/data/dbclient/DB2/lib64</cmn:libPath>
<cmn:includePath>/data/dbclient/DB2/include</cmn:includePath>
-
Locate the following section in the file.
- Restart the Streams server.