Integration Siebel Marketing & Eloqua

Oracles acquisition of Eloqua provides very different possibilities to Marketing Users compared with the classical Marketing solution of Siebel. While Siebel Marketing historically focused on classical offline Campaign channels such as direct mail or phone with enhancements over the Years e.g. e-mail or landing pages, Eloqua is native digital Marketing Solution having support for Channels like Facebook. Hence, there is no Oracle Roadmap or statement of direction to replace Siebel Marketing functionality with Eloqua, but rather a model of co-existence where Siebel Marketing should be used for classical Marketing and Eloqua for digital Marketing.

image

A analyst article highlighting the features for Eloqua can be found here.
Both products allow to define the target group of the Campaign via a Segmentation designer:
Eloqua vs. Siebel Segmentation

Customers already having Siebel Marketing can use the following process to integrate Siebel Marketing with the Oracle Marketing Cloud (Eloqua). This allows to use the same segments and same customer data to define a target group and execute Campaigns in  digital channels provided by Eloqua.
process

Since Siebel Marketing itself uses the Oracle Business Intelligence Server to access the Segmentation data, the same interfaces/process may be used from Eloqua for accessing the same data. The Oracle Business Intelligence Server offers a web service API described in a previous post which can also be invoked by Eloqua e.g. to use a previously defined Segment in Siebel Marketing.

To integrate Siebel with Eloqua (Step “Load Segments to Eloqua”) the Oracle BI Server can generate the Members of a segment based on segment criteria definition using the writeListFiles SOAP call. The definition of this SOAP call is described with the xsd:
image

Below is an example of this call using the Oracle BI Action framework to demonstrate the outside call and passing of parameters:
image

The format of the generated file that contains the target group members of the Segment can be defined using the Load List format:
image

The generated file can then be loaded into Eloqua as the Campaign members.

To summarize: Eloqua may be integrated with Siebel Marketing and can access Segment’s defined with Siebel Marketing and access the same data as Siebel Marketing. Eloqua can use the same APIs that are also used by Siebel Marketing provided by Oracle BI to generate a list of campaign members and load these members as target group into a Campaign in Eloqua for executing a campaign in digital channels.

Further information can be found here:

Advertisements

API for Oracle BI using SOAP

One feature that highlights the enterprise grade of Oracle BI (OBIEE) Server is the ability to not only interact with the web interface but also to use the Application program Interface (API) to automate certain tasks.

Oracle BI provides a list of API Methods which can be invoked using SOAP. The List of available methods can be viewed using the following URL within your installation:

https://*crm-test.i.*****.com/analytics/saw.dll?WSDL

This lists a description of methods e.g. WriteListFiles to export a Report to a file system location :
image

The methods available as API are also documented in the official Bookshelf: https://docs.oracle.com/cd/E28280_01/bi.1111/e16364/methods.htm#BIEIT180
and here: https://docs.oracle.com/cd/E12096_01/books/AnyWebServ/AnyWebServ_Overview3.html

Some more Marketing specific WebServices are described here:
https://docs.oracle.com/cd/E12852_01/v11113/mktgseg/mktgseg_configsegserver11.html