• Success
    Manage your Success Plans and Engagements, gain key insights into your implementation journey, and collaborate with your CSMs
    Success
    Accelerate your Purchase to Value engaging with Informatica Architects for Customer Success
    All your Engagements at one place
  • Communities
    A collaborative platform to connect and grow with like-minded Informaticans across the globe
    Communities
    Connect and collaborate with Informatica experts and champions
    Have a question? Start a Discussion and get immediate answers you are looking for
    Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
  • Knowledge Center
    Troubleshooting documents, product guides, how to videos, best practices, and more
    Knowledge Center
    One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
    Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
    Information library of the latest product documents
    Best practices and use cases from the Implementation team
  • Learn
    Rich resources to help you leverage full capabilities of our products
    Learn
    Role-based training programs for the best ROI
    Get certified on Informatica products. Free, Foundation, or Professional
    Free and unlimited modules based on your expertise level and journey
    Self-guided, intuitive experience platform for outcome-focused product capabilities and use cases
  • Resources
    Library of content to help you leverage the best of Informatica products
    Resources
    Most popular webinars on product architecture, best practices, and more
    Product Availability Matrix statements of Informatica products
    Monthly support newsletter
    Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
    End of Life statements of Informatica products
Overview

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.
Pre-Requisites
Self-Service Resources
Goals
  • 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.  
Outcome
  • Comprehend the overall process involved in configuring the Microsoft SSIS Scanner and the metadata extracted
Required Roles/Personas
Required Roles/Personas
  • Architects
  • Developers
  • Data Analysts 
Actions
Add to Favorites
Engagement Details
Catalog Type

Ask An Expert

Engagement Category

Feature Clarity

Products

Enterprise Data Catalog

Engagement Type

Ask An Expert

Adoption Stage

Configure

Implement

Optimize

Focus Area

Adoption - Technical

Functional

Engagement ID

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.

Success

Link Copied to Clipboard