Skip to main content

Configure the Integration to Import Event Data from Oracle Eloqua

Written by Ariane Ramirez
Updated yesterday

Oracle Eloqua to Accelevents Integration

Getting more data from your attendees has never been more important. With our built-in Oracle Eloqua integration, you can have attendees register for the event through an Oracle Eloqua Form and have the data automatically appear in Accelevents as orders.

Connect the Integration

  1. Go to your Organizer Portal by clicking the Manage Organization found on the bottom left corner of any event admin console.

  2. Go to the Integrations tab and click Connect under the Oracle Eloqua to begin.

    For Enterprise and White Label plans, the Integrations tab will be in your Enterprise or White Label Dashboard. Click My Enterprise from the Organizer Portal to take you to your Enterprise or White Label Dashboard, where you should find the Integrations tab.

    You can also access the direct Enterprise or White Label Dashboard URL to see the Integrations tab. The URL would look something like this:

  3. After clicking connect, a pop-up would appear. Click New Authentication.

  4. A window within the pop-up will appear. You will need to enter the following details from your Oracle Eloqua account and click Create.

    • Site Name - this is the company name you enter when logging in to Oracle Eloqua

    • Base URL - this is the URL you access when you're logged in to Oracle Eloqua

    • Username

    • Password

  5. Click Finish.

  6. After clicking Finish, return to the Integrations tab and wait for the integration to enable. The green button under Oracle Eloqua will turn red once enabled and connected.

  7. Copy the Webhook URL

    After connecting the integration, a Webhook URL will be generated, you'll need to copy this and paste it in your Oracle Eloqua form settings. This will trigger the data export to Accelevents.

    • Click Edit from the Oracle Eloqua Tile

    • Click Next from the pop-up

    • Copy the Eloqua to Accelevents Public URL (webhook)

    • Click Finish

At this point of the integration, any new registrations done through Accelevents will be exported to Oracle Eloqua. You can do a test registration, but it's not required. Since the goal is to import contacts from Oracle Eloqua to Accelevents, please continue with the next steps.


Map the Contact and Form Fields to Import to Accelevents

To map fields, this can be done in you're admin console's Settings > Integrations > Oracle Eloqua Configure button

Map Accelevents Questions and Contact Fields (optional)

By default, the attendee's Email, First Name, and Last Name are the fields that will be imported from Oracle Eloqua to Accelevents. If you want to include other contact information in the data transfer, you can map those fields in the Configure Oracle Eloqua Mapping menu.

Looping the Order Information to Oracle Eloqua (optional)

If you want some order information to automatically appear in the Oracle Eloqua contact record after the order is created, you can map these information in the Configure Oracle Eloqua Mapping menu:

  • Order ID

  • Ticket ID

  • Ticket Type (this is the ticket name)

  • Magic Link

  • Barcode ID

  • Event Name


Get Your Event API Key and Ticket Type ID in Accelevents

The API Key and the Ticket Type ID will determine to which event the attendee must be registered and which ticket type to assign to them. You'll need to copy this and add it to your Oracle Eloqua Form later.

  • Go to Settings > Integrations in your event's admin console

  • Enable Tray Integration

  • Select the Ticket Type from the dropdown

  • Copy both keys generated

    • API Key is the one on top

    • Ticket Type Id is the one below


Add the API Key and Ticket Type ID fields to Your Form

If you're registering attendees through an Oracle Eloqua Form, you'll need to add 2 hidden fields in the form with default values for the API Key and Ticket Type ID. These fields are essential because the information inputted in those fields will determine to which event they will be registered to and which ticket type will be assigned to them. The API Key will determine to which event the attendee must be registered and the Ticket Type ID will determine which ticket to assign to the attendee.

  • Open your form for editing in Assets > Forms

  • Drag 2 hidden fields to the template

  • For API Key:

    • Change the Label to API Key

    • Change the HTML Name to apiKey

    • Add the API Key you copied from Accelevents to the Static Value field

    • Change the Maximum characters to 255

  • For Ticket Type ID:

    • Change the Label to Ticket Type ID

    • Change the HTML Name to ticketType

    • Add the Ticket Type ID you copied from Accelevents to the Static Value field


Add the Webhook URL to Your Form

1. Append the Webhook URL

Before adding the Webhook URL, you'll need to append it to include the API Key. At the end of the URL add ?apiKey= followed by the API Key.

In our example, the Webhook URL is:

https://8520a7e3-d282-4e51-8f0a-cd732085e8de.trayapp.io

And the API Key is:

46db0940-8630-4efe-9960-c5e202c8255d

🟒 The appended Webhook URL should look like this:

https://8520a7e3-d282-4e51-8f0a-cd732085e8de.trayapp.io?apiKey=46db0940-8630-4efe-9960-c5e202c8255d

2. Go to Processing

After appending, click Processing in your form template.

3. Add Post Data to Server

Click the + button and select Post Data to Server

4. Add the appended Webhook URL

Click the Post Data Server, then add the appended Webhook URL to the field next to Constant Value. Click Save when done.

5. Map the Form Fields and Contact Fields

The data that will be imported from Oracle Eloqua to Accelevents are coming from contact fields, not the form fields. So if you want the values entered in the form to carry over to Accelevents, you need to map the form fields to contact fields in your form settings.

In the Processing tab, click Update Contact - With Form Data

The Source Field column are your form fields and the Target Field column are your contact fields. Make sure that the fields are mapped so the data will flow to Accelevents.

Test the Import

To test if the integration will import registrations from your Oracle Eloqua form to Accelevents, embed you form to your website and submit a test registration.

Check the Attendees > Orders tab in your Accelevents Admin Console. The new submission should appear there.


Edit the Integration

If you want to edit the existing integration, click Edit from the integrations page, and it will take you back to the step where it asks you to click "New Authentication" (step 3).


Disconnect the Integration

If you want to uninstall the integration, click the red Disable button, then click the 3 dot menu in the Oracle Eloqua tile on the integrations page within Accelevents, then click Uninstall. Once it's disconnected, you can connect an Oracle Eloqua account from scratch.

Note: If the integration is disconnected, the existing attendees/contacts will remain in your account. However, if any updates are done to the record, it will only reflect where the update is done.


Disable the Integration for a Specific Event

If you don't want a specific event integrated with Oracle Eloqua, open the admin console for that event, navigate to Settings > Integrations, and turn off the toggle next to Oracle Eloqua.

Did this answer your question?