Connection Types

Cloud Dataprep by TRIFACTA® INC. 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.

Default Connections

These connections are automatically enabled and configured with the product.

Upload

Enable: Automatically enabled.

Create New Connection: n/a

Relational DBs

Feature Availability: This feature is available in Cloud Dataprep Premium by TRIFACTA® INC.

These connections pertain to relational database sources.

NOTE: Unless otherwise noted, authentication to a relational connection requires basic authentication (username/password) credentials.

DB2

Feature Availability: This feature is available in Cloud Dataprep Premium by TRIFACTA® INC.

  • DB2 for Windows and Unix/Linux

Supported Versions: v10.5.5

  • Read: Supported
  • Write: Supported.

Create New Connection:

UI: Create DB2 Connections

Oracle

Feature Availability: This feature is available in Cloud Dataprep Premium by TRIFACTA® INC.

Supported Versions: 12.1.0.2

  • Read: Supported
  • Write: Supported

Create New Connection:

UI: Create Oracle Connections

PostgreSQL

Feature Availability: This feature is available in Cloud Dataprep Premium by TRIFACTA® INC.

Supported Versions: 9.3.10

  • Read: Supported
  • Write: Supported

Create New Connection:

UI: Create Connection Window

SQL Server

Feature Availability: This feature is available in Cloud Dataprep Premium by TRIFACTA® INC.

Supported Versions: 12.0.4

  • Read: Supported
  • Write: Supported


Create New Connection:

UI:

Applications

Salesforce

Feature Availability: This feature is available in Cloud Dataprep Premium by TRIFACTA® INC.

Supported Versions: n/a

Supported Environments:

  • Read: Supported
  • Write: Not supported.

Create New Connection:

UI:




Cloud Dataprep by TRIFACTA INC.

BigQuery

Enable: Automatically enabled.

Create New Connection: n/a

Google Cloud Storage

Enable: Automatically enabled.

Create New Connection: n/a