Amazon S3

How to Use DBSync's Amazon Simple Storage Service (S3) Connector

Overview

The DBSync Amazon Simple Storage Service (S3) connector allows for seamless data transfer between local file systems and Amazon S3 cloud storage. It supports operations such as uploading and downloading files and directories, enhancing your data management capabilities.

Connector Configuration

Drag and Drop the S3 Connector

In the app configuration screen, drag and drop the 'Amazon S3' connector from the available connectors list.

Configure the S3 Connector

Click on the S3 connector to configure it. Fill in the required fields:

• 1. Authorization Type Select the authorization type as AccessKey.

  2. AWS Key Enter your AWS access key here. This key identifies your AWS account.

  3. AWS Secret Provide your AWS secret key here. This secret is associated with your AWS access key and should be kept confidential.

  4. AWS Region Specify the AWS Region where your Amazon S3 bucket resides. For example, us-east-1.

  5. AWS SSE Key (Optional) If you are using Server-Side Encryption (SSE), enter your AWS SSE Key here. This field is optional.

  6. Restrict to Bucket (Optional) You can restrict the connector to a specific Amazon S3 bucket by entering the bucket name. Leave it blank if no restriction is required.

  7. Restrict to Path (Optional) Optionally, enter a specific path within your bucket to further restrict access. Leave this blank to allow access to all paths in the bucket.

  Testing & Saving Connection

  • Click on Test Connection to validate the credentials and configuration.

  • If the connection is successful, click on Save Connection to save your settings.

Use Case

Automated Invoice Archival to Amazon S3

Problem: A business generates hundreds of invoice PDFs daily and stores them in a local folder. Over time, managing and backing up these files becomes difficult.

Solution using DBSync:

• Set up a File System connector to watch the invoice directory.

• Use the Amazon S3 connector to upload all files in that folder to a specified bucket daily.

• Schedule the process to run at the end of each day.

Outcome:

• Automated daily backups of critical files

• Improved data availability and disaster recovery

• Reduced manual effort in managing invoice archives

Uses of Amazon S3 Connector

• Scheduled Auto Backups: Automate backups and archives from file systems or databases to Amazon S3, reducing manual intervention.

• Improved File Sharing: Enhance file sharing capabilities between databases and Amazon S3.

PRO TIP

Use IAM roles with appropriate permissions for enhanced security when accessing your S3 buckets. This minimizes the risk of exposing your Access Key and Secret Key.

Frequently Asked Questions (FAQ)

1. What is Amazon S3?

Amazon Simple Storage Service (S3) is a scalable storage solution that allows users to store and retrieve any amount of data at any time from anywhere on the web.

2. Can I get a trial of the DBSync Amazon S3 connector?

Yes, DBSync offers a 15-day free trial after completing the signup process.

3. Can this connector be used for bi-directional integration?

Yes, the connector supports both bi-directional and uni-directional integrations.

4. How frequently can we perform Integration?

DBSync can trigger data integration as frequently as every three minutes.

Related Content

• Error Handling in Integrations: Learn how to troubleshoot and resolve common integration errors.

• Monitoring and Alerts Setup: Set up alerts to monitor your workflows proactively.

• Scheduler: By establishing a schedule, you can automate your workflows to run without manual intervention, allowing you to manage recurring tasks more efficiently.