Learn how to CreateDrop Amazon DynamoDB Table, How to Query DynamoDB Table, Read, Write JSON documents in bulk. Visit br br ================================ br This video covers br ================================ br ◾How to createdrop AWS DynamoDB Table in SSIS br ◾How to load JSON documents into Amazon DynamoDB using SSIS Connector br ◾How to readquery DynamoDB data using SSIS Connector br How to extract inner array and output data as JSON br br ================================ br SSIS Amazon DynamoDB Source br ================================ br 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 br br br Features br ◾Bulk extractoutput Amazon DynamoDB data br ◾Support for SQL Like queries using proprietary Query engine, no need to learn complex AWS APIs br ◾Complete JSON support such as extract data from inner array using JSON Path br ◾Support for extracting raw JSON documents from DynamoDB br ◾Support for both SCAN and QUERY Mode available in DynamoDB br ◾Support for data preview br ◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit) br ================================ br SSIS Amazon DynamoDB Destination br ================================ br 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 br br Features br ◾Bulk load data to Amazon DynamoDB Table br ◾Bulk Delete support br ◾Support for loading raw JSON documents rather than mapping each column br ◾Support for multi threaded parallel load br ◾Interact and write data like a normal table, no need to learn complex APIs br ◾Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit) br br ================================ br SSIS Amazon DynamoDB ExecuteSQL Task br ================================ br br Amazon DynamoDB ExecuteSQL Task can be used to execute ad-hoc commands for Amazon DynamoDB (e.g. DDL statements such as CreateDrop collection, DML statements such as Insert, Update, Delete or Run JavaScript and shell commands.) br br br Features br ◾Intuitive user interface with many examples makes DynamoDB learning super easy and fast br ◾Support for executing DDL statements such as CreateDrop table br ◾Support for executing DML statements such as SelectInsertUpdateDelete br ◾Support for saving RawResult (e.g. JSON response) into SSIS variable br ◾Support for saving SingleValue from response such as count or size from getStats function response. br ◾Support for saving FullResultset as ADO.net dataset (e.g.