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

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

SSIS Amazon DynamoDB Source Connector – Query DynamoDB using SQL language

Amazon DynamoDB Source – Read from Table

SSIS 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

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

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

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

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

SSIS Amazon DynamoDB Source Connector – Extract data from DynamoDB

Articles / Tutorials

Click here to see all articles for [SSIS Amazon DynamoDB Src] category


How to Read / Write Amazon DynamoDB in SSIS

How to Read / Write Amazon DynamoDB in SSIS

Introduction In this article we will look at how to Read / Write Amazon DynamoDB in SSIS. ZappySys developed many AWS related components but in this article we will look at 3 Tasks/Components for DynamoDB Integration Scenarios (Read, Write, Update, Bulk Insert, Create / Drop Table etc.). We will discuss how to use SSIS DynamoDB Source Connector […]

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