Contents:
Trifacta® SaaS 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.
Supported Environments
Trifacta SaaS
Running environment(s): Trifacta Photon and Spark
Base storage layer: S3
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 Trifacta SaaS can integrate.
TFS
Supported Versions: n/a
- Read: Supported
- Write: Supported
Create New Connection: n/a
NOTE: A single public connection to TFS is supported.
For more information:
Amazon S3 (layer)
This connection type refers to using S3 as the base storage layer.
Supported Versions: n/a
- Read: Supported
- Write: Supported
Create New Connection: n/a
Amazon Redshift
Supported Versions: n/a
- Read: Supported
- Write: Supported
Enable: Create Redshift Connections
Create New Connection:
UI: Create Redshift Connections
Snowflake
Supported Versions: n/a
Supported Environments:
Operation | Trifacta SaaS | Amazon | Microsoft Azure |
---|---|---|---|
Read | Not supported | Supported | Not supported |
Write | Not supported | Supported | Not supported |
- Read: Supported
- Write: Supported
Enable: Create Snowflake Connections
Create New Connection:
UI: Create Snowflake Connections
API: API Reference
- Type:
snowflake
- vendor:
snowflake
Relational DBs
General relational connectivity:
Relational connectivity is available for the following product editions:
NOTE: Availability of individual connection types may vary. Please see the documentation for the specific connection type for details.
- Trifacta® Enterprise Edition
- Trifacta Professional Edition
- Trifacta Premium
- Trifacta Standard
These connections pertain to relational database sources.
NOTE: Unless otherwise noted, authentication to a relational connection requires basic authentication (username/password) credentials.
If you are connecting Trifacta SaaS to any relational source of data, such as Redshift or Oracle, you must add the Trifacta Service to your whitelist for those resources.
NOTE: The database to which you are connecting must be available from the Trifacta service over the public Internet.
For more information, see Getting Started with Trifacta SaaS.
MySQL
Supported Versions: 5.7 and 8.0 Community
- Read: Supported
- Write: Supported
Create New Connection:
Oracle
Supported Versions: 12.1.0.2
- Read: Supported
- Write: Supported
Create New Connection:
PostgreSQL
Supported Versions: 9.3.10
- Read: Supported
- Write: Supported
Create New Connection:
UI: Create PostgreSQL Connections
SQL Server
Supported Versions: 12.0.4
- Read: Supported
- Write: Supported
Create New Connection:
UI:
MongoDB
Supported Versions: n/a
Supported Environments:
- Read: Supported
- Write: Not supported
Enable: MongoDB Connections
Create New Connection:
API:
"vendor": "mongodb", "vendorName": "MongoDB", "type": "jdbc"
MongoDB Atlas
Supported Versions: n/a
Supported Environments:
- Read: Supported
- Write: Not supported
Enable: MongoDB Connections
Create New Connection:
API:
"vendor": "mongodb_atlas", "vendorName": "MongoDB Atlas", "type": "jdbc"
Applications
Trifacta SaaS can be configured to connect to the following applications.
Salesforce
Supported Versions: n/a
Supported Environments:
- Read: Supported
- Write: Not supported
Create New Connection:
UI:
Microsoft SharePoint
Supported versions: n/a
- Read: Supported
- Write: Supported
Create New Connection:
UI: Create SharePoint Connections
Early Preview
Early Preview connections are read-only connection types that get you connected to your data, so that you can begin exploring and transforming as soon as possible. For more information, see Early Preview Connection Types.
Coming Soon
Connections listed under the Coming Soon are on the roadmap for development and release. These connections are not available for use in the current release of the product.
Tip: If you are interested in getting early access to these connections, please reach out to Trifacta Support.
This page has no comments.