Page tree

Trifacta SaaS



Contents:

   

Contents:


Feature Availability: This feature may not be available in all product editions.

Trello  is a visual collaboration tool that enables you to organize and prioritize projects in a flexible and rewarding way. For more information, see https://trello.com/en-US.

Early Preview connection: This connection is in early preview. It is read-only and available only in SaaS product editions. For more information on early previews, see Early Preview Connection Types.

Limitations and Requirements

NOTE: During normal selection or import of an entire table, you may encounter an error indicating a problem with a specific column. Since some tables require filtering based on a particular column, data from them can only be ingested using custom SQL statements. In this case, the problematic column can be used as a filter in the WHERE clause of a custom SQL statement to ingest the table.

  • For more information, please consult the CData driver documentation for the specific table.
  • For more information on using custom SQL, see Create Dataset with SQL.

NOTE: For filtering date columns, this connection type supports a set of literal functions on dates. You can use these to reduce the volume of data extracted from the database using a custom SQL query. For more information, see the pg_dateliteralfunctions.htm page in the driver documentation for this connection type.

  • Supports authentication using API Key with token (API Key / Token). Information on acquiring the APIKey is provided below.

Create Connection

via Trifacta application

When you create the connection, please review the following properties and specify them accordingly:

Connection PropertyDescription
API Key

The Trello API key. For more information on obtaining these credentials, see http://cdn.cdata.com/help/UTG/jdbc/pg_authorizationroute.htm

Token

The token value associated with the API key. For more information on obtaining these credentials, see http://cdn.cdata.com/help/UTG/jdbc/pg_authorizationroute.htm

Connect String Options

The following default value sets the connection timeout in seconds:

Timeout=0;

Setting this value to 0 disables timeouts.

Default Column Data Type InferenceLeave this value as Enabled.

For more information, see the driver documentation http://cdn.cdata.com/help/UTG/jdbc/default.htm.

via API

Depending on your product edition, you can create connections of this type. Key information:

"vendor": "trello",
"vendorName": "Trello",
"type": "jdbc"

For more information, see

Trifacta API Reference docs: Enterprise | Professional | Premium

Data Type Conversions

For more information, see the driver documentation http://cdn.cdata.com/help/UTG/jdbc/default.htm.

See Also for Trello Connections:

There is no content with the specified labels

This page has no comments.