MicroStrategy Which DSN is used for metadata conection

13 Feb 2024

Dificulty ★☆☆☆☆

INTRO

Sometimes you don’t know which metadata connection is currently configured.

WINDOWS

open registry and go to

HKEY_LOCAL_MACHINE / SOFTWARE / WOW6432Node / MicroStrategy / Datasources / Castor Server

DSN in under ‘Location’
KB428146

or
you can run ‘metadata.ps1’ in this zip that will create ‘output.txt’ with necessary data.
download

Linux

execute

cat /var/opt/MicroStrategy/MSIReg.reg | grep -i dsn=

DSN in under ‘Location’
KB47411