Bloomberg to Insights Enterprise User Map

To be able to filter data based on user access permissions, you need to map the Bloomberg user name to the kdb Insights Enterprise user name. The mapping should be ingested as a CSV format file through the bbgentpair pipeline, which is provided in the Bloomberg Entitlements accelerator.

This page explains how to perform this mapping.

User mapping CSV file

This file should contain the Bloomberg user name to kdb Insights Enterprise user name mappings for the users querying Bloomberg data and should be in CSV format. The file should contain three columns:

  • insightsUser - the kdb Insights Enterprise user name

  • bbgUser - the Bloomberg user name

  • IE userUUID - the kdb Insights Enterprise user UUID, available in keycloak. Refer to the authentication details for information.

Pipeline configuration

To point the bbgentpair pipeline at the CSV file, use the environment variables when deploying the pipeline, as shown below:

Shell

Copy 
# Deploy the pipeline
kxi pm deploy fsi-app-bbg-entl --pipeline bbgentpair --env bbgentpair:FSI_FILEPATH='s3://<YOUR FILEPATH>/<YOUR FILENAME>.csv" --env bbgentpair:FSI_REGION='us-east-2'

When the pipeline is deployed, the bbgentpair pipeline ingests the CSV file and persists the contents to the UserMap table in kdb Insights Enterprise.