SSIS DynamoDB Destination Adapter - NoSQL Connector

SSIS DynamoDB Destination

Amazon DynamoDB Destination can be used to bulk insert large amount of records to Amazon DynamoDB storage from any data source using SSIS. Amazon DynamoDB is a cloud based NoSQL data storage service from Amazon AWS

Features
See also
Custom SSIS Components - Amazon DynamoDB Source(AWS DynamoDB Read) Amazon DynamoDB Source
SSIS Amazon DynamoDB ExecuteSQL Task Amazon DynamoDB ExecuteSQL Task
Custom SSIS Components - Amazon S3 Task (AWS S3) Amazon S3 Task
Custom SSIS Components - Amazon Redshift Data Transfer Task (AWS Redshift) Amazon Redshift Data Transfer Task
Custom SSIS Components - JSON Source (File and REST API Connector) JSON Source Connector (File, REST API)
Custom SSIS Components - JSON Generator Transform JSON Generator Transform
Download Help File Buy View All Tasks
ScreenshotsUseful LinksSystem Requirements

From the SSIS toolbox drag and drop Data Flow Task on the control flow designer surface.

From the SSIS toolbox drag and drop Data Flow Task on the controlflow designer surface.

From the SSIS toolbox drag and drop Data Flow Task on the controlflow designer surface.

Create new Amazon DynamoDB connection

Create SSIS Amazon DynamoDB Connection - Choose Type

Create SSIS Amazon Storage Connection for DynamoDB

Configure Amazon Storage Connection for DynamoDB

Configure SSIS Amazon DynamoDB Destination Connection

Configure SSIS Amazon DynamoDB Destination Connection

Select Amazon Storage Connection

Configure SSIS Amazon DynamoDB Destination Adapter - Connection Tab

Configure SSIS Amazon DynamoDB Destination Adapter – Connection Tab

Configure Amazon DynamoDB Target settings

Configure SSIS Amazon DynamoDB Destination Adapter - Component Tab

Configure SSIS Amazon DynamoDB Destination Adapter – Component Tab

 

Insert nested JSON documents to Amazon DynamoDB from multiple inputs

Amazon DynamoDB Data Load - Inserting Raw JSON Document

Amazon DynamoDB Data Load – Inserting Raw JSON Document

Simple Mapping Mode (Map Individual Columns rather than Raw JSON document Load)

Configure SSIS Amazon DynamoDB Destination Adapter - Mapping Tab

Configure SSIS Amazon DynamoDB Destination Adapter – Mapping Tab

Update DynamoDB Documents in SSIS Data Flow

Update Amazon DynamoDB Documents

Update Amazon DynamoDB Documents

Loading data into Amazon DynamoDB in SSIS Data Flow

Execute SSIS Amazon DynamoDB Destination Adapter - Load Data

Execute SSIS Amazon DynamoDB Destination Adapter – Load Data

Articles / Tutorials


How to Read / Write Amazon DynamoDB in SSIS

How to Read / Write Amazon DynamoDB in SSIS

Introduction In this article we will look at how to Read / Write Amazon DynamoDB in SSIS. ZappySys developed many AWS related components but in this article we will look at 3 Tasks/Components for DynamoDB Integration Scenarios (Read, Write, Update, Bulk Insert, Create / Drop Table etc.). We will discuss how to use SSIS DynamoDB Source Connector […]

 

Amazon AWS DynamoDB Destination FAQs

Click here to learn more about System Requirements
Download View All Tasks Like This