Overview
SSIS Connector for Atlan automates the discovery, extraction, and cataloging of metadata and end-to-end data lineage from Microsoft SQL Server Integration Services (SSIS) packages into Atlan's data governance platform. The connector enables organizations to improve data discovery, governance, and impact analysis by automatically cataloging SSIS projects, packages, datasets, transformations, and column-level lineage.
Built on the Atlan Application SDK and orchestrated using Temporal workflows, the connector reads SSIS project files (.dtproj) and package files (.dtsx) stored in Azure Blob Storage. It parses control flows, data flows, tasks, containers, connection managers, and transformations, converting them into Atlan assets with detailed metadata and lineage relationships.
Key capabilities include:
Automatic discovery and parsing of .dtproj and .dtsx files stored in Azure Blob Storage. End-to-end metadata extraction for SSIS projects, packages, tasks, datasets, and transformations. Column-level lineage showing source-to-target data movement across SSIS pipelines. Support for multiple data sources, including SQL Server, Oracle, PostgreSQL, MySQL, Snowflake, Azure Data Lake Storage, Azure Blob Storage, and Flat Files. SQL dialect-aware lineage parsing for SQL Server, Oracle, PostgreSQL, Snowflake, and MySQL. Temporal workflow orchestration with automatic retries, heartbeat monitoring, and fault tolerance. OAuth 2.0 (Azure AD) authentication with secure token refresh for long-running extractions. Pre-extraction validation of authentication and connectivity. Resilient processing that continues extracting metadata even if individual SSIS packages encounter errors.
The connector provides a scalable and automated approach to ingesting SSIS metadata into Atlan, helping data engineers, data stewards, and governance teams improve data visibility, lineage, compliance, and impact analysis across enterprise data integration pipelines.
Highlights
- Full SSIS metadata & column-level lineage into Atlan - automatically. Parse .dtsx packages, extract all tasks, data flows, and connection managers, and push column-to-column lineage directly to Atlan's data catalog with zero manual effort.
- Supports 10+ source/target systems. Maps SSIS connection managers to Atlan asset types across SQL Server, Oracle, PostgreSQL, MySQL, Snowflake, ADLS, Azure Blob, and flat-file formats - delivering unified lineage in a single run.
- Temporal-orchestrated, production-ready workflows. Built on Atlan Application SDK with durable execution, automatic retries (3x with 2x backoff), OAuth token refresh, and preflight validation - reliable for large SSIS estates.
Details
Introducing multi-product solutions
You can now purchase comprehensive solutions tailored to use cases and industries.
Features and programs
Financing for AWS Marketplace purchases
Pricing
Dimension | Description | Cost/12 months |
|---|---|---|
connector | SSIS Connector | $30,000.00 |
Vendor refund policy
Refund requests accepted within 3 weeks of purchase.
How can we make this page better?
Legal
Vendor terms and conditions
Content disclaimer
Delivery details
Software as a Service (SaaS)
SaaS delivers cloud-based software applications directly to customers over the internet. You can access these applications through a subscription model. You will pay recurring monthly usage fees through your AWS bill, while AWS handles deployment and infrastructure management, ensuring scalability, reliability, and seamless integration with other AWS services.
Support
Vendor support
Please reach out to: customer_support@logandata.com
AWS infrastructure support
AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.
Similar products
