I have three different data sources. One is my application db there are all the application informations stored like application_name. Then I have multiple tracking db’s where I want to build metrics out of it. In the tracking db’s I don’t store the application_name, only the application_id.
In my metrics now I can only display the application_id. To make it easier to read I would like to replace the application_id with application_name from my application database.
I looked into the value mapping feature but there I can only add the entries manual. I have 80000+ application records I need to map. So thats not an option.
Any idea on how to solve this?