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.
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.
- 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
- Understand overall process involved in scanning stored procedure from Oracle and SQL Server in Metadex.
- Architect/Administrator
- Developer
Ask An Expert
Feature Clarity
Enterprise Data Catalog
Ask An Expert
Configure
Implement
Adoption - Technical
Functional
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.