August 2018

PingOne SAML support

Fivetran is now available in the PingOne app catalog. To use PingOne SSO for Fivetran, install the Fivetran app in your PingOne account and follow these instructions to configure SAML in Fivetran.

Sync History

A new Sync History section has been added to the connection details page in your Fivetran dashboard. It displays a timeline of your recent syncs, including sync status, start time, and end time.

New connectors

Azure Functions

Azure Functions is a serverless computing platform that runs code in response to events and automatically manages the compute resources required by that code.

Read our Azure Functions connector documentation.

Confluent Cloud

Confluent Cloud is a managed distributed streaming platform.

Read our Confluent Cloud connector documentation.

Criteo

Criteo is a retargeted advertising platform.

Read our Criteo connector documentation.

Greenhouse

Greenhouse is an applicant tracking system and recruiting software designed to optimize your entire recruiting process. Find better candidates, conduct more focused interviews, and make data-driven hiring decisions.

Read our Greenhouse connector documentation.

Microsoft Advertising

Microsoft Advertising leverages the power of data and AI technologies to create better customer experiences.

Read our Microsoft Advertising connector documentation.

Salesforce Marketing Cloud

Salesforce Marketing Cloud provides digital marketing automation, analytics, and lead management for B2B and B2C companies.

Read our Salesforce Marketing Cloud connector documentation.

Snapchat Ads

Snapchat Ads is a multimedia messaging app.

Read our Snapchat Ads connector documentation.

Taboola

Taboola develops and markets a service for online content publishers and advertisers that recommends digital content to website users.

Read our Taboola connector documentation.

Schema changes

Apple Search Ads

We have renamed the following tables:

Asana

We have added a new table, TASK_SECTION, which is a join table of the TASK and SECTION tables.

We have deprecated the section_id column from the TASK table.

Freshdesk

We have added a new table, TICKET_TAG.

HubSpot

We have added two new columns, attachedVideoOpened and attachedVideoWatched, to the ENGAGEMENT_EMAIL table.

Kantata

We have added the manager_id column to the ACCOUNT_MEMBERSHIP table.

Shopify

We have added two new fields, cart_token and checkout_token, to the ORDER table.

Zendesk Support

We now sync ticket metric event data in the TICKET_METRIC_EVENT table.

We now sync SLA policy data in the SLA_POLICY_HISTORY table.

We now sync SLA policy metric data in the SLA_POLICY_METRIC_HISTORY table.

We now include the TICKET_FORM_HISTORY table in your syncs.

Improvements

Amazon S3

We can now sync data from public buckets.

Disable User Provisioning with SAML

We now support the ability to disable user provisioning with SAML. To manage user provisioning, follow these SAML config instructions.

Functions

We now limit function triggers to six hours maximum per sync. Any records that were not fetched in that six hour period will be fetched in the next update cycle.

Kantata

Kantata does not track deletes for the TIME_ENTRIES table, but Fivetran has a way to identify your deleted time entries. We re-sync the entire TIME_ENTRIES table every day, so our system can infer that any record that wasn’t updated with the re-sync must have been deleted. Each deleted record will be marked as true in the _fivetran_deleted column of this table.

MySQL destination

STRING values will now be created as LONGTEXT columns in the MySQL destination instead of VARCHAR fields if they are not the primary key. We made this change to better handle MySQL's maximum row size limit.

Oracle

For Oracle connectors, TIMESTAMP data types will now be represented as TIMESTAMP WITHOUT TIME ZONE types in the destination. Since DATE column types are also timezone unaware, dates that lack a time component will be interpreted as TIMESTAMP WITHOUT TIME ZONE types as well. This update is currently only available for Snowflake destinations.