Posts: 1
Joined: Wed Aug 08, 2018 8:32 am

Executing against multiple databases (outside Clover Server if possible)

Postby vinny_howard » Wed Aug 08, 2018 8:44 am

Clover Newbie here. I have gone through the Quick Start Guide, and read through a lot of the documentation, but I can't find a way to do what I want.
I have dozens of separate SQL databases, all with different hosts and username/passwords. I have a couple of Clover Graphs that I want to run against each database. So I am looking for some way to parameterise this - essentially to loop through a list of database names/hosts/username/passwords, and find some way to feed that to the DB Connection property on a DBInputTable component, and execute each Graph against each database, and create different CSV files for each execution. I don't see any way to do this with a Lookup or a Parameter. Is there any way to do this outside of Clover Server, which I don't have?