I have been using this product for 10+ years and I can agree wholeheartedly with the points about poor support. It has always been a big issue. I suspect that their product testing just isn't of the correct quality so they are fire fighting all the time
With regards to how…
Used BODS read a parameter table which it then used to generate and run the sql needed to copy tables from one database to another. The destination tables were based on parameters supplied in the parameter table.