Integration with SAP BO - .unv universes
Summary: derekfield is seeking advice on automating the integration of legacy .unv universe metadata from SAP Business Objects into Collibra because the current tools only support .unx formats easily. springboot_team from the "springboot_team" responded, clarifying that the SAP BO to Collibra integration in Spring Boot does not rely on the SAP BO Java SDK but utilizes the REST API instead. springboot_team provided a link for additional information and emphasized following the documentation for proper configuration.
Hello! My organization uses SAP Business Objects for data reporting. We have lots of important legacy content in “old” .unv format as well as the newer .unx format. Collibra offers an integration pathway for metadata from .unx universe-sourced reporting called Spring Boot Integration, but we are working on an integration pathway that minimally includes .unv (unsupported) universes’ metadata from our SAP Business Objects metadata repository. Our goal is to automate this process to avoid needing to manually create and update content via spreadsheet imports. Have any other organizations successfully built an integration pathway that automatically ingests or updates .unv universe metadata into their instance of Collibra? If anyone is out there, we would love the chance to ask you a few questions! Thank you,
Derek Field
[email protected]
Data & Analytics Liaison, WI Department of Children and Families
jeevarekhaag1 G
·9 months agoHi @springboot_team ,
We are using the SAP BusinessObjects to Collibra Integration v1.2.1 (Spring Boot) published on the Collibra Marketplace. This integration has been working as expected for universes built on relational databases (SQL Server), and we were able to successfully retrieve, map, and ingest the metadata into Collibra. However, the ingestion fails for universes that are built on multidimensional/OLAP cube data sources.
Could you please confirm whether this integration supports only relational-database–based universes, or if OLAP-based universes should also be supported?
springboot_team
·3 years ago · EditedHi @derekw.field.wisconsin.gov,
For the Spring Boot SAP BO to Collibra integration the SAP BO Java SDK is not used, while the SAP BO REST API is used. You can obtain more information about the API from the following link: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_WEB_INTELLIGENCE/58f583a7643e48cf944cf554eb961f5b/ec558f026fdb101497906a7cb0e91070.html .
To configure the integration and set up the API details, please follow the documentation, section “Configuration”, precisely the steps regarding the properties file located in src/main/resources/application.properties.
Thanks
derekfield
OP3 years ago · EditedHello! I had understood that .unx universes in BO use a Java-compatible SDK, while .unv use a different SDK with which Java is incompatible. Can you or someone on the team please let me know if that is incorrect, or else please describe how Spring Boot changes make the program compatible with the .unv SDK? Or else please advise on how I can find an answer? Thank you!
springboot_team
·3 years ago · EditedHi @derekw.field.wisconsin.gov,
Welcome to the Data Citizens community.
The latest version of the SAP BO to Collibra integration should support both .unv and .unx format universes.
SAP BusinessObjects to Collibra Integration - Collibra Marketplace
A Spring Boot integration that synchronizes metadata from SAP BusinessObjects to the Collibra Platform.
Regarding contacting another organization, can you please ask your Customer Success Manager? Thanks