Exporting contacts or accounts

Using the data export tool, you can export contacts, accounts, or activities one-time or on a regular basis. The export is made available via a link to an Oracle Eloqua hosted URL. You can also upload the export file to a Secure File Transfer Protocol (SFTP) server.

Note: The exported file is available at the Oracle Eloqua hosted URL for 14 days.

Before you begin:

  • Data export timeouts occur after 6 hours for contacts and after 1 hour for accounts.
  • Port 22 must be used for SFTP transfers to and transfers from Eloqua.
  • Oracle Eloqua uses Rebex SFTP for connecting to SFTP server. Please refer to the following Rebex documentation for a list of supported security algorithms.
  • If you want to export contact activities (like bouncebacks, clickthroughs, etc.), your administrator must set up Oracle Eloqua to capture the activity data to an internal queue. To do this, set up an external call to an internal queue. Then your administrator must configure what activities to capture. To set up the external call to an internal queue, log in to My Oracle Support and create a service request. See this knowledge base article about the internal queue and this knowledge base article about capturing activities for more information. After this configuration is complete, Oracle Eloqua will begin collecting the activity data going forward.
  • Data export will honor contact security based on the Eloqua user that creates the export. The Eloqua user that creates the export will now be added to the Data Export area. If you are using contact security, confirm that the user who creates the contact export has access to all required labels.

To export contacts, accounts, or activities:

  1. Navigate to Audience An image of the Audience icon. > Tools, then click Data Export and Import.
  2. Click the Data Export tab.
  3. Click Add An image of the Add button. .
  4. On the Export Settings tab, configure the export:
  5. Click the Data tab to configure the data to export.
  6. Click the Format tab and configure the format for the exported export file. You can change the file extension and the format of the file. The default format is "<columndata>","<columndata>","<columndata>".
  7. Click Save.

After you finish: To export now, click the Overview tab and click Run now. Otherwise, the export will run according to the schedule you specified on the Export Settings tab.

After the export runs, a link to download export is sent to the email address. The export is available from that link for 14 days.

If you delete the data export, all related export files are removed from the Oracle Eloqua hosted URL.

Learn more

Viewing the results of data imports or exports

SFTP troubleshooting

Setting up SSH keys