Your Guide For Marketing Technology and Automation

How To Set Up an Auto Sync To Feed Into a Custom Object in Eloqua

Eloqua

If you have ever set up a Custom Object in Eloqua you may have the need to have it automatically updated from a file on an SFTP site. This is how you do that.

First, navigate to your Custom Object and from the “Custom Object” drop down menu select “Upload Custom Object Record.”¬†

Eloqua Auto Sync

Once selected, this will open the Custom Object Record Upload Wizard which you may have used before just to upload a static file. To set this up to automatically pull a file over SFTP though just simply select “Remote File over SFTP” from the Source of Custom Object Record data. Also on this screen you give your Upload process a name so in this below example we called it “Upload Sample Custom Object.” Once that is filled out just click the Next button to do to the next step.

Eloqua Auto Sync

Next, select what type of file format you will be uploading and the SFTP info for that file. In our example below we will be uploading a CSV file called FinanceSheet.csv (that just contains Email Address, First Name, and Last Name) from an SFTP site so we put in all the appropriate information. Once the info is added you click the “Upload and Preview Data” link and that will display what is in the current file. If it looks good, click the Next button to go to the next step.

Eloqua Auto Sync

On the next screen you just simply map the fields from your file to the fields on the Custom Object.

Eloqua Auto Sync

Next you just define your upload actions. For our example we are going to map the data cards to records on the contact table and use the Email Address as the Entity Field.

Eloqua Auto Sync

The next tab it takes us to is just a summary of all of our selections. Here you can click the option to “Schedule automatic data imports using these settings” which we will want to do so we can have this run daily.

Eloqua Auto Sync

Once finished you can navigate to Settings and then click on Integration. Then click on the Inbound tab and then select the drop down next to Management and select Auto Syncs and you should see your newly created auto sync listed.

Eloqua Auto Sync

Now your Custom Object is all set to be automatically updated on your chosen frequency by automatically pulling in the file on your SFTP site.

If you have any questions or comments, just let us know.

NEWS    ———————————
Create A Cookie Consent Form For Your Website
MarTech

Create A Cookie Consent Form For Your Website

Understanding Cookie Consent Forms on Websites: Balancing Privacy and User Experience In today’s digital landscape, where the internet plays an

Reduce Zapier Task Usage With Code By Zapier
Eloqua

Reduce Zapier Task Usage With Code By Zapier

Reduce Zapier Task Usage Zapier, a powerful automation tool, allows individuals and businesses to connect different apps and create automated

POPULAR PRODUCTS¬† ——————

Leave a Reply

About MarTech Hero

MarTechHero.com is your source to find out info on Marketing Technology with an emphasis on using Eloqua for your marketing automation.

Scroll to top