The following components are SSIS components which facilitate data integration with NoSQL databases.

The SSIS Productivity Pack currently includes components for data integration with MongoDB, Apache Cassandra, and Amazon DynamoDB non-relational databases. Below is the documentation for each set of components, 3 for each NoSQL database.

Amazon DynamoDB Components

  • Amazon DynamoDB Connection Manager
    • Facilitates connecting for an Amazon DynamoDB database from within SSIS.
  • Amazon DynamoDB Source Component
    • An SSIS data flow component developers may use to retrieve data from an Amazon DynamoDB database. Includes the ability to output data to JSON format as well as the option to add key field filtering.
  • Amazon DynamoDB Destination Component
    • An SSIS data flow component developers can utilize to write data to an Amazon DynamoDB database. Developers can select to write data to the database using Insert, Update, Upsert, or Delete write actions.

Apache Cassandra Components

  • Cassandra Connection Manager
    • Facilitates establishing a connection to an Apache Cassandra database from within SSIS.
  • Cassandra Source Component
    • An SSIS data flow component to facilitate reading data from an Apache Cassandra database. Includes the ability to generate CQL commands which can then be modified to further filter the data to be retrieved by the component.
  • Cassandra Destination Component
    • An SSIS data flow component to facilitate writing data to an Apache Cassandra database through Insert, Update, Upsert or Delete actions. Includes an Async mode which will significantly increase performance by performing multiple requests simultaneously.

MongoDB Components

  • MongoDB Connection Manager
    • Facilitates the connection to a MongoDB server from within SSIS.
  • MongoDB Source Component
    • An SSIS data flow component to facilitate retrieving data from a MongoDB server. Features the ability to add a MongoDB filter string to filter the documents returned as well as a columns page to easily select or deselect the attributes you need to work with in your downstream pipeline.
  • MongoDB Destination Component
    • An SSIS data flow component to facilitate writing data to a MongoDB server though a Insert, Replace, Update or Delete action, with the option to use Upsert on Replace and Update actions. Easy visual mapping allows developers to write the data from upstream pipeline to the appropriate MongoDB field.

Youtube Video - Getting started with SSIS Productivity Pack - DynamoDB

Youtube Video - Getting started with SSIS Productivity Pack - Cassandra

Youtube Video - Getting started with SSIS Productivity Pack - MongoDB