Select the Connection Type 'OLEDB Connections' and the Oledb Driver Type of 'Teradata'.
The Data Source is the host name or IP address of the machine running Oracle.
User Id is your username, and Password your password.
Missing Teradata Provider for .NET 4.0
If you attempt to use the Teradata Provider for .NET 4.0 and you don't have it installed, you will receive an error directing you to the driver download location.
The message will say:
The Teradata .NET Provider cannot be found. Please ensure you have the driver installed and configured correctly.
Contact your system administrator or you can download directly from here:
http://downloads.teradata.com/download
The driver must be installed on the server where the DataConnect Runtime service is installed.
After installing this driver, you may need to reboot the server.