Configure Web Surveys and get response in Siebel

Web Survey Deamon Installation and Configuration

 

Recently I got a chance to work on Siebel Marketing module and do a small poc on Web Surveys and saved its responses back to Siebel. Although its a common topic for developers who have experience in Siebel Marketing. But I find its really complex and worth sharing it with you guys..

Requirement:

1.) Customize and create surveys in Siebel
2.) After submitting, we can see responses in Siebel
3.) Send Survey URLs in email and tracks its click as well

Pre – Requisites:

1.) Siebel 16 Server (Doing this POC on 16, there are known issues with below versions. So, please do your research on Oracle support.)
2.) Install Java Development Kit 1.6 32 bit(lastest patch)

3.) Check if JRE 1.6 has also been installed. If not, then install it so that the Installation Wizard does not hang:
4.) And of course admin rightd on the server machine

Solution:

Step 1: WSD (Web Server Deomon) Installation

Step 2: Test Installation

Step 3: WSD Configuration

Step 4: Enable Marketing Components & Workflows

Step 5: Configure Web Surveys

Step 6: Test Web Surveys

Step 7 : Check Responses in Siebel

Possible Issues

WSD Installation:

Its all start with Web Server Deomon installation, a java application which install Tomcat Server on top of which Survey URL works..

  • Download WSD Installables
    – It comes with Siebel Marketing Server installables.
    – Else you can find here as a patch, go to Oracle Support > patches & updates and locate Patch Number: 24363906
  • Make sure that JDK 1.6 & JRE 1.6 installed correctly else installable hangs out
  • Now, go to the location where you unzipped WSD installer.
  • Right-click in the wsd-8112-632-install.exe file and select Properties
  • In the “Compatibility” tab, check mark “Run this program in compatibility mode for” and select: Windows XP (Service Pack 2)

  • Run the installer now – wsd-8112-632-install.exe
  • In the Java selection window, ensure you select the java.exe from Java Development Kit 1.6 you installed in step 4 above.
  • e.g: C:\Program Files (x86)\Java\jdk1.6.0_45\bin\java.exe
  • Continue until it completes.

Test Installation

  • Folder Structure should be like this

  • Hit the URL – http://192.168.2.10:8080 and observe the apache tomcat server page is displayed.

WSD Configuration

  • Create WSD User in Database and give privileges to create tables.
  • Execute the Sql Statement in WSD Folder.
  • Go to C:/Program Files/wsd/sql
  • Login as WSD User in oracle and run the communicatorOracle10g.sql.
  • go to C:\Program Files (x86)\wsd\webapps\websurveys\config and edit websurvey.properties file
 

Find more help here: https://docs.oracle.com/cd/E14004_01/books/MKTG_InstallAdmin/MKTG_InstallAdmin_WebMarketing7.html

 

Configure the Siebel Outbound web service

    • Navigate to Administration – Web services -> Outbound Web services screen.
    • Query for Name = WebSurveyWebService & Update the URL
 

Enable Marketing Server Components & Workflows

  • Navigate to Administration – Server Configuration screen > Enterprises > Component Groups view.
  • Enable below groups on your server
  •       CommMgmt, MktgOM, MktgSrv
  • Click the Synchronize view tab and click Synchronize.
  • go to Business Process -> Workflow Deployment and query for Group = Marketing
  • Select all and activate

Wait for more…..

@skmeSiebel

Leave a Reply

1 Comment on "Configure Web Surveys and get response in Siebel"

Notify of
avatar
Sort by:   newest | oldest | most voted
Domagoj Markovina
Guest

Great post – please keep it coming! Best Dom

wpDiscuz