About Connection Profiles - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
pts1468860020550.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities

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 the Aster Execution Engine 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).