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
Current Version
v1.0
April 15, 2019

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.

Rating
Certified Vendor Supported Free Trial

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. 

More details

Release Notes

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
Dependencies
  • HTTP access to Analysis Services using the MSMDPUMP.dll ISAPI extension on IIS – https://docs.microsoft.com/en-us/sql/analysis-services/instances/configure-http-access-to-analysis-services-on-iis-8-0?view=sql-server-2017
  • Collibra Platform 5.5.x, 5.6.x, 5.7.x
  • Collibra Connect with DGC Connector version 1.4.4 (Mule runtime version 3.9.1)
  • Access to Postgres Database (with server version 9.6). Need an empty schema with privileges to drop and create tables.
  • Metamodel merge (included in deployment kit) – for Collibra Platform 5.4.x, 5.5.x
  • DGC migration feature – for Collibra Platform 5.6.x, 5.7.x
License and Usage Requirements
  • Collibra Connect
  • License file for Collibra SSAS integration (from Lucid)

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

Leave a review