I have multiple SW instances for reasons which are way too complex to list now. Essentially, I want to be able to consolidate the monitoring dashboards/visualizations onto the cliche "single pain of glass". I expect to have to do this outside of SW - is this the right approach? Is there an API I should use?
If you want an off the shelf solution SolarWinds sells Enterprise Operations Console as a platform for viewing data across multiple Orion instances.
On the other hand if you want to roll your own answer then Orion has a pretty robust API, but it's very different from typical API's in that it is really just an abstraction layer for your to query the database.
This is pretty much where you need to start to get up to speed on the API - https://github.com/solarwinds/OrionSDK
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.