I would like to create a bar chart where the data source changes every month, pulling from a different database each time. What would be the best approach to achieve this?

Do I need to blend the data from different databases, or is there a more efficient way to handle this dynamically? Are there any specific tools, libraries, or techniques that can help automate the process?

Any guidance or examples would be greatly appreciated.