Connection Types

The Designer Cloud Powered by Trifacta® platform supports the following types of connections. Use the links below to enable connection to each type and, where applicable, to create new connections to individual instances of the same type. 

Notes:

• HDFS and Hive connections can be configured as part of platform configuration.
• Database connections should be configured after you have completed the platform configuration and have validated that it is working for locally uploaded files.

Configure

Disable Creating Connections for Non-Admins

By default, all users are permitted to create connections. As needed, you can disable the ability to create connections for non-admin users.

Steps:

1. You can apply this change through the Admin Settings Page (recommended) or trifacta-conf.json. For more information, see Platform Configuration Methods.

2. Search for the following parameter, and set it to false:

   "webapp.connectivity.nonAdminManagementEnabled": true,

3. Save your changes and restart the platform.

Supported Environments

For more information, see Running Environment Options.

For more information, see Set Base Storage Layer.

Default Connections

These connections are automatically enabled and configured with the product.

Upload

Enable: Automatically enabled.

Create New Connection: n/a

Big Data

These connections pertain to the various big data platforms that are supported by the Designer Cloud Powered by Trifacta platform.

Apache Hadoop HDFS - Cloudera

Enable: Configure for Hadoop.

Create New Connection: n/a

Hive - Cloudera

Enable: Configure for Hive

Create New Connection: Create Hive Connections

Apache Hadoop HDFS - Hortonworks

Enable: Configure for Hadoop.

Create New Connection: n/a

Hive - Hortonworks

Enable: Configure for Hive

Create New Connection: Create Hive Connections

Cloud Platforms

These connections pertain to cloud platforms with which the Designer Cloud Powered by Trifacta platform can integrate.

Amazon S3

Supported Versions: n/a

Supported Environments:

Enable: Enable S3 Access

Create New Connection: n/a

Amazon Redshift

Supported Versions:  n/a

Supported Environments:

Enable: Create Redshift Connections

Create New Connection: 

• UI: Create Redshift Connections

• API: API Connections Create v4

Microsoft Azure WASB

Supported Versions: n/a

Supported Environments:

Enable: Enable WASB Access

Create New Connection: n/a

Microsoft Azure ADLS

Supported Versions: n/a

Supported Environments:

Enable: Enable ADLS Access.

Create New Connection: n/a

Relational DB

These connections pertain to relational database sources.

Enable: For more information, see Enable Relational Connections.

DB2

• DB2 for Windows and Unix/Linux

Supported Versions: v10.5.5

Supported Environments:

Create New Connection: 

• UI: Create Connection Window

• API: API Connections Create v4

  • Type: jdbc
  • Vendor: db2

Oracle

Supported Versions: 12.1.0.2

Supported Environments:

Create New Connection: 

• UI: Create Connection Window

• API: API Connections Create v4

  • Type: jdbc
  • Vendor: oracle

PostgreSQL

Supported Versions: 9.3.10

Supported Environments:

Create New Connection:

• UI: Create Connection Window

• API: API Connections Create v4

  • Type: jdbc
  • Vendor: postgres

SQL Server

Supported Versions: 12.0.4

Supported Environments:

Create New Connection:

• UI: 
  • Create SQL Server Connections
  • Create Connection Window

• API: API Connections Create v4

  • Type: jdbc
  • Vendor: sqlserver

Teradata

Supported Versions: 14.10+

Supported Environments:

Enable: 

• Enable Teradata Connections

Create New Connection:

• UI: Create Connection Window

• API: API Connections Create v4

  • Type: jdbc
  • Vendor: teradata

SQL DW

Supported Versions: n/a

Supported Environments:

Enable: Create SQL DW Connections

Create New Connection: 

• UI: Create Connection Window
• API: Not supported

SQL DB

Supported Versions: Azure SQL DB version 12 (other versions are not supported)

Supported Environments:

Enable: Create SQL DB Connections

Create New Connection: 

• UI: Create Connection Window
• API: Not supported

Applications

Salesforce

Supported Versions: n/a

Supported Environments:

Create New Connection: 

• UI:
  • Create Salesforce Connections
  • Create Connection Window

• API: API Connections Create v4

  • Type: jdbc
  • Vendor: salesforce

Tableau Server

Supported Versions: 10.2.x and later

Supported Environments:

Create New Connection:

• UI: Create Tableau Server Connections

• API: API Connections Create v4

  • Type: jdbc
  • Vendor: tableau

Search Integrations

These types of integrations enable you to search catalogs for dataset to import.

Search capabilities are available through the application. See Import Data Page.

Alation

Enable: For more information on enabling, see Enable Alation Sources.

Create New Connection: No additional configuration is required.

For more information on searching Alation sources, see Using Alation.

Waterline

Enable: For more information on enabling, see Enable Waterline Sources

Create New Connection: No additional configuration is required.

For more information on searching Waterline sources, see Using Waterline.

Other Connections

For additional connectivity options, please contact Alteryx Support.