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):
|
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):
|
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). |