Siebel Integration with Oracle BI for loading Leads, Responses and synchronizing Customers

Most often Siebel Marketing and Oracle BI will be used to load campaign members for a marketing campaign based on Segment criteria defined within Oracle BI:


The Siebel Campaign Membership is then loaded based on the defined Load List Format with Type “Campaign Load”:


Once the Marketing Users clicks the Campaign Load Button the below Siebel Workflow is executed and triggers the generation of a File (csv) that is loaded by the Workflow into the Siebel Campaign Membership:


This Workflow also only exists for loading Contacts and not for Accounts. Even for Accounts (Companies) this Workflow requires at least one Contact within the Account.

However, the Standard (BI Applications additionally offers to load other Entities than the Campaign Membership:

(Described within the Official Bookshelf Documentation.)

This allows to:

  1. Load/Synchronize Customers into Siebel from other Sources e.g. to load Prospects which have been bought from 3rd Parties.
  2. Load Leads and Responses into Siebel

For this, the following standard Workflows exist:


E.g. for creating Leads the Workflow:


The Workflows also triggers the generation of a File (csv) by Oracle BI which is being loaded into the respective Siebel Entity e.g. Lead.

This provides Users with the possibility to define criteria that qualify a lead for a specific Campaign. If these criteria (expressed as Segment criteria) are being fulfilled, a Lead will be created within Siebel. A Segment to qualify a Lead based on e.g.Campaign Responses could look like the following:


The Workflow “Marketing Create Leads” then loads the Marketing Lead Integration Object (described above), which has the following definition:

Component Description
Lead Defines all the primary attributes of the entity lead.

User Key: Id

Lead Organization Defines the Organization attributes associated with the lead.

User Key: Organization Id

Lead Position Defines attributes of Position associated with the lead.

User Key: Position Id

Lead Product Defines attributes of Products associated with the lead.

User Key: Product Id

Using the following Load List Format of Oracle BI:

Table Heading Column Heading Column Formula
Lead Id ‘NOID’
Lead Lead Status ‘@{leadStatus}{}’
Lead Treatment Id ‘@{treatmentID}{}’
Lead Description ‘@{description}{}’
Lead Contact Id – Contact Profile.”Contact Id”
Lead Prospect Id – Contact Profile.”Prospect Id”
Lead Account Id – Contact Profile.”Account Id”
Lead Source Id ‘@{campaignID}{}’
Lead Division Owner ‘@{divisionID}{}’
Lead Quality ‘@{leadQuality}{}’
Lead Lead Score ‘@{score}{}’
Lead Primary Partner Id ‘@{partnerID}{}’
Lead Calc Lookback Days ‘@{leadLookbackDays}{}’
Lead Calc Product Id ‘@{productID}{}’
Lead Product Product Id ‘@{productID}{}’
Lead Position Position Id ‘@{positionID}{}’

And the corresponding standard Load List definition of Oracle BI:


Instead of being of Type “Campaign Load” the above Standard Load List is of Type “BI Data Load”. To synchronize customer data another Load List Type is available “Customer Synchronization”.

A Marketing User can configure all this steps during design-time of a Marketing Campaign with the Program flow:


By selecting:

1) Select the Load List Format for loading Leads from BI into the Marketing Lead Integration Object.


Only Load List of Type “BI Data Load” are available for a Marketing User.

2) specifying the stored segment (created beforehand) to evaluate/qualify a Lead based on certain Campaign Responses given by the Campaign Participants.


To summarize. Siebel Marketing offers not only the possibility to load Campaign Members into the Campaign Membership (S_CAMP_CON Table) but also Responses or Leads via standard Marketing Workflows and Load Lists provided out-of-the-box.

1 thought on “Siebel Integration with Oracle BI for loading Leads, Responses and synchronizing Customers

  1. Pingback: Siebel Integration with Oracle BI for loading Leads, Responses and synchronizing Customers | SutoCom Solutions

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.