Hi, I have not heard of Transparent Gateways. We do work with teradata, and used combination of sqlload, pro*c and informatica. Reasons being many ....some business demands, some becos of performance or some just because we are just lazy/busy to convert exisiting tools to newer. If you provide more info of your project, we may discuss it further.