Hi cdec,
I do not have a fully solution to this. Our customer set up multiple Heavy Forwarder for DB Connect. Do manage the inputs and collections for myself, i wrote a Python Script to automate the creation of db_connections.conf and db_inputs.conf from a csv file, but that is just a little help. You can find it here: https://github.com/jbrocks/splunk-db-connect-inputs-and-collections . Further more I am also looking for experience from others. My customer actually tries to onboard as less DBs via DB Connect as possible. Where possible we try to collect the data via syslog, but this is still a long internal discussion.
... View more