Integrations for metadata ingestion into Collibra

Download a Template and Request a Trial License

REPORTING AND ANALYTICS

Tableau Integration

The Collibra-Tableau integration template helps load the Tableau assets into Collibra DGC. The Tableau REST APIs are used to pull in the Tableau assets like Workbook, Dashboard, Worksheet, Story, etc. and the relations supporting them. The asset extraction can be filtered based on specific Site, Project or Workbook. The template execution can be scheduled or triggered on-demand via Mule or a custom workflow. The template can also push the definitions back to the Tableau workbook as hover help/tooltip.

For more information, please download the datasheet and view the Tableau template demo and Tableau writeback demo

Cognos Integration

 Lucid’s Collibra-Cognos metadata integration template helps load IBM Cognos metadata into Collibra DGC. Metadata for Cognos reports/models and the relations supporting them are read using the APIs from Cognos SDK. The asset extraction can be filtered based on the Cognos server, specific content manager folder path and model name. The metadata for Powerplay Transformer Cubes are read from. mdl files. The Report layout is also parsed to get the metadata for the layout, report attributes and sort. The template execution can be scheduled or triggered on-demand via Mule or a custom workflow. Custom workflows are also available to push definitions from Collibra back to the Cognos Framework manager model as Description or Screen tip.

For more information, please download the datasheet and view the Cognos Template demo video.

RDBMS/DB Appliance

Netezza Integration

The Collibra Netezza Integration template helps load the Netezza Metadata assets into Collibra DGC. Metadata of Netezza assets are extracted using the Query from Netezza Database. The assets extraction can be filtered based on Database and Schema. The template execution can be scheduled or triggered on-demand via Mule.

For more information, please download the datasheet

SQL Server Integration

This loads SQL Server assets into Collibra DGC. The assets extraction can be filtered based on Host, Database or Schema. The template execution can be scheduled or triggered on-demand via Mule or a custom workflow.

For more information, please download the datasheet

Oracle Integration

This loads Oracle assets into Collibra DGC. The assets extraction can be filtered based on Host, Database or Schema. The template execution can be scheduled or triggered on-demand via Mule or a custom workflow.

For more information, please download the datasheet

PostgreSQL Integration

This loads PostgreSQL assets into Collibra DGC. The assets extraction can be filtered based on Host, Database or Schema. The template execution can be scheduled or triggered on-demand via Mule or a custom workflow.

For more information, please download the datasheet

MySQL Integration

This loads MySQL assets into Collibra DGC. The assets extraction can be filtered based on Host, Database or Schema. The template execution can be scheduled or triggered on-demand via Mule or a custom workflow.

For more information, please download the datasheet

Teradata Integration

This loads Teradata assets into Collibra DGC. The assets extraction can be filtered based on Host, Database or Schema. The template execution can be scheduled or triggered on-demand via Mule or a custom workflow.

For more information, please download the datasheet

SAP HANA Integration

Lucid’s Collibra-SAP HANA metadata integration template loads the SAP HANA catalog and information view metadata into Collibra DGC. The XML definitions from the catalog tables in SAP HANA are parsed to extract the SAP HANA objects like the Information views (Calculation views, Analytic views, Attribute views) etc. and the relations supporting them. The asset extraction can be filtered based on Host, Database, Schema (for Catalog), Package (for Content). Dependencies across all views including nested views are extracted into DGC. Column Level Lineage from Information Views (through multiple levels of dependencies) to HANA Catalog Base Tables/Views with transformation logic is enabled.

For more information, please download the datasheet and view the demo.

DATA GOVERNANCE TOOLS

IBM InfoSphere Information Governance Catalog

IBM IGC REST APIs are used to pull in different asset families – Relational Database Assets, File Assets, Mappings and BI Reports and load into DGC.
They are mapped to Relational Database Assets, File Assets, Mapping Specifications and Reports in DGC. There are different filters for each asset family.

For more information, please download the datasheet

ETL TOOLS

Informatica PowerCenter

The Collibra-Informatica Powercenter integration template loads the Informatica Powercenter assets into Collibra DGC. Repository tables are used to fetch the relevant metadata about Mappings, Sources, Targets, Lookups, Expressions etc. and the relations supporting them. A custom repository on PostgresSQL would be needed to hold the metadata before it can be stitched together and loaded into Collibra. The template consists of a batch routine that has to be run from the command line, followed by a Mule template that can be scheduled or invoked over HTTP.

For more information, please download the datasheet

Big Data Platforms*

Cloudera

The Collibra Cloudera integration template helps load the Cloudera metadata assets into Collibra DGC. Metadata of Cloudera assets are extracted using Cloudera Navigator REST APIs. The assets extraction can be filtered based on directory and files in case of HDFS and based on Database and Schema for Hive. The template execution can be scheduled or triggered on-demand via Mule.

For more information, please download the datasheet

Hadoop

Lucid’s Collibra – Hadoop integration template extracts metadata from various distributions of Hadoop. Metadata extracted are from Hive Views, Tables, Columns, View dependencies, HDFS File/Folder lists and Hive table to physical HDFS file dependencies. Field-level metadata is extracted for Parquet, Avro, ORC, Json, csv formats.

* – trial to be available soon