A

Wednesday, February 2nd, 2022 1:49 PM

Azure Purview Springboot integration

Hello @spring-team.collibra.com!
Would it be possible to receive a .cma archive for the operating model extension for the Azure Purview marketplace integration? Azure Purview to Collibra Integration - Collibra Marketplace
Thanks!

368 Messages

3 years ago

Hi Arthur,

The Azure Purview Marketplace integration is not tied down to a specific Operating Model. Relation and Attribute types are all configurable. Some Asset Types are also configurable. Moreover, we cannot create a general assignment of attributes, because attributes used on the different type of assets depend on the fields returned by your specific Purview instance. Therefore, we cannot create a generic .cma file.

1.2K Messages

Looking at the documentation, there are some custom attributes that are not in the out-of-the-box operating model, but there is no instruction as to how to create them (e.g. which data types to use?)

collibra.attribute.size=cd09c821-01cf-4358-afce-4e8f22ed4feb collibra.attribute.version=962ee807-6b7b-4d16-8717-7afd06c801d6 collibra.attribute.nickname=3c6a299c-d044-44a1-96c5-63a603f05734

1.2K Messages

3 years ago

There seems to be some issues with the integration.

  1. Upon running, I get a NullPointerException
2022-02-10 18:02:50,945 [http-nio-8443-exec-1] INFO  com.collibra.marketplace.azure.purview.component.CollibraGenericImportComponent - Import Job completed for Job ID:: 4a56f0e9-b6e5-42fa-91b6-13ab21dbf304
2022-02-10 18:02:50,949 [http-nio-8443-exec-1] INFO  com.collibra.marketplace.azure.purview.FullSyncProcessor - Domains upsert completed
2022-02-10 18:02:50,968 [http-nio-8443-exec-1] DEBUG com.collibra.marketplace.azure.purview.FullSyncProcessor - Domains Upsert Response :: {}["{\"type\":\"IMPORT\"}"]
java.lang.NullPointerException
        at com.collibra.marketplace.azure.purview.component.AzurePurviewSearchComponent.searchEntityFull(AzurePurviewSearchComponent.java:167)
        at com.collibra.marketplace.azure.purview.component.AzurePurviewSearchComponent.searchEntityFull(AzurePurviewSearchComponent.java:133)
        at com.collibra.marketplace.azure.purview.component.AzurePurviewSearchComponent.searchEntity(AzurePurviewSearchComponent.java:111)
        at com.collibra.marketplace.azure.purview.FullSyncProcessor.start(FullSyncProcessor.java:347)
        at com.collibra.marketplace.azure.purview.controller.EntryPointController.fullSyncTriggeredByApiRequest(EntryPointController.java:64)
  1. In the documentation, there seems to be a mix up with the talend spring-boot integration.

Can you please help, @spring-team.collibra.com ?

1.2K Messages

After trial and error, I was managed to get everything running and to successfully complete the sync! :raised_hands::smile:
For anyone interested:

  • You need to create 5 custom text attributes:

collibra.attribute.size=cd09c821-01cf-4358-afce-4e8f22ed4feb
collibra.attribute.version=962ee807-6b7b-4d16-8717-7afd06c801d6
collibra.attribute.nickname=3c6a299c-d044-44a1-96c5-63a603f05734
collibra.attribute.size=cd09c821-01cf-4358-afce-4e8f22ed4feb
collibra.attribute.version=962ee807-6b7b-4d16-8717-7afd06c801d6



  • You can create new asset types if you want so that they are not only “System” asset types
  • All configuration parameters need to be defined in application.properties otherwise it will fail without explanation.
  • I haven’t found the right limits, but if it’s too long, the uri will fail. Right now I’m using 50 as base value, but it seems to be quite long to sync, so I have to find the optimal values for each parameter.

3 years ago

Hi Arthur ,

Since you have already done this in your env and I am planning to do it in our instance :

How the code is handling the refresh of metadata saying that I meant if any change is done in the source like adding , editing , deleting of the entities in azure side will that be auto sync in Collibra with the Market place solution or do we need to enhance the code .

Your help will be appreciated .

Warm Regards,
Rohit

1.2K Messages

Hey Rohit, difficult to say. v1.1 crashed upon reload, I haven’t configured all the extra things from v1.2.1 to test again.
In general, you should consider the code as template to bootstrap your custom integration activities, not at as a finished product.

3 years ago

Hi All,

I would need your help on the below error , I am getting connection timeout error using the spring boot sbi-azurepurview to collibra :

2022-05-04 10:53:12,728 [RMI TCP Connection(3)-127.0.0.1] INFO org.springframework.web.servlet.DispatcherServlet - Completed initialization in 1 ms
2022-05-04 10:53:16,347 [http-nio-8081-exec-1] WARN org.apache.catalina.util.SessionIdGeneratorBase - Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [225] milliseconds.
2022-05-04 10:53:16,372 [http-nio-8081-exec-1] INFO com.collibra.marketplace.azure.purview.controller.EntryPointController - Integration triggered via API request for full sync
2022-05-04 10:53:16,373 [http-nio-8081-exec-1] INFO com.collibra.marketplace.azure.purview.FullSyncProcessor - Started Purview full sync
2022-05-04 10:53:16,373 [http-nio-8081-exec-1] INFO com.collibra.marketplace.azure.purview.component.CollibraCoreAPIComponent - Removing all mappings with external system id azure_purview …
org.springframework.web.client.ResourceAccessException: I/O error on POST request for : Connection timed out: connect; nested exception is java.net.ConnectException: Connection timed out: connect
at org.springframework.web.client.RestTemplate.doExecute(RestTemplate.java:785)
at org.springframework.web.client.RestTemplate.execute(RestTemplate.java:711)
at org.springframework.web.client.RestTemplate.exchange(RestTemplate.java:602)
at com.collibra.marketplace.azure.purview.component.CollibraCoreAPIComponent.removeMappings(CollibraCoreAPIComponent.java:171)
at com.collibra.marketplace.azure.purview.FullSyncProcessor.start(FullSyncProcessor.java:461)

I have got the solution to it and it will be like below :

This is resolved and I have used a prxoy and it help me in accessing the collibra env through the spring boot integration.

3 years ago

Hi Arthur,

I will help . Thanks a lot.

Warm Regards,
Rohit Chandra

Loading...