Excel Tool to Extract Quantrix DataLink Info
I’ve built a simple Excel tool that extracts the SQL statements and connection strings for each DataLink in a Quantrix .xmodel file. I use this on large models with many DataLinks to get a list of all the queries and connections used in the model.
This tool also demonstrates how you can use Excel VBA to open an .xmodel file as XML and browse the contents. Using the same kind of code, you could also make changes to the DataLink properties (such as changing a connection string).
Attached is the Excel file. Make sure you enable macros (macro security must be set to “Medium” or lower in Excel). This tool works for either Quantrix version 2.4 or 3.0.