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, edit the fsi-app-bbg-entl/src/bbgentpair-pipeline-spec.q file in the Bloomberg Entitlements accelerator, as in the example below:

Shell

Copy 
# Unpack the accelerator
kxi package unpack fsi-app-bbg-entl-1.0.0.kxi

# View the pipeline spec file
cat fsi-app-bbg-entl/src/bbgentpair-pipeline-spec.q
                    

Update the .fsi.filepath and .fsi.region variables to point to the CSV file:

Shell

Copy 
// File path and region
.fsi.filePath:`$":s3://<YOUR FILEPATH>/<YOUR FILENAME>.csv";
.fsi.region:"us-east-2";
                    

Repack the accelerator with your changes from the previous steps:

Shell

Copy 
# Repackage the accelerator
kxi package packit fsi-app-bbg-entl --tag 
                    

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