Sunday, December 4, 2016

#538 Leveraging the Eloqua REST API from ICS

This post shows you how to leverage the Eloqua REST api, using getContact as an example.Firstly, we test using Postman, then, we take what we have learned and implement a simple integration in ICS.

Test the REST

Here is a simple example of getting a contact from Eloqua -

The REST API doc for Contacts is here

The general REST API docs are there

First step is to get your base URL -


I execute this request in Postman -

Note: I use BasicAuth and the username has the format CompanyName\User.

Check out the "base" on line 15. Yes, I have obfuscated it somewhat.

Now I take this base url and add - /data/contact/{id}

Let's look at the contact in Eloqua, before executing the REST request -

Note the Eloqua Contact ID field value above.
I drop the leading CMK110000000000 - leaving me with id=16.

I use this value in the request -

and get the following response -

I save this response to a file - here is the format -

Create a new Eloqua REST connection in ICS

Note I use the base url from above here.
Username again in the format CompanyName\User.

Create a new integration in ICS

I then create the integration and drop this connection as an invoke -

I use the response file I saved here.

I now drop a REST adapter as Trigger -

I use the response file I saved here.

I do the mapping -

Request -

Response -

I set the Tracking -

I activate the integration and then test -

Also worth looking at is the A-Team blog post on Eloqua integration.

You can check it out here

Tuesday, November 29, 2016

#537 Leveraging the Eloqua Adapter in SOA CS

SOA CS setup

1. download the Eloqua certs and install on SOA CS via em

Note the 3 certs -

This reflects the following -

2. Create an entry for the EloquaKey you will be using in your SOA composite -

Create a new Map
Within that, create your EloquaKey -

3. amend to leverage the store -

Change the EXTRA_JAVA_PROPERTIES related to the trust store
Replace: •\server\lib\DemoTrust.jks 
with: -

Re-boot the SOA Server

Create a simple BPEL process that leverages the Eloqua adapter 

The BPEL process -

Deploy and test on SOA CS

Validate in Eloqua

#536 Creating an MFT Cloud Service Instance

Begin by creating the backup storage containers -

Start the MFT Service creation wizard -

Do a sanity test on the environment.

ssh into the MFT vm and create 2 directories
/in and /out

create a file in /in e.g. touch myReport.txt

Create a simple file2file integration -

Monitor -