SQL Server Integration Services (SSIS)
SQL Server Integration Services (SSIS) is Microsoft's ETL platform for building data transformations and data integration solutions. Dataedo supports documenting the SSIS packages contained in ISPAC deployment project files, DTSX package files, and connecting to an SSIS server.
Supported elements and metadata
Packages will be imported as Packages in Dataedo. Tasks within a package will be imported as data processes in Data Lineage, so that the data lineage can be easily extended with data flows.
Sources and Destinations types of objects from SSIS which are in Data Flow are imported into Dataedo as Sources and Destinations.
SSIS Lookup elements are imported as Source objects with the Lookup subtype and include lineage.
If the source of the data is an SQL query then Dataedo parses that query, and based on that parsing a lineage is created.
Connections that are in Connection manager in SSIS Package will be imported into Dataedo as Linked Sources.
Linked source contains information about the connection such as server, host, etc.
If Dataedo detects that the database to which the connection relates was previously documented, it will assign the matching database to the Linked source.
More about Linked Sources in this article
Dataedo imports project connections and package connections
Automatic data lineage
Dataedo creates automatic SSIS lineage at both object and column level (including transformations such as Lookup and Derived Column).
Detailed scope, examples, supported tasks, and limitations are described here: SQL Server Integration Services (SSIS) - Automatic Data Lineage.
Specification
Imported metadata
Dataedo reads the following metadata from SSIS.
| Imported | Editable | |
|---|---|---|
| Packages | ✅ | ✅ |
| Control Flows as Processes | ✅ | ✅ |
| Column data lineage | ✅ | ✅ |
| Process description | ✅ | ✅ |
| Process script | ✅ | ✅ |
| Variables | ✅ | |
| Script | ✅ | |
| Description | ✅ | ✅ |
| Sources and Destinations | ✅ | ✅ |
| Data Lineage | ✅ | ✅ |
| Column data lineage | ✅ | ✅ |
| Process description | ✅ | ✅ |
| Process script | ✅ | ✅ |
| Script | ✅ | |
| Description | ✅ | ✅ |
| Shared metadata | ||
| Dependencies | ✅ | ✅ |
| Created time | ✅ | |
| Last updated time | ✅ |
