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 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
  • Articles/Tutorials: Amazon DynamoDB related articles
See also
Custom SSIS Components - Amazon DynamoDB Destination (AWS DynamoDB Bulk Insert/Delete) Amazon DynamoDB Destination
SSIS Amazon DynamoDB ExecuteSQL Task Amazon DynamoDB ExecuteSQL Task
Custom SSIS Components - Amazon S3 Task (AWS S3) Amazon S3 Task
Custom SSIS Components - Amazon Redshift Data Transfer Task (AWS Redshift) Amazon Redshift Data Transfer Task
Custom SSIS Components - JSON Source (File and REST API Connector) JSON Source Connector (File, REST API)
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 […]

Amazon AWS DynamoDB Source FAQs

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