question Re: Access modes for teradata beyond Sqoop ingestion. in Archives of Support Questions (Read Only)

Access modes for teradata beyond Sqoop ingestion.

pcoates — Fri, 20 Nov 2015 22:47:24 GMT

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?

Re: Access modes for teradata beyond Sqoop ingestion.

amcbarnett — Sat, 21 Nov 2015 01:05:02 GMT

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

Re: Access modes for teradata beyond Sqoop ingestion.

pcoates — Sat, 21 Nov 2015 04:26:43 GMT

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.

Re: Access modes for teradata beyond Sqoop ingestion.

mlochbihler — Wed, 25 Nov 2015 00:06:58 GMT

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