Page tree

   

Contents:


Trifacta® Wrangler Pro 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 Wrangler Pro

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 Wrangler Pro can integrate.

Amazon S3 (layer)

This connection type refers to using S3 as the base storage layer. For more information on creating connections to S3 buckets, see "Amazon S3 (user)" below.

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 Wrangler Pro

AmazonMicrosoft Azure
ReadNot supportedSupportedNot supported
WriteNot supportedSupportedNot 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

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 Wrangler Pro to any relational source of data, such as Redshift or Oracle, you must add the Trifacta Service to your whitelist for those resources. For more information, see Getting Started with Trifacta Wrangler Pro.

DB2



  • DB2 for Windows and Unix/Linux

Supported Versions: v10.5.5

  • Read: Supported
  • Write: Supported

Create New Connection: 

UI: Create DB2 Connections

MySQL


Supported Versions: 5.7 and 8.0 Community

  • Read: Supported
  • Write: Supported

Create New Connection:

UI: Create MySQL Connections

Oracle


Supported Versions: 12.1.0.2

  • Read: Supported
  • Write: Supported

Create New Connection: 

UI: Create Oracle Connections

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: 

UI: Create Connection Window

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: 

UI: Create Connection Window

API:

"vendor": "mongodb_atlas",
"vendorName": "MongoDB Atlas",
"type": "jdbc"

Applications

Trifacta Wrangler Pro 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


Tableau Server

Supported Versions: 10.5.x and later

  • Read: Supported
  • Write: Not supported

Create New Connection:

UI: Create Tableau Server 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.