Page tree

Trifacta Dataprep


Contents:

On April 28, 2021, Google changed the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.

   

Contents:


Dataprep by Trifacta® 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

Dataprep by Trifacta

Running environment(s): Trifacta Photon and Dataflow

Base storage layer: Dataflow


Default Connections

These connections are automatically enabled and configured with the product.

Upload

Enable: Automatically enabled.

Create New Connection: n/a

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.

Feature Availability: This feature is available in the following editions:

  • Dataprep Enterprise Edition by Trifacta®
  • Dataprep Professional Edition by Trifacta
  • Dataprep Premium by Trifacta
  • Dataprep Standard by Trifacta


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 Dataprep by Trifacta to any relational source of data, such as Oracle, you must add the Trifacta Service to your whitelist for those resources.

NOTE: Relational datasources must be available on a public IP address that is accessible from the deployment of Dataprep Premium by Trifacta.

For more information, see Getting Started with Cloud Dataprep.

MySQL

Supported Versions: 5.7 and 8.0 Community

  • Read: Supported
  • Write: Supported

Create New Connection:

UI: MySQL Connections

API: API Reference

  • Type: jdbc
  • Vendor: mysql

Oracle

Supported Versions: 12.1.0.2

  • Read: Supported
  • Write: Supported

Create New Connection: 

UI: Oracle Database Connections

PostgreSQL

Supported Versions: 9.3.10

  • Read: Supported
  • Write: Supported

Create New Connection:

UI: 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

Dataprep by Trifacta 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: SharePoint Connections



Dataprep by Trifacta

BigQuery

Enable: Automatically enabled.

Create New Connection: n/a

Google Cloud Storage

Enable: Automatically enabled.

Create New Connection: n/a


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.