What is the client interface? Terradata native? ODBC? etc...? This is going to be more of a determining factor than the backend. As for monitors, take a look at the SNMP monitor in LoadRunner and match that to the items available from the Terradata MIB.
If all else fails for script generation, take a look at the Advanced topics for loadrunner script generation, particularly looking at the use of a Visualo Studio developed virtual user. I leave that as an item of last resort in my bag of tricks, but it works well should you need to go to that level.