SAP BO Integration_no SQL queries found in SqlDirectory warning
Hello developers and @spring-team.collibra.com,
I was wondering if any of you are familiar with a directory issue we’ve encountered while deploying SAP BO to Collibra Integration (https://marketplace.collibra.com/listings/sap-businessobjects-to-collibra-integration/). The call we make is POST: https://:<server.port>/api/sync, and it does send to DGC the reports and universes that CUID we specified in the integration’s application.properties file, however, it doesn’t save sql queries in the folder we chose. Here is the WARN: “com.collibra.marketplace.sap.businessobjects.component.TechnicalLineageProcessor - No SQL queries found in SqlDirectory. Therefore, there is no technical lineage to import.”
What we tried to resolve this issue:
-
Save sql queries in different directories, including lineage-harvester/sql directory.
-
Change dialect in the lineage-harvester configuration file to hana, hive, db2, and mssql.
-
Get rid of different filterers in the application.properties files. At the moment we have only universe and reports’ CUIDs specified:
sap.bo.universe.cuid.allow.list={‘AZtnKrxc7TJFuzsvAqBgswB’}
sap.bo.document.cuid.allow.list={‘AciIU6eZfEBIhhI8M5zV2sF’,‘AQ9hJZdOnT9FppnPoS_DUYg’}
- We double checked CUIDs for the universe and reports we selected, and, also, double checked that the db the reports are pointing to is the same as we specified in the lineage-harvester.sources.
Please note in our application.properties file execute.lineage-harvester=false, therefore, the linage harvester shouldn’t be automatically executed.
One of the suggestions we have received so far was to get rid off CUIDs of the universe and reports to check if the queries can be saved for any reports but this solution doesn’t seem feasible due to the following reasons: 1. SAP BO is our global application, therefore, scanning all reports to troubleshoot something is extremely time-consuming. 2. Some of our reports are sensitive and we are not allowed to scan them.
Thank you for reading my post,
Svetlana
