Access modes for teradata beyond Sqoop ingestion.

[#1]

The Hortonworks Connector for Teradata enables ingestion with Sqoop as well as outbound data via Sqoop. Can someone please outline any other modes of interaction with Teradata that may be available. For instance, is it possible to execute Hive queries against Teradata without actually importing the data? Can queries be federated?

[#2 · Accepted solution]

1. Teradata Open Distribution for Hadoop (Running on Teradata Appliance for Hadoop) - Release Version: 2.1
2. TeradataViewpoint - Release Version: 15.00.00.xx
3. Teradata Studio – Smart Loader for Hadoop - Release Version: 15.00.0x
4. Teradata Connector for Hadoop (TDCH) - Release Version:1.3.1
5. Teradata QueryGrid: Teradata-Hadoop - Release Version: 14.10.x (Federated Queries)
6. Teradata QueryGrid: Aster-Hadoop - Release Version:6.00.02 (Federated Queries)
7. Teradata UnityEcosystem Manager - Release Version:15.00
8. Teradata Unity Data Mover -Release Version::15.00
9. Teradata Parallel Transporter (TPT) -Release Version:15.10

[#3]

Thanks Ancil. I'm still curious about what can be done from inside Hadoop. The federation of queries is particularly interesting becauese you don't always want to import the data into HDFS.

[#4]

Notes to add to Ancil's comments

Teradata Query Grid with Hortonworks capability is tied to releases - ie One-Way(14.10), Bi-Directional(15.00) and Push Down(15.00).

Teradata Unified Data Mover - an intelligent Data Mover between Unified Data Architecture(Teradata, Aster and Hadoop).

Teradata Studio for desktop - offers Data Source Explorer, Object Viewer, and transfer