November 2018

Customer triggered table re-syncs

You can now trigger re-syncs of individual tables from your Fivetran dashboard:

The re-sync button appears when you hover your cursor over the row that contains the table name.

This feature is available for the following connectors:

• Amazon DynamoDB
• MongoDB
• MySQL
• NetSuite SuiteAnalytics
• Oracle
• PostgreSQL
• Salesforce
• SQL Server
• Zuora

TLS certificate verification changes

You are no longer able to configure self-signed certificates for destination connectors. We plan to release new UI tools in the coming weeks to empower security teams to register and pin certificate authorities with Fivetran.

New connectors

Lever

Lever is a modern recruiting software that streamlines the hiring process and simplifies the applicant tracking system.

Read our Lever connector documentation.

ServiceNow

ServiceNow is a cloud platform that provides service management software as a service.

Read our ServiceNow connector documentation.

Schema changes

Greenhouse

We have added a new column, name, to the JOB table.

We have added two new columns, start and end, to the SCHEDULED_INTERVIEW table.

Iterable

We have replaced the locale_name column with locale in the following tables:

• EMAIL_TEMPLATE_HISTORY
• EVENT_EXTENSION
• PUSH_TEMPLATE_HISTORY
• SMS_TEMPLATE_HISTORY

Microsoft Advertising

We no longer use brand as the primary key for the following tables since it can have a null value in the Bing Ads API response:

• PRODUCT_DIMENSION_PERFORMANCE_HOURLY_REPORT
• PRODUCT_DIMENSION_PERFORMANCE_DAILY_REPORT
• PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_HOURLY_REPORT
• PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_DAILY_REPORT

This change affects version 1 and version 2 of the Bing Ads API.

Salesforce Marketing Cloud

We have added a new column, version, to the JOURNEY table.

ServiceNow

We have removed the suffix _HISTORY from all table names.

Taboola

We have designated _fivetran_id as the only primary key in all REPORT tables to account for null values in other fields.

Zendesk Support

We have dropped the deleted column from the GROUP table.

Improvements

AWS CloudWatch

You can now have a space in your log group name without causing problems in your Fivetran dashboard.

Help Scout

We have increased the Help Scout API rate limit, allowing us to easily retry our API connections when failures occur.

Intercom

We have released a new version of the Intercom connector, now with an improved schema. You can find additional information in our Intercom documentation.

Thanks to leveraging Intercom webhooks, we now support the delete function in the following tables:

• USER_HISTORY
• LEAD_HISTORY
• ADMIN
• TEAM
• SEGMENT_HISTORY
• TAG

Jira

We have added support for OAuth, as Jira is deprecating basic authentication with password.

Microsoft Advertising

We have released version 2 of the Microsoft Advertising connector, which allows you to fetch HOURLY reports.

MySQL

We have identified and fixed an extremely rare bug that can cause data to be missed during binary log replication. The bug meant that, in some cases, our system believed that all data had been successfully synced, when the binary log replication process had actually stopped prematurely.

NetSuite SuiteAnalytics

We have fixed the incremental update of child tables. All child tables of child tables will also be updated recursively. For example, if the TRANSACTIONS table is updated, then its child table TRANSACTION_LINES will be updated, along with TRANSACTION_LINES's own child tables BIN_NUMBER and BIN_NUMBER_COUNTS.

ServiceNow

The ServiceNow connector can now sync tables which do not have sys_updated_on or sys_created_on columns.

Taboola

We have improved the Taboola connector's capacity to support very large data files.

Webhooks

We have added GZIP support for Webhook API requests.