Contents:
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.
NOTE: Before creating connections to Hive or relational datastores, you must create and deploy an encryption key file. See Create Encryption Key File.
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:
- You can apply this change through the Admin Settings Page (recommended) or
trifacta-conf.json
. For more information, see Platform Configuration Methods. Search for the following parameter, and set it to
false
:"webapp.connectivity.nonAdminManagementEnabled": true,
- Save your changes and restart the platform.
Supported Environments
Designer Cloud Enterprise Edition
Running environment(s): Trifacta Photon and Spark
Base storage layer: HDFS
Amazon AWS
Running environment(s): Trifacta Photon and Spark
Base storage layer: S3
Microsoft Azure
Running environment(s): Trifacta Photon and Spark
Base storage layer: ADLS or WASB
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
Apache Hadoop HDFS - Hortonworks
Enable: Configure for Hadoop
Create New Connection: n/a
Hive
Enable: Configure for Hive
NOTE: Additional configuration is required.
Create New Connection:
NOTE: A single public Hive connection is supported.
API: API Connections Create v4
- Type:
hive
- Vendor:
hive
For more information, see 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:
Operation | Designer Cloud Enterprise Edition | Amazon | Microsoft Azure |
---|---|---|---|
Read | Supported | Supported | Not supported |
Write | Not supported | Supported | Not supported |
Enable: Enable S3 Access
Create New Connection: n/a
NOTE: A single public connection to S3 is supported.
Amazon Redshift
Supported Versions: n/a
Supported Environments:
NOTE: S3 must be set as the base storage layer. See Set Base Storage Layer.
Operation | Designer Cloud Enterprise Edition | Amazon | Microsoft Azure |
---|---|---|---|
Read | Not supported | Supported | Not supported |
Write | Not supported | Supported | Not supported |
Enable: Create Redshift Connections
Create New Connection:
UI: Create Redshift Connections
API: API Connections Create v4
- Type:
redshift
- vendor:
redshift
Snowflake
Supported Versions: n/a
Supported Environments:
NOTE: S3 must be set as the base storage layer. See Set Base Storage Layer.
Operation | Designer Cloud Enterprise Edition | Amazon | Microsoft Azure |
---|---|---|---|
Read | Not supported | Supported | Not supported |
Write | Not supported | Supported | Not supported |
Enable: Create Snowflake Connections
Create New Connection:
UI: Create Snowflake Connections
API: API Connections Create v4
- Type:
snowflake
- vendor:
snowflake
Microsoft Azure WASB
Supported Versions: n/a
Supported Environments:
Operation | Designer Cloud Enterprise Edition | Amazon | Microsoft Azure |
---|---|---|---|
Read | Not supported | Not supported | Supported |
Write | Not supported | Not supported | Supported (only if WASB is base storage layer) |
Enable: Enable WASB Access
Create New Connection: n/a
NOTE: A single public connection to WASB is supported.
Microsoft Azure ADLS
Supported Versions: n/a
Supported Environments:
Operation | Designer Cloud Enterprise Edition | Amazon | Microsoft Azure |
---|---|---|---|
Read | Not supported | Not supported | Supported |
Write | Not supported | Not supported | Supported (only if ADLS is base storage layer) |
Enable: Enable ADLS Access.
Create New Connection: n/a
NOTE: A single public connection to ADLS is supported.
Microsoft Azure ADLS Gen2
Supported Versions: n/a
Supported Environments:
Operation | Designer Cloud Enterprise Edition | Amazon | Microsoft Azure |
---|---|---|---|
Read | Not supported | Not supported | Supported |
Write | Not supported | Not supported | Supported (only if ABFSS is base storage layer) |
Enable: Enable ADLS Gen2 Access
Create New Connection: n/a
NOTE: A single public connection to ADLS Gen2 is supported.
Databricks Tables
Supported Versions: n/a
Supported Environments:
Operation | Designer Cloud Enterprise Edition | Amazon | Microsoft Azure |
---|---|---|---|
Read | Not supported | Not supported | Supported |
Write | Not supported | Not supported | Supported (only if ABFSS is base storage layer) |
Enable: Create Databricks Tables Connections
Create New Connection: Create Databricks Tables Connections
Tip: It's easier to create a connection of this type through the UI. Typically, only one connection is needed.
API: API Connections Create v4
- Type:
jdbc
- Vendor:
databricks
Relational DB
These connections pertain to relational database sources.
NOTE: Unless otherwise noted, authentication to a relational connection requires basic authentication (username/password) credentials.
Enable: For more information, see Enable Relational Connections.
DB2
- DB2 for Windows and Unix/Linux
Supported Versions: v10.5.5
Supported Environments:
Operation | Designer Cloud Enterprise Edition | Amazon | Microsoft Azure |
---|---|---|---|
Read | Supported | Supported | Supported |
Write | Not supported | Not supported | Not supported |
Create New Connection:
- UI: Create Connection Window
API: API Connections Create v4
- Type:
jdbc
- Vendor:
db2
- Type:
Oracle
Supported Versions: 12.1.0.2
Supported Environments:
Operation | Designer Cloud Enterprise Edition | Amazon | Microsoft Azure |
---|---|---|---|
Read | Supported | Supported | Not supported |
Write | Supported | Supported | Supported |
Create New Connection:
- UI: Create Connection Window
API: API Connections Create v4
- Type:
jdbc
- Vendor:
oracle
- Type:
PostgreSQL
Supported Versions: 9.3.10
Supported Environments:
Operation | Designer Cloud Enterprise Edition | Amazon | Microsoft Azure |
---|---|---|---|
Read | Supported | Supported | Not supported |
Write | Supported | Supported | Supported |
Create New Connection:
- UI: Create Connection Window
API: API Connections Create v4
- Type:
jdbc
- Vendor:
postgres
- Type:
SQL Server
Supported Versions: 12.0.4
Supported Environments:
Operation | Designer Cloud Enterprise Edition | Amazon | Microsoft Azure |
---|---|---|---|
Read | Supported | Supported | Supported |
Write | Supported | Supported | Supported |
Create New Connection:
UI:
API: API Connections Create v4
- Type:
jdbc
- Vendor:
sqlserver
Teradata
Supported Versions: 14.10+
Supported Environments:
Operation | Designer Cloud Enterprise Edition | Amazon | Microsoft Azure |
---|---|---|---|
Read | Supported | Supported | Not supported |
Write | Supported | Supported | Supported |
Enable:
Create New Connection:
- UI: Create Connection Window
API: API Connections Create v4
- Type:
jdbc
- Vendor:
teradata
- Type:
SQL DW
Supported Versions: n/a
Supported Environments:
Operation | Designer Cloud Enterprise Edition | Amazon | Microsoft Azure |
---|---|---|---|
Read | Not supported | Not supported | Supported |
Write | Not supported | Not supported | Supported NOTE: Additional configuration is required. |
Enable: Create SQL DW Connections
Create New Connection:
Azure SQL Database
NOTE: This database connection is a specialized version of a SQL Server connection and is available only in Microsoft Azure deployments. Some additional configuration properties must be applied. See Configure for Azure.
Supported Versions: Azure SQL Database version 12 (other versions are not supported)
Supported Environments:
Operation | Designer Cloud Enterprise Edition | Amazon | Microsoft Azure |
---|---|---|---|
Read | Not supported | Not supported | Supported |
Write | Not supported | Not supported | Supported |
Enable: Create Azure SQL Database Connections
Create New Connection:
- UI: Create Connection Window
- API: Not supported
Applications
Salesforce
Supported Versions: n/a
Supported Environments:
Operation | Designer Cloud Enterprise Edition | Amazon | Microsoft Azure |
---|---|---|---|
Read | Supported | Supported | Supported |
Write | Not supported | Not supported | Not supported |
Create New Connection:
- UI:
API: API Connections Create v4
- Type:
jdbc
- Vendor:
salesforce
- Type:
SFTP
Supported versions: n/a
Supported Environments:
Operation | Designer Cloud Enterprise Edition | Amazon | Microsoft Azure |
---|---|---|---|
Read | Supported | Supported | Supported |
Write | Supported | Supported | Supported |
Create New Connection:
- API:
- Type:
jdbc
- Vendor:
sftp
- Type:
Tableau Server
Supported Versions: 10.2.x and later
Supported Environments:
Operation | Designer Cloud Enterprise Edition | Amazon | Microsoft Azure |
---|---|---|---|
Read | Not supported | Not supported | Not supported |
Write | Supported | Supported | Supported |
Create New Connection:
- UI: Create Tableau Server Connections
API: API Connections Create v4
- Type:
jdbc
- Vendor:
tableau
- Type:
Search Integrations
These types of integrations enable you to search catalogs for dataset to import.
NOTE: Search connections cannot be created or modified through the user interface or APIs. They are enabled and configured through parameter.
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.
This page has no comments.