Unsupported Screen Size: The viewport size is too small for the theme to render properly.
Published by Lucid Technologies

SQL Server Analysis Services (SSAS) Metadata to Collibra

Download Datasheet Request Information
Certified Vendor Supported Free Trial

We have made the decision to transition away from Collibra Connect so that we can better serve you and ensure you can use future product functionality without re-instrumenting or rebuilding integrations. For more information, please reach out to your Customer Success Manager.

Learn more about different methods to build integrations in Collibra Developer Portal.

Overview

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.

Some key features:

  • Asset extraction can be filtered based on SSAS Server name, SSAS Database, Model Name and Model Type (‘SSAS Tabular model’ only in this version)
  • Target community in DGC for the assets to be loaded, can be specified during load
  • Source metadata is mapped to DGC asset types as indicated in the diagram below
  • Modification and Delete of the source (SSAS) objects are automatically captured and can be used to trigger actions in DGC such as asset status change, asset management workflows, etc.
  • Support for full load and incremental load. Incremental loads can load changes since the last successful execution or from a specific date passed as a parameter
  • Metadata loads can be scheduled or triggered on-demand
  • Connectivity Check template available for environment verification

NOTE: The downloadable bundle archive is encrypted. Please contact the publisher to obtain the password and the trial license. 

Media

More details

Release Notes

v2.6

  • Support for SSAS 2017 ( only specific Data Source types)
  • Support for the following SSAS data sources:
    o ODBC connections like SAP HANA
    o SQL server
    o Teradata
    o Oracle
    o SAP HANA (native)
    o SSAS Tabular Model

v1.0

  • Support for extracting and loading the following SSAS Tabular model assets: SSAS Database, Model, Tables, Columns, Measures, Hierarchies and Relationships
  • Calculated columns/measures that use DAX expressions (Data Analysis eXpressions) will be parsed to identify dependencies
  • Link to underlying relational database objects as captured from SSAS metadata – metadata of the actual underlying database/ physical data source should be loaded using Collibra Catalog or Lucid’s database integrations or other integration solutions
  • Alignment to Collibra Catalog asset nomenclature (including Full Name and Display Name)
  • Asset extraction can be filtered based on SSAS Server name, SSAS Database, Model Name and Model Type (‘SSAS Tabular model’ only in this version)
  • Target community in DGC for the assets to be loaded, can be specified during load
  • Modification and Deletes of the source (SSAS) objects metadata are captured in DGC
  • Support for full loads as well as incremental loads. Incremental loads can load changes since the last successful execution or from a specific date passed as a parameter
  • Metadata loads can be scheduled or triggered on-demand
Compatibility
  • Collibra Cloud
  • Collibra 5.7 and newer
  • PostgreSQL 9.6
Dependency
  • Collibra Platform Connector 1.4.4
License and Usage Requirements
  • Collibra Connect
  • Collibra SSAS integration

Release History

No previous versions of this listing is available.

This listing is directly supported by Lucid Technologies, please use the tool to submit a support request.

Submit a support request

Lucid’s SSAS metadata integration is provided as a deployable zip for setup on Mule ESB run-time. This includes the integration template and the pre-built SSAS Connector. Source code will not be provided for the SSAS Connector.

Initial support includes:

  • 2 hours of virtual sessions for install/config support (or) troubleshooting
  • Documentation
    • Installation & Configuration Guide
    • Support Guide

Then Email-based support with a response of 1 business day is provided.

Lucid’s SSAS metadata integration is provided on an Annual subscription.

Subscription Fee to use the license is payable annually in advance, subject to the terms and conditions of the License Agreement between the client and Lucid

Reviews

Rating
Leave a review