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


Download Help File Buy
View All Tasks

Featured Articles

ScreenshotsUseful LinksSystem Requirements

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

  • .net framework 3.5 or higher must be installed
  • SSIS Runtime: To execute SSIS package you will need one or more versions of SQL Server Integration Services 2005/2008/2008 R2/2012/2014 or 2016
  • To design SSIS 2012 package SSDT (VS 2010 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2014 package SSDT-BI (VS 2013 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2016 package SSDT-BI (VS 2015 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2005, 2008, 2008 R2 packages BIDS (VS 2005,2008 Shell – Business Intelligence Development Studio) must be installed.
  • Supported Client Operating Systems: Windows 7, Windows 8, Windows 8.1
  • Supported Server Operating Systems: Windows Server 2003/R2, Windows Server 2008/R2, Windows Server 2012/R2
Download View All Tasks Like This