SSIS Amazon DynamoDB Integration Pack

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 2022, 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)

Amazon DynamoDB Source 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. 

Read more

SSIS Amazon DynamoDB Destination (Bulk Insert, Delete)

Amazon DynamoDB Destination 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. 

Read more

SSIS Amazon DynamoDB ExecuteSQL Task

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

Read more

 

Download View All Tasks