Easily integrate MongoDB NoSQL databases with any other application, relational or non-relational database.
SSIS Productivity Pack is a large collection of premium and unique SSIS components to help make SSIS more powerful and a developer's job easier. The collection contains 3 components to facilitate data integration between MongoDB and virtually any other application or database system. These components allow developers to work with the complex non-relational data structure within SSIS as easily as if it were column data.
The following are the 3 components available within the SSIS Productivity Pack to help facilitate your MongoDB integrations:
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.