My client has a special case.
His data save in a MySQL server, but not in the same database. His system creates a database everyday, database name is xxxx_yyyy_mm_dd, and saves this day's data in it.
In order to collect the data into Splunk through Splunk Db Connect, it has to change the configuration of 'Default Database' in 'Connection' setting everyday. But because of the effort cost, we can't do this way, that's a problem.
In this situation, is there a solution that resolve this problem?