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
Go to your Organizer Portal by clicking the Manage Organization found on the bottom left corner of any event admin console.
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:
After clicking connect, a pop-up would appear. Click New Authentication.
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
Click Finish.
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.
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.
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.























