Help Center
  • Home
  • Getting Started
    • Register with oAuth
    • Register with Email + Password
  • Formulas
    • Formulas
  • Migration Templates
    • Migration Templates
    • Setting up the Template
    • Magic ID
    • Running the Template
  • seeding
    • Summary
    • Data Types
    • Configuration
  • Jobs
    • Job Management
    • Migrate
    • Multi-Object
    • Upload
    • Mapping
    • Query
    • Preview
    • History
    • Retry
    • Rollback
    • Run Remaining
    • Wildcard Names
  • Formatting
    • Dataimporter Formatting
    • Replace Null Values
    • Deduplicate
    • Filter Data
    • Sample Data
    • Automation Control
  • Schedule
    • Schedule
    • Hour
    • Day
    • Month
    • Flow
  • Integrations
    • View Integrations
    • Database
      • Azure SQL Database
      • Heroku Postgres
      • MySQL
      • PostgreSQL
      • SQL Server
    • Storage
      • Dropbox
      • Google Drive
      • Google Sheets
      • OneDrive
      • S3
      • SFTP
      • SharePoint
  • Account Management
    • Billing
    • Access
    • Teams
    • Notifications
  • Security
    • Dataimporter Security
    • IP Addresses
    • Data Storage
    • Customer Managed Storage
    • Single Sign-On with Azure AD
    • Single Sign-On with Okta
    • Bring your own Key
  • Changelog
Powered by GitBook
On this page
  • Configuration
  • Connect to S3 Bucket via IAM Role
  • Import
  • Export
  1. Integrations
  2. Storage

S3

PreviousOneDriveNextSFTP

Last updated 1 year ago

Configuration

You may need to whitelist the Dataimporter

You will need to enter the following information to create an S3 Integration:

Name URL Bucket Key Secret Key

or

AWS Role ARN

Connect to S3 Bucket via IAM Role

  1. Create a new IAM Role in AWS choosing the AWS Account Trusted entity type, and enter the Dataimporter AWS Account number 293026123612 into Another AWS Account:

  1. Give the permissions necessary to the S3 Bucket that you want to use.

  2. Give the Role a name e.g. DataimporterS3Role

  3. Once the Role is created, go to the Role, and take note of the ARN:

  1. Provide the ARN to Dataimporter who will configure and confirm access has been correctly granted.

Import

On the Upload screen you can enter the Path to the file that you want to Import, as well as the Salesforce Object that you want to Import into.

You also have to option to Rename the file after it has been processed as shown here:

This can be used for auditing, so that you can look in the S3 Bucket to see which files have been processed, as well as to make sure the same file is not processed twice.

Export

On the Upload screen you can enter the Path to the file that will be exported, as well as the Salesforce Object that you want to export from.

You can use to select dynamic files

Wildcard Filenames
IP Addresses