Can the DB name for a DB profile SQL statement be set dynamically?
Nopes. I believe you are trying to connect to multiple end points by passing it dynamically ? Unfortunately, you can't do that because this is how licensing works in Boomi. End point connection details will always have to be static values.
However, you can still make use of process extensions to change the values at run-time without redeploying your process.
Hope this helps.
How about creating a stored procedure on the database, that based on one or more parameters determines what to select from which table?
If possible the best solution is having the DB do the hard work.
Retrieving data ...