Read and write Azure Cosmos DB databases, containers, and documents in SSIS with API Source + API Destination.

SSIS Cosmos DB Connector is built on the ZappySys API Connector framework so you can configure API key authentication, select endpoints, preview records, and push inserts or updates from one visual ETL workflow.
Part of ZappySys SSIS PowerPack (100+ connectors & tasks).

Recommended starting point

View Setup Guide & Get Started →

See features, UI & examples →

Pro Tip: Use read-only keys for extraction jobs and read-write keys only where package flows must create, update, or upsert documents.

Compatibility: SQL Server 2012-2025+ (32/64-bit) | Azure Data Factory / Azure-SSIS IR Ready

⚡ Key Benefits

Bidirectional Integration — Read and write Cosmos DB data in one SSIS pipeline
No-Code API Access — Use connector templates instead of custom REST signatures
Cosmos Endpoint Coverage — Work with databases, tables/containers, users, and documents
Fast Onboarding — Configure API key auth and preview data in a few clicks
Production-Ready ETL — Chain with Upsert Destination and scheduling for repeatable jobs

📸 Visual Overview & Setup

1. Drag API Source onto Data Flow 🔍 View Full Size	2. Drag API Destination onto Data Flow 🔍 View Full Size	3. Select Cosmos DB Connector 🔍 View Full Size
4. Map the Columns 🔍 View Full Size	5. Source — Select Endpoint & Preview 🔍 View Full Size	6. Destination Mapping & Execute 🔍 View Full Size

🔧 Key Features

Read and Write Endpoint Support

Query databases, tables/containers, users, and documents with API Source
Create, update, upsert, or delete documents with API Destination
Use generic REST endpoints for advanced Cosmos DB request scenarios

Authentication and Security

API Key authentication with primary or secondary key support
Support for read-only and read-write key operational patterns
Explicit account and default database/table settings for safer execution

Operational Control

Visual endpoint selection, parameter input, and data preview before run
Easy integration with Upsert Destination for SQL Server/PostgreSQL/Redshift loads
Deploy to SQL Agent or Azure Data Factory for scheduled execution

💡 Common Use Cases

Document lake ingestion: Pull Cosmos DB collections into SQL-based analytics layers.
Master data sync: Push curated records from relational systems into Cosmos DB containers.
Bi-directional ETL: Extract data, transform in SSIS, and write back changed records.
Operational API automation: Manage users, permissions, and document lifecycle endpoints.
Cloud-ready orchestration: Run the same SSIS package on-prem or on Azure-SSIS IR.

🎯 Summary

Integrate Azure Cosmos DB with SSIS using drag-and-drop source and destination components.
Use one connector model for extraction, transformation, and write-back workflows without custom API coding.

Trusted by Developers & IT Teams Worldwide

Built for SSIS Workflows: Designed for production ETL and integration operations.
Expert Technical Support: Guidance for connector setup, auth, and endpoint design.
Proven Enterprise Scale: Adopted by thousands of organizations across 90+ countries.

SSIS PowerPack

Includes SSIS Cosmos DB Connector