16.10 - About Connection Profiles - Teradata Studio

Teradata Studio Express User Guide

prodname
Teradata Studio
vrm_release
16.10
created_date
June 2017
category
User Guide
featnum
B035-2042-067K

A connection profile contains the connection property information needed to connect to a data source in your enterprise.

You can create the following types of connection profiles. Those marked default are the default options in the system.

Option Description
Aster Database Connects to Teradata Aster Database using the Aster Embedded JDBC Driver (default).
Aster Execution Engine (Aster-on-Hadoop) Connects to a Teradata Aster Execution Engine instance using the Aster AX Embedded JDBC Driver (default).
DB2 for Linux, UNIX, and Windows Connects to IBM DB2 database for Linux, UNIX, or Windows, also known as DB2 LUW.
DB2 for i5/OS Connects to IBM DB2 embedded in the i5/OS operating system for IBM System i (iSeries) formerly AS/400.
DB2 for z/OS Connects to IBM DB2 for z/OS for IBM mainframe systems.
Generic JDBC Connects using a JDBC database connection.
Hadoop Cloudera Connects to Hadoop Cloudera systems using these user-defined options (defaults):
  • Teradata Connection to Hadoop (TDCH) for Teradata data transfer
  • SQL-H for Hadoop to Aster data transfer
  • Smart Loader for external file import and export in Hadoop
  • Hive Impala JDBC for creating and running SQL
  • Presto JDBC for creating and running SQL
Hadoop Generic System Connects to open source Hadoop systems using the WebHDFS service (default).
Hadoop Hortonworks Connects to Hortonworks Hadoop systems using these user-defined options (defaults):
  • Knox Gateway
  • Teradata Connection to Hadoop (TDCH) for Teradata data transfer
  • SQL-H for Hadoop to Aster data transfer
  • Smart Loader for external file import and export in Hadoop
  • Hive JDBC for creating and running SQL
  • Presto JDBC for creating and running SQL
Oracle Connects to an Oracle database.
SQL Server Connects to a Microsoft SQL Server.
Teradata Database Connects to Teradata Databases using the Teradata Embedded JDBC Driver (default).