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 supports both:

• Project deployment models

• Package deployment models

and for each analyzes the following types of SSIS Tasks:

• SQL Task

• Bulk Insert Task

• File System Task

• Dataflow Task

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

2. IBM Manta Data Lineage supports Git Ingest connections from version 42.4, for the download of files from a Git repository to the SSIS workflow. For more information, see Manta Flow Agent Configuration for Extraction:Git Source

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