SAP BusinessObjects to Collibra Integration
Overview
SAP BusinessObjects (SAP BO) is an enterprise software specialized in reporting and analytical business intelligence. The platform comprises a variety of reporting applications that help the users find data, store, create and share reports, and perform analysis.
This integration is designed to help you retrieve, map, and ingest metadata from a SAP BusinessObjects instance into the Collibra Platform. To make this possible, the SAP BO folders, documents, reports, report elements, data providers, universes, along with each universe’s folders and items (i.e., dimensions, dimension attributes, measures, and filters) are retrieved from SAP BO and transformed into Collibra assets with relations.
Use Cases
With this integration, you can:
- move away from intermediary tools for harvesting lineage from SAP BO
- enjoy the freedom of ingesting metadata and lineage from SAP BO directly into your Collibra instance.
Elements in Scope
The SAP BO integration is designed to retrieve metadata for Universes and Documents. Specifically, it retrieves the following elements:
- Folders
- Universes
- Measures
- Filters
- Dimension
- Dimension Attributes
- Documents
- Reports
- Report Elements
- Data Providers
- SQL queries which are used by Collibra’s Lineage Server to retrieve Technical Lineage
The asset upsert operation is performed against a given Collibra Platform instance, with the name, description, and other fields mapped over to standard fields in Collibra.
To receive support on this item, you can engage our Professional Services team or post any questions in the Data Citizens Community.
Media
More details
Release Notes
Changes:
- Updated the Spring Boot Starter Parent version to 2.7.5.
- Updated the Collibra Integration Library version to 1.1.10.
Added:
- Added dependencies to resolve security vulnerabilities.
- Bug fix in SAPBO API request to retrieve document details.
Compatibility
- Spring Boot Framework
- Eclipse IDE
- Collibra Data Intelligence Cloud
- Collibra Data Intelligence On-Prem
Dependency
- Java Runtime Environment 1.8
- Spring Boot Integration Library
- Java Runtime Environment 8
- SAP BusinessObjects
License and Usage Requirements
Release History
Release Notes
Changes:
- Updated the Spring Boot Starter Parent version to 2.7.4.
- Updated the Collibra Integration Library version to 1.1.9.
- Updated the asset names to ensure uniqueness.
- Updated the CMA file.
- Updated error handling.
- Replaced Springfox with SpringDoc for generating the Swagger UI page.
- Replaced sync.technical.lineage with extract.sap.bo.sql-queries and execute.lineage-harvester.
Added:
- Added universe and documents filtering support.
- Added support to have the Technical Lineage directory outside the Collibra Lineage Harvester folder.
- Added Universe Lineage as a method for extracting technical lineage. Kept previous method, which is now named Document Lineage.
- Added sync flag properties.
- Added Docker files.
Compatibility
- Spring Boot Framework
- Eclipse IDE
- Collibra Data Intelligence Cloud
- Collibra Data Intelligence On-Prem
Dependency
- Java Runtime Environment 1.8
- Spring Boot Integration Library
- Java Runtime Environment 8
- SAP BusinessObjects
License and Usage Requirements
Release Notes
Added:
- Support to process Universe sub-folders and parent folders up to the Universes folder.
- Support to process the Documents and their parent folders up to the Root folder.
- Support to process Reports, Report Elements, and Data Providers.
- Support for Technical Lineage.
Compatibility
- Spring Boot Framework
- Collibra Data Intelligence Cloud
- Collibra Data Intelligence On-Prem
Dependency
- Spring Boot Integration Library
- Java Runtime Environment 1.8
- SAP BusinessObjects
- Collibra Lineage Harvester
License and Usage Requirements
Release Notes
Updated the Spring Boot Integration Library dependency version in the pom.xml file to v1.1.3 that supports the latest Collibra Platform versions (v2022.01+).
Compatibility
- Spring Boot Framework
- Collibra Data Intelligence Cloud
- Collibra Data Intelligence On-Prem
Dependency
- Spring Boot Integration Library
- Java Runtime Environment 1.8
- SAP BusinessObjects
License and Usage Requirements
Release Notes
Updated the Log4j version from 2.16 to 2.17 due to vulnerabilities.
Compatibility
- Spring Boot Framework
- Eclipse IDE
- Collibra Data Intelligence Cloud
- Collibra Data Intelligence On-Prem
Dependency
- Collibra Integration library
- Java Runtime Environment 8
- SAP BusinessObjects
- q-risotto
- Java Development Kit v1.8
License and Usage Requirements
Release Notes
- Updated logger log4j2 dependency to Apache log4j2 version 2.16.0.
- Included missing dependencies
- Default empty values for Collibra attributes in case of corresponding null values from SAP BO.
- Fixed scheduler
Compatibility
- Spring Boot Framework
- Eclipse IDE
- Collibra Data Intelligence Cloud
- Collibra Data Intelligence On-Prem
Dependency
- Collibra Integration library
- Java Runtime Environment 8
- SAP BusinessObjects
- q-risotto
- Java Development Kit v1.8
License and Usage Requirements
Release Notes
Initial release.
Main features:
- A Spring Boot integration that retrieves metadata from SAP BusinessObjects
- Upserts the transformed data as assets on the Collibra Platform
Compatibility
- Spring Boot Framework
- Eclipse IDE
- Collibra Data Intelligence Cloud
Dependency
- Java Runtime Environment 8
- Collibra Integration library
- SAP BusinessObjects
- q-risotto
- Java Development Kit v1.8
License and Usage Requirements
See existing Q&A in the Data Citizens Community
Browse discussions with customers who also use this app.
Start a New Topic in the Data Citizens Community
Collibra-hosted discussions will connect you to other customers who use this app.
The following terms shall apply to the extent you receive the source code to this offering.
Notwithstanding the terms of the Binary Code License Agreement under which this integration template is licensed, Collibra grants you, the Licensee, the right to access the source code to the integrated template in order to copy and modify said source code for Licensee’s internal use purposes and solely for the purpose of developing connections and/or integrations with Collibra products and services.
Solely with respect to this integration template, the term “Software,” as defined under the Binary Code License Agreement, shall include the source code version thereof. Except with respect to the foregoing, all remaining terms of the Binary Code License Agreement shall apply to the license of integration template hereunder.
