Data Integration Made Easy
Writing Data to Cassandra Using SSIS
Configure Cassandra as your destination directly within your SSIS data flow using KingswaySoft components.
Choose Your Target Table
Start by selecting the Cassandra table where the data should be inserted or updated as part of your ETL workflow.
Map Source Columns to Destination Fields
Use the column mapping interface to assign input fields to the correct Cassandra columns, ensuring accurate field-level data movement.
Validate Data Types
Confirm each field mapping matches expected data types such as int, bigint, datetime, boolean, or uniqueidentifier for schema consistency.
Complete the Configuration
Apply final settings using toolbar options like auto-mapping, clearing fields, or refreshing metadata before running your SSIS data flow task.
No More Complex Coding
Integration Solutions for NoSQL Platforms
The components offer support for dynamic columns, batch operations, and native handling of non-relational data types. They're well-suited for integrating data collected from applications, services, or logs into broader data pipelines.
Our NoSQL components are designed to work with document-based and wide-column databases such as Cassandra and MongoDB. These tools help manage data with flexible structures, allowing developers to handle records that don't follow a fixed schema, accommodate varying fields across entries, and maintain reliable performance in high-throughput, distributed environments.
Work with Unstructured Data
Access NoSQL connectors through the SSIS Productivity Pack
to build integrations for non-relational data workflows.
Supported
NoSQL Databases
Amazon DynamoDB
Apache Cassandra
Azure Table
Cosmos DB
HBase
Couchbase
Elasticsearch
Google Firestore
MongoDB
Redis
Built to Handle NoSQL Complexity
Compare KingswaySoft's purpose-built components with traditional ETL approaches to non-relational data
| Capabilities | Traditional ETL Tools | KingswaySoft NoSQL Components |
|---|---|---|
| Schema Handling | Often assumes fixed schemas or requires coding to adapt | Supports dynamic column mapping with metadata discovery |
| Write Operations | Insert or update only; upsert typically requires custom scripts | Insert, Update, Upsert, Full Sync, or Custom Command options |
| Large Data Support | Can experience performance issues on high-volume writes | Supports batching and optimized configurations for performance |
| Nested Structures | Requires flattening or preprocessing to work with nested fields | Supports reading and writing nested document structures |
| Metadata Stability | Schema changes can break SSIS metadata and downstream tasks | Better metadata preservation to reduce rework after structure changes |
Familiar UI
A performant and flexible ETL platform
Our solution is built utilizing Microsoft SQL Server Integration Services (SSIS), allowing your team to take advantage of the technologies and skills they already have. The drag-and-drop user interface makes it easy to set up powerful integrations within a matter of minutes.
More Resources
Download our Data Sheet for
SSIS Productivity Pack
