Query/Read data from Amazon DynamoDB Table, Write JSON documents into DynamoDB

Learn how to Create/Drop Amazon DynamoDB Table, How to Query DynamoDB Table, Read, Write JSON documents in bulk. Visit http://zappysys.com/products/ssis-powerpack/ssis-dynamodb-source/

================================
This video covers
================================
◾How to create/drop AWS DynamoDB Table in SSIS
◾How to load JSON documents into Amazon DynamoDB using SSIS Connector
◾How to read/query DynamoDB data using SSIS Connector
How to extract inner array and output data as JSON

================================
SSIS Amazon DynamoDB Source
================================
Amazon DynamoDB Source can be used to extract large amount of data from Amazon DynamoDB. This component supports SQL like query language to query DynamoDB data without worrying about complex API. Amazon DynamoDB is a cloud based NoSQL data storage service from Amazon AWS
http://zappysys.com/products/ssis-powerpack/ssis-dynamodb-source/

Features
◾Bulk extract/output Amazon DynamoDB data
◾Support for SQL Like queries using proprietary Query engine, no need to learn complex AWS APIs
◾Complete JSON support such as extract data from inner array using JSON Path
◾Support for extracting raw JSON documents from DynamoDB
◾Support for both SCAN and QUERY Mode available in DynamoDB
◾Support for data preview
◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
================================
SSIS Amazon 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
http://zappysys.com/products/ssis-powerpack/ssis-dynamodb-source/
Features
◾Bulk load data to Amazon DynamoDB Table
◾Bulk Delete support
◾Support for loading raw JSON documents rather than mapping each column
◾Support for multi threaded parallel load
◾Interact and write data like a normal table, no need to learn complex APIs
◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)

================================
SSIS Amazon DynamoDB ExecuteSQL Task
================================

Amazon DynamoDB ExecuteSQL Task can be used to execute ad-hoc commands for Amazon DynamoDB (e.g. DDL statements such as Create/Drop collection, DML statements such as Insert, Update, Delete or Run JavaScript and shell commands.)
http://zappysys.com/products/ssis-powerpack/ssis-amazon-dynamodb-executesql-task/

Features
◾Intuitive user interface with many examples makes DynamoDB learning super easy and fast
◾Support for executing DDL statements such as Create/Drop table
◾Support for executing DML statements such as Select/Insert/Update/Delete
◾Support for saving RawResult (e.g. JSON response) into SSIS variable
◾Support for saving SingleValue from response such as count or size from getStats function response.
◾Support for saving FullResultset as ADO.net dataset (e.g. select * from mytable) can be stored as ADO.net recordset (can be used with ForEachLoop container task for looping).