Enterprise Data Catalog : 2019 : May Skip navigation
2019

In EDC 10.2.2, Informatica has introduced a scanner for workday.

 

Here is a video presenting the details of the workday metadata scanner

 

https://informatica.zoom.us/recording/share/NlSXcir78Zp42S8adiopXJ8qgfFjhUiUsPQE0IHP7FiwIumekTziMw

What's new in EDC 10.2.2 is capture in this meet the experts webinar that you can watch following this link.

 

Meet the Experts – EDC 10.2.2 Release Deep-Dive & Demo

When it comes to extracting metadata from different systems, it can become very complex as each system has its own way to store and offer metadata. Often data store system type offer a way to access the data via JDBC, but JDBC drivers functionality implementation may vary and not all function necessary for metadata extraction are always implmented.

 

The EDC JDBC scanner expect a certain number of functions to be implemented and those needs to be in a certain so that metadata can be extracted in bulk (use of getColumns method without specifying table name for example)

 

In order to workaround some limitation of certain JDBC drivers, there is a possibility to extract the metadata by using the JDBC driver available feature and bring the extracted metadata into the catalog via custom scanner.

 

Below is a link to an example of such metadata extractor that has been tested for Denodo.

 

Custom-Scanners/JDBC_Scanner at master · Informatica-EIC/Custom-Scanners · GitHub

 

this can easily be extended to other systems that are not yet ceritified with EDC such as AWS Athena, Alibaba Max Compute, etc. by providing the right JDBC driver and understanding what JDBC method is available with the driver.