Example Configuration for Pandora

Examples

In order to be better facilitate the usage of the configuration, feel free to adopt these examples to fit your own environment's settings.

Example collibra.bat file (Windows).

When using the integration, you can invoke collibra-connector directly after setting environment variables, or you can use an example bat script to set the variables locally and scope it to the usage of the application. Below is an example of such a file's contents.

@echo off
setlocal 
  set COLLIBRA_COMMUNITY_NAME=Replace this with your community name
  set COLLIBRA_COMMUNITY_DESCRIPTION=Replace this with your description
  set COLLIBRA_URL=https://replace-with-your-environment.collibra.com
  set COLLIBRA_USERNAME=YourCollibraUsername
  set COLLIBRA_PASSWORD=YourCollibraPassword

  REM Make sure you omit a trailing slash, 
  REM e.g. http://your-http-odbc-server-path:your-port/
  REM failure to omit the slash will result in an error.
  set HTTP_ODBC_URL=http://your-http-odbc-server-path:your-port
  
  REM Remember that 'COLLIBRA_RULE' is the name of the report.
  set HTTP_ODBC_RULE_QUERY=SELECT * FROM COLLIBRA_RULE

  REM Remember that 'COLLIBRA_PROFILE' is the name of the report.
  set HTTP_ODBC_PROFILE_QUERY=SELECT * FROM COLLIBRA_PROFILE

  REM This is necessary if you already have additional communities within Collibra
  set COLLIBRA_MULTI_COMMUNITY=true
  collibra-connector-win.exe
endlocal