Integrations for metadata ingestion into Collibra

Download a Template and Request a Trial License

Note: The Trial downloads are available only for direct Collibra Customers

REPORTING AND ANALYTICS

Tableau Integration

Lucid’s Collibra-Tableau integration template loads 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.

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 loads 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 metadata for Powerplay Transformer Cubes is read from. mdl files.

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

PowerBI Integration

Image result for PowerBI logo

Lucid’s Collibra PowerBI Integration template loads the PowerBI metadata into Collibra DGC. The PowerBI REST APIs as well as .pbix archive are used to extract the PowerBI assets like Workspace, Dashboard, Report, Report Pages, Report attributes etc. and the relations supporting them.

For more information, please download the datasheet and view the PowerBI 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

Lucid’s Collibra SQL Server Integration template loads the Database object metadata from SQL Server into Collibra DGC. Metadata of SQL Server assets are extracted by querying the System tables from SQL Server.

For more information, please download the datasheet

SSAS Integration

Lucid’s Collibra SSAS Integration template loads the SSAS Tabular model metadata from SSAS into Collibra DGC. Metadata of the Tabular model assets are extracted from the repository using DMV queries.

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

Oracle Integration

Lucid’s Collibra Oracle Integration template loads the Database object metadata from Oracle into Collibra DGC. Metadata of Oracle assets are extracted by querying the System tables from Oracle.

For more information, please download the datasheet

PostgreSQL Integration

Lucid’s Collibra PostgreSQL Integration template loads the Database object metadata from PostgreSQL into Collibra DGC. Metadata of PostgreSQL assets are extracted by querying the System tables from PostgreSQL.

For more information, please download the datasheet

MySQL Integration

Lucid’s Collibra MySQL Integration template loads the Database object metadata from MySQL into
Collibra DGC. Metadata of MySQL assets are extracted by querying the System tables from MySQL.

For more information, please download the datasheet

Teradata Integration

Lucid’s Collibra Teradata Integration template loads the Database object metadata from Teradata into Collibra DGC. Metadata of Teradata assets are extracted by querying the System tables from Teradata.

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.

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

DATA GOVERNANCE TOOLS

IBM InfoSphere Information Governance Catalog

Lucid’s Collibra-IGC Information Assets integration template extracts the Information Assets from IBM
InfoSphere Information Governance Catalog (IGC) using the IGC REST API and loads them into Collibra
Data Governance Center (DGC).

For more information, please download the datasheet

ETL TOOLS

Informatica PowerCenter

Lucid’s Collibra-Informatica PowerCenter integration template loads the Informatica PowerCenter assets into Collibra DGC. PowerCenter repository tables are used to fetch the metadata about Mappings, Sources, Targets, Lookups, Expressions etc.

For more information, please download the datasheet

Big Data Platforms*

Cloudera

Lucid’s Collibra Cloudera integration template loads the Cloudera metadata assets into Collibra DGC. Metadata of Cloudera assets are extracted using Cloudera Navigator REST APIs.

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

Custom Search for Collibra Assets

Lucid’s Relevancy-driven search for Collibra assets is a search engine for Collibra assets driven by a configurable set of rules. These rules, configured in Collibra, can drive both the order and display of the search results. The rules are used to calculate ‘Relevancy scores’ that are applied to specific asset types and their related asset types thus providing the ability to

· Match the search keyword with one or more attributes of the asset and not just by its name
· Order the search results based on the score
· Identify and segregate exact and partial matches Display either matching assets or their related assets

For more information, please download the datasheet.