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

The SSIS Productivity Pack currently includes components for data integration with Amazon DynamoDB, Apache Cassandra, CosmosDB, and, MongoDB non-relational databases. Below is the documentation for each set of components, three 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.

CosmosDB Components

  • CosmosDB Connection Manager
    • Facilitates establishing a connection to a CosmosDB database from within SSIS.
  • CosmosDB Source Component
    • An SSIS data flow component to facilitate reading data from a CosmosDB database. Includes the ability to use SQL commands which can then be modified to further filter the data to be retrieved by the component.
  • CosmosDB Destination Component
    • An SSIS data flow component to facilitate writing data to a CosmosDB database through Create, Upsert, Replace or Delete actions to work with CosmosDB documents or attachments.

Couchbase Components

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 through an 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.

Redis Components

  • Redis Connection Manager
    • An SSIS connection manager component that can be used to establish connections with Redis.
  • Redis Source Component
    • An SSIS data flow pipeline component that can be used to read/retrieve data from Redis.
  • Redis Destination Component
    • An SSIS data flow component that can be used to write data to Redis. You can Upsert and Delete records using this component.

Video Resources

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