Teradata - Select TD database table from within SQL server

-- 0. Install Teradata OleDB drivers for Windows, where the SQL Server instance is running.

-- 1. Openquery, much faster for my current setup.

SELECT *

FROM

      OPENQUERY(

            LINKED_SERVER_NAME_HERE

            , 'SELECT field1 FROM CFDW2_BA_VWS.SOR_PARTY'

      )

;

-- 2. Four-part naming string with second element skipped.

SELECT

      *

FROM

    LINKED_SERVER_NAME_HERE..TERDATA_DATABASE_NAME_HERE.TABLE_NAME_HERE

WHERE

      Field1 = '1001'

;