Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformation solutions. It is part of the Microsoft SQL Server suite and is used for extracting data from various sources, transforming it as needed, and loading it into other databases or data warehouse systems.
In Enterprise Data Catalog (EDC) 10.5.0, Informatica has introduced a new version of the SSIS scanner to be able to better support the SSIS metadata extraction in the long term.
This new version is based on Advanced scanner technology and has the following capabilities:
- You can extract SSIS metadata from the following types of input such as Data flows and Control flows.
- Generates asset types such as folder, package, data task, and script.
- We can view the following lineage:
- Summary and transformation-level lineage.
- Data lineage at the data set level & data element level.
- Control lineage at the data set level & data element level.
- Embedded SQL & SQL task.
- Stored procedure calls and defined project-level parameters.
- EDC Version should be higher or equal to 10.5.0.1.
- Basic knowledge of Enterprise Data Catalog (EDC) and Advanced Scanner (Metadex) tool
- Advanced Scanner application installed and configured and accessed user to the Metadex project to create configuration and run jobs.
- License including the “SSIS_CONNECTOR”.
- Understand and gain knowledge on the configuration of the Microsoft SSIS in EDC Advanced Scanner.
- Understand the prerequisites and permissions for configuring Microsoft SSIS Scanner
- Understand the objects and metadata extracted.
- Comprehend the overall process involved in configuring the Microsoft SSIS Scanner and the metadata extracted
- Architects
- Developers
- Data Analysts
Ask An Expert
Feature Clarity
Enterprise Data Catalog
Ask An Expert
Configure
Implement
Optimize
Adoption - Technical
Functional
AAE-EDC-003
Disclaimer
- All the topics covered in the Success Accelerators/Ask An Expert sessions are intended for guidance and advisory only. This is implicit and it will not be called out under the scope of each engagement.
- Customers need to include their relevant technical/business team members highlighted in each engagement topic to derive the best out of each engagement.
- Customers need to perform any hands-on work by themselves leveraging the guidance from these engagements.
- Customers need to work with Informatica Global Customer Support for any product bugs/issues and troubleshooting.