SSIS Amazon DynamoDB Integration Pack

SSIS Amazon DynamoDB Integration Pack is your complete toolset to automate DynamoDB integration scenarios in SSIS. Using simple drag and drop interface you can read data from DynamoDB or Bulk insert/update data into DynamoDB. You can also execute any valid DynamoDB API commands inside SSIS (e.g. Create Table/ Drop Table/Get Count). It includes DynamoDB Source Connector, DynamoDB Destination Connector and DynamoDB ExecuteSQL Task.

Features

Bulk extract/output Amazon DynamoDB data
Support for SQL Like queries using proprietary Query engine, no need to learn complex AWS APIs
Support for both SCAN and QUERY Mode available in DynamoDB
Bulk insert data into Amazon DynamoDB Table
Bulk delete data from Amazon DynamoDB Table
Support for loading Raw JSON documents from any source or generated by JSON Generator Transform
Interact and write data like a normal table, no need to learn complex APIs
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 SQL Server 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
Articles/Tutorials: Amazon DynamoDB related articles

Download

Buy

View All Tasks

SSIS Amazon DynamoDB Source (Query/Read/Extract)

SSIS 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.

Go to top

SSIS Amazon DynamoDB Destination (Bulk Insert, Delete)

SSIS Amazon DynamoDB Destination can be used to bulk insert/delete large amount of records to Amazon DynamoDB storage from any data source using SSIS.

Go to top

SSIS Amazon DynamoDB ExecuteSQL Task

SSIS 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.)

Download View All Tasks