SSIS DynamoDB Source Adapter - NoSQL Connector

SSIS 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

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 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
  • Articles/Tutorials:¬†Amazon¬†DynamoDB related articles
Download Help File Buy
View All Tasks
ScreenshotsUseful LinksSystem Requirements

Amazon DynamoDB Source – Configure Connection

SSIS Amazon DynamoDB Source Connector General Settings

Amazon DynamoDB Source – Query DynamoDB using SQL language

SSIS Amazon DynamoDB Source Connector - Query DynamoDB using SQL language

Amazon DynamoDB Source – Read from Table

SSIS Amazon DynamoDB Source - Read from Table

Amazon DynamoDB Source – Select Columns

SSIS Amazon DynamoDB Source Connector - Select Columns

Amazon DynamoDB Source – Read from nested array using JSON Path

SSIS Amazon DynamoDB Source Connector - Read from nested array using JSON Path

Amazon DynamoDB Source – Advanced JSON Filter Options

SSIS Amazon DynamoDB Source Connector - Advanced JSON Filter Options

Amazon DynamoDB Source – Extract RAW JSON documents

SSIS Amazon DynamoDB Source Connector - Amazon DynamoDB Source - Extract RAW JSON documents

Amazon DynamoDB Source – Extract data from DynamoDB

SSIS Amazon DynamoDB Source Connector - Extract data from DynamoDB

Click here to learn more about System Requirements
Download View All Tasks Like This