Standard using TDOLEDB
Connection string
This OLE DB Provider for Teradata connection string can be used for connections to Teradata.
Provider=TDOLEDB;Data Source=myServerAddress;Persist Security Info=True;
User ID=myUsername;Password=myPassword;Session Mode=ANSI;