• Success
    Manage your Success Plans and Engagements, gain key insights into your implementation journey, and collaborate with your CSMs
    Success
    Success Accelerators
    Accelerate your Purchase to Value engaging with Informatica Architects for Customer Success
    My Engagements
    All your Engagements at one place
  • Communities
    A collaborative platform to connect and grow with like-minded Informaticans across the globe
    Communities
    Product Communities
    Connect and collaborate with Informatica experts and champions
    Discussions
    Have a question? Start a Discussion and get immediate answers you are looking for
    User Groups
    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
    Get Started
    Community Guidelines
  • Knowledge Center
    Troubleshooting documents, product guides, how to videos, best practices, and more
    Knowledge Center
    Knowledge Base
    One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
    Support TV
    Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
    Documentation
    Information library of the latest product documents
    Velocity (Best Practices)
    Best practices and use cases from the Implementation team
  • Learn
    Rich resources to help you leverage full capabilities of our products
    Learn
    Trainings
    Role-based training programs for the best ROI
    Certifications
    Get certified on Informatica products. Free, Foundation, or Professional
    Product Learning Paths
    Free and unlimited modules based on your expertise level and journey
    Experience Lounge
    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
    Tech Tuesdays Webinars
    Most popular webinars on product architecture, best practices, and more
    Product Availability Matrix
    Product Availability Matrix statements of Informatica products
    SupportFlash
    Monthly support newsletter
    Support Documents
    Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
    Product Lifecycle
    End of Life statements of Informatica products
    Ideas
    Events
    Change Request Tracking
    Marketplace
| Sign up
Overview

Informatica Advanced Scanners are designed to extract metadata from complex and varied data sources, including SQL scripts, ETL processes, BI tools, and more. These scanners provide deep insights into data lineage and impact analysis. 
We can scan SQL Scripts from Microsoft SQL Server and Oracle 

  • Microsoft SQL Server is a metadata source for Microsoft SQL Server scripts and Microsoft SQL Server stored procedures. In the Metadex tool, you can create and configure a metadata scanning job to extract metadata from both Microsoft SQL Server scripts and Microsoft SQL Server stored procedures.
  • Oracle is a metadata source for Oracle scripts, SQL Loader scripts, and stored procedures. Oracle Autonomous Database is a SaaS implementation of Oracle Database on the Oracle Cloud Infrastructure. In the Metadex tool, you can create and configure a metadata scanning job to extract metadata from Oracle scripts, SQL Loader scripts, and database objects, using their respective conversion paths.
Pre-Requisites

To organize the scanner files, we need to create a specific directory for the scanner and within that scanner directory, three sub-directories should be created. 

  • Input Directory – Where we need to upload/place the input file which contains stored procedure call statements. 
  • Output Directory – Here scanner will generate the output file which will be loaded into the catalog. 
  • Variables Directory – If the SQL scripts contain any variables, you can get the variable and its associated values then upload/place the file here. 

Get the connection details where these scripts are present and  

Enable the Procedure calls (SQL.ProcedureCalls) scanner option. By default, this option is set to false. 

Self-Service Resources
How to Create an Oracle Advanced PL/SQL Scanner with only Stored Procedure Calls in Metadex/Advanced Scanner
How to Scan SQL Stored Procedure in EDC Advance Scanner
How to Configure PL/SQL Advanced Scanner with Stored Procedure Calls in Metadex/Advanced Scanners
Goals
  • Understand how to configure PL/SQL Advance Scanner with Stored procedure calls in Metadex/Advance Scanner. 
  • Understand how to Extract metadata from Oracle SQL Loader scripts with the Oracle MetaDex scanner and load the metadata into the catalog.  
  • Understand how to Scan SQL Stored Procedure in EDC Advance Scanner 
Outcome
  • Understand overall process involved in scanning stored procedure from Oracle and SQL Server in Metadex. 
Required Roles/Personas
Required Roles/Personas
  • Architect/Administrator 
  • Developer 
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

Focus Area

Adoption - Technical

Functional

Engagement ID

AAE-EDC-004

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