Export data to Amazon S3
Zoho DataPrep supports exporting data to Amazon S3
cloud storage service.
Amazon Simple Storage Service, also known as Amazon S3
from AWS
provides
object storage through a web service interface.
Important
Prior to connecting your Amazon S3 data with Zoho DataPrep, you need to enable the below permissions from your Amazon S3 account:
1. ListAllMyBuckets
2. Get BucketLocation
3. ListBucket
4. GetObject
Please refer to Amazon S3 help pages to provide these permissions.
To export data to Amazon S3
1. Click
the
Export now
option from the
Export
menu on the
DataPrep Studio page.
2. From the side pane, choose Cloud storage and select the Amazon S3 option.
3.
Provide the
Connection name,
Access key,
and
Secret key.
If you
have
added a connection
already, click the existing connection in the
Saved connections
section and start exporting data.
Note
: Click
the
Add new
link to add a new Amazon S3 account. You can create as many connections as required.
4. You will need to authenticate S3 when you try connecting to S3 for the first time. Click the
Authenticate Amazon S3
button to authenticate your account with your credentials.
Note
:
The connection configuration will be saved for
accessing data in
Amazon S3 in the future. Credentials are securely encrypted and stored.
5. Select the File format the data should be exported with.
6. Enter the Bucket name you want to export your data to.
7. Provide the
Folder path
where you want to export your data. If you choose to store the files in the bucket without any folder, you can leave this field empty.
8.
Select the required option from the
File export option.
You can choose to
Replace or update file
with a new version at the destination,
or
Add as new file
during export.
Note
: The file will be updated as a new version or replaced based on the versioning configuration in your Amazon S3 bucket.
9. Select the preferred Amazon S3 connection from the
Connection name
dropdown.
10. You can also click the Advanced options link for the following options.
10. You can also click the Advanced options link for the following options.
-
You can use a Row Separator such as UNIX (Line Feed) or MAC (Carriage Return) to ensure the line endings are translated properly.
-
You can distinguish the point at which the content of a text field begins and ends using Text qualifier s such as Single Quote(') or Double Quote(").
-
You can separate out the data or split using a Delimiter such as a Comma(,), Semicolon(;), or a Space.
-
Enable the Compress as a .zip file toggle to export your file as a .zip file.
-
You can also encrypt the file and protect it with a password using the Encrypt file and protect using password option.
11. Click Export. Once the export is complete, you can also
choose to schedule the export by clicking the
Configure schedule> link.
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Still can't find what you're looking for?
Write to us: support@zohoforms.com
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
Zoho SalesIQ Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Bigin?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
Related Articles
Export data to cloud storage services
You can export data to the following cloud storage services. Google Drive OneDrive Box Storage Dropbox Zoho WorkDrive Amazon S3 To export data to cloud storage services 1. Click the Export now option from the Export menu in the DataPrep Studio page. ...Import data from cloud storage services
DataPrep supports import from the following cloud storage services. Google Drive One Drive Box Storage Dropbox Zoho WorkDrive Amazon S3 To import data from a cloud storage service 1. Click Cloud Storage in the Choose a data source box. 2. Choose one ...Scheduling data export
You can schedule data export using different export configurations in DataPrep. To schedule data export Click Export from the top bar in the Studio page and select Schedule export. 2. Click the New schedule button to create a new schedule for export. ...Export data to Zoho WorkDrive
Zoho DataPrep supports exporting data to Zoho WorkDrive, a popular cloud storage service. Zoho WorkDrive allows you to store files and collaborate securely on the cloud. To export data to Zoho WorkDrive 1. Click the Export now option from the Export ...Import data from Amazon S3
Zoho DataPrep supports importing data from Amazon S3 cloud storage service. Amazon Simple Storage Service, also known as Amazon S3 from AWS provides object storage through a web service interface. Important Prior to connecting your Amazon S3 data ...