NoSQL Components

NoSQL Components

Parse and analize data and addresses, connect to address verification services, detect differences and duplicates in datasets. Advanced SSIS components for reliable and efficient data integration with non-relational databases. The following are the NoSQL components available in the SSIS Productivity Pack and their respective help manuals:

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

• Couchbase Connection Manager
  • Facilitates establishing a connection to a Couchbase database from within SSIS.
• Couchbase Source Component
  • An SSIS data flow component to facilitate reading data from a Couchbase database.
    
• Couchbase Destination Component
  • An SSIS data flow component to facilitate writing data to a Couchbase database.
    

Firebase Components  New

• Firebase Connection Manager
  • Facilitates establishing a connection with an Firebase database from within SSIS.
• Firebase Source Component
  • An SSIS data flow component to facilitate reading data from an Firebase database.
    
• Firebase Destination Component
  • An SSIS data flow component to facilitate writing data to an Firebase database.

HBase Components  New

• HBase Connection Manager
  • Facilitates establishing a connection with an Apache HBase database from within SSIS.
• HBase Source Component
  • An SSIS data flow component to facilitate reading data from an Apache HBase database.
    
• HBase Destination Component
  • An SSIS data flow component to facilitate writing data to an Apache HBase database.

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