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 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
  • 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

  • .net framework 3.5 or higher must be installed
  • SSIS Runtime: To execute SSIS package you will need one or more versions of SQL Server Integration Services 2005/2008/2008 R2/2012/2014 or 2016
  • To design SSIS 2012 package SSDT (VS 2010 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2014 package SSDT-BI (VS 2013 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2016 package SSDT-BI (VS 2015 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2005, 2008, 2008 R2 packages BIDS (VS 2005,2008 Shell – Business Intelligence Development Studio) must be installed.
  • Supported Client Operating Systems: Windows 7, Windows 8, Windows 8.1
  • Supported Server Operating Systems: Windows Server 2003/R2, Windows Server 2008/R2, Windows Server 2012/R2
Download View All Tasks Like This