![]() SSIS DynamoDB DestinationAmazon 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
|
||||
|
View All Tasks |
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.](https://cdn.zappysys.com/onlinehelp/ssis-powerpack/scr/images/drag-and-drop-data-flow-task.png)
From the SSIS toolbox drag and drop Data Flow Task on the controlflow designer surface.
Create new Amazon DynamoDB connection
![Create SSIS Amazon Storage Connection for DynamoDB Create SSIS Amazon DynamoDB Connection - Choose Type](https://cdn.zappysys.com/onlinehelp/ssis-powerpack/scr/images/amazon-dynamodb-destination/ssis-aws-dynamodb-pick-connection-type.png)
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](https://cdn.zappysys.com/onlinehelp/ssis-powerpack/scr/images/amazon-dynamodb-destination/ssis-amazon-dynamodb-destination-configure-connection.png)
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](https://cdn.zappysys.com/onlinehelp/ssis-powerpack/scr/images/amazon-dynamodb-destination/ssis-amazon-dynamodb-destination-select-adapter-connection.png)
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](https://cdn.zappysys.com/onlinehelp/ssis-powerpack/scr/images/amazon-dynamodb-destination/ssis-amazon-dynamodb-destination-select-table.png)
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](https://cdn.zappysys.com/onlinehelp/ssis-powerpack/scr/images/amazon-dynamodb-destination/ssis-dynamodb-insert-json-documents.png)
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](https://cdn.zappysys.com/onlinehelp/ssis-powerpack/scr/images/amazon-dynamodb-destination/ssis-amazon-dynamodb-destination-select-mappings.png)
Configure SSIS Amazon DynamoDB Destination Adapter – Mapping Tab
Update DynamoDB Documents in SSIS Data Flow
![Update Amazon DynamoDB Documents](https://i0.wp.com/zappysys.com/blog/wp-content/uploads/2016/07/ssis-amazon-dynamodb-update-example.png?resize=768%2C474&ssl=1)
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](https://cdn.zappysys.com/onlinehelp/ssis-powerpack/scr/images/amazon-dynamodb-destination/ssis-dynamodb-write-data-sample.png)
Execute SSIS Amazon DynamoDB Destination Adapter – Load Data
Articles / Tutorials
How to Read / Write DynamoDB data in SSIS (Query, Insert, Update, Delete)
How to Read / Write Amazon DynamoDB in SSISIntroduction 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 […] |