Contribute in GitHub: Edit online

SSIS

SQL Server Integration Services (SSIS) is Microsoft’s visual tool for ETL (extract, transform, load) processes. It feeds sources like MS Office Excel tables and application backends into your data warehouse and can be used for data transformation between DWH layers.

IBM Manta Data Lineage can effortlessly link the sources, stage, core, and data marts by scanning SSIS — creating the most precise end-to-end data lineage the Microsoft SQL Server family can get.

Manta Data Lineage currently scans:

• Project deployment models

• Package deployment models

Check out the guides below for more details on setting up this scanner.

• SSIS Integration Requirements
• SSIS Scanner Guide
• SSIS Resource Configuration
• SSIS Manual Inputs

Extraction and Analysis Phase Scenarios

Extraction Phase

For the extraction phase for SQL Server Integration Services, there is only one scenario.

1. SSIS extractor scenario — connects to each configured SSIS server and extracts the configured packages and/or projects

Analysis Phase

For the analysis phase for SSIS server, there is only one scenario.

1. SSIS server dataflow scenario — harvests metadata and lineage from the extracted SSIS packages and projects and saves it in your Manta Data Lineage metadata repository