Alation is the leader in enterprise data intelligence solutions. Alation offers products in Data Catalog and Data Governance. It empowers their customers to find, understand and govern the data. Alation has developed broad range of native data source connectors. It offers Open Connector Framework (OCF) SDK to connect to any additional data sources apart from their own prebuilt connectors.

Logan Data had developed a Custom Connectors from Informatica to Alation. It is an unidirectional Connector. The connector will enable the customers to extract meta data information from ETL jobs/workflows. This will enhance the lineage information available to increase ability to trust the data and gives visibility into downstream impacts.

  • Informatica OCF connector uses REST APIs to fetch the metadata from Informatica Cloud:

      • Mapping of Informatica jobs to Alation metadata as below
        • Informatica Job to Alation data source Schema
        • Informatica sources and targets to Alation tables
        • Informatica Data source/target columns to Alation data source columns
  • Alation customer will be able to search for Informatica tables, columns, connection properties in Alation data catalog

  • Table level lineage to understand data flows in Alation data catalog