Watson Campaign Automation Ideas

Submit new product ideas for Watson Campaign Automation, Watson Real-time Personalization, Watson Content Hub and Universal Behavior Exchange. Before you submit, please review existing ideas; if an idea close to yours already exists, it's better to add comments or vote on the existing idea. We will review your ideas and use them to help prioritize our product development. Best of all, the portal will automatically update you when the status of your idea has been changed.

Connect with your peers and IBM experts on the Watson Marketing and Commerce Community

Submit ideas for other Watson Customer Engagement Products:

•  Other Watson Marketing solutions
Watson Commerce
Watson Supply Chain

Dont lock the table when there is add_only operation

Currently when IBM Unica campaign uploading the contacts to WCA for email send, customer is using sync keys. So the records will be always unique  and in campaign, they also choose the option "Create new contact list for every run" in the email process box(campaign).

There is a defect logged with campaign to send the contact upload with "ADD_ONLY" option. According to WCA L3, add_only helps improve performance compare to add and update. Once the campaign fix sending contact upload with add only option, there is still room for improvement in WCA side.

Currently WCA locks the table whenever there is an add_only or add_and_update. I totally understand that we need to lock the table when there is a ADD_AND_UPDATE, to prevent data corruption/data integrity. However in this customer scenario, all the jobs will be send as ADD_ONLY and all the records will be added and no update. In this case, WCA should not lock the table and allow parallel processing of inserts into the table. This will not cause any data issue as all the records will be unique.

Once we have both the campaign(Defect) and WCA(Enhancement) is available, our hope is performance will be much better as the majority of the time is spent on waiting rather than execution of the job.

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Oct 12 2018
  • Needs review
How will this idea be used?

Improve performance.

What is your industry? Banking
What is the idea priority? Urgent
DeveloperWorks ID
Link to original RFE
  • Attach files