Contents:
Designer Cloud Enterprise Edition 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 Gen1, ADLS Gen2, 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
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 Reference
- 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 Reference
- 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 Gen1
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 Gen1 is base storage layer) |
Enable: Enable ADLS Gen1 Access.
Create New Connection: n/a
NOTE: A single public connection to ADLS Gen1 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 |
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 Reference
- Type:
jdbc
- Vendor:
databricks
Relational DBs
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:
API:API Reference
- Type:
jdbc
- Vendor:
db2
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:
API:API Reference
- Type:
jdbc
- Vendor:
oracle
PostgreSQL
Supported Versions: 9.3.10
Supported Environments:
Operation | Designer Cloud Enterprise Edition | Amazon | Microsoft Azure |
---|---|---|---|
Read | Supported | Supported | Supported |
Write | Supported | Supported | Supported |
Create New Connection:
API:API Reference
- Type:
jdbc
- Vendor:
postgres
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 Reference
- 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:
API:API Reference
- Type:
jdbc
- Vendor:
teradata
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:
API: API Reference
Azure SQL Database
NOTE: This database connection is a specialized version of a SQL Server connection
NOTE: For 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 | Supported | Not supported | Supported |
Write | Supported | Not supported | Supported |
Enable: Create Azure SQL Database Connections
Create New Connection:
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 Reference
- Type:
jdbc
- Vendor:
salesforce
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
Tableau Server
Supported Versions: 10.5.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 Reference
- Type:
jdbc
- Vendor:
tableau
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.