July 2018

New destination

We now support Azure Synapse.

OneLogin SAML support

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

New connectors

Heroku Kafka

Heroku Kafka is a managed distributed streaming platform.

Read our Heroku Kafka connector documentation.

Outbrain

Outbrain is a native advertising platform using targeted advertising to recommend articles, slideshows, blog posts, photos or videos to a reader.

Read our Outbrain connector documentation.

Twitter Ads

Twitter Ads provides a history of the settings and detailed reports of your Twitter Ad Accounts, Campaigns, Line Items, Tweets, and Media Creatives.

Read our Twitter Ads connector documentation.

UserVoice

UserVoice is product feedback management software that enables businesses gather and analyze customer feedback and prioritize feature requests to drive strategic product decisions.

Read our UserVoice connector documentation.

Schema changes

Asana

We have removed the STORY_EVENT table.

Google Search Console

We have split the SITE_REPORT table into two separate tables, SITE_REPORT_BY_PAGE and SITE_REPORT_BY_SITE.

HubSpot

We have added the media_processing_status column to the ENGAGEMENT_EMAIL table.

Intercom

We have added the conversation_rating column to the CONVERSATION table.

Pardot

We have added custom_* columns to the CAMPAIGN table.

QuickBooks

We have added two new columns, estimate_id and time_activity_id, to the INVOICE_LINKED_TXN table.

Zendesk Support

We have added a new table, DOMAIN_NAME.

We now sync schedule_id data for tickets in a new table called TICKET_SCHEDULE.

Improvements

Avro files support

We now support Avro files in all file replication connectors.

Files

We now support all UTF encodings without BOM and Windows-1252.

Google Ads

We have upgraded the Adwords API from v201710 to v201806 and handled deprecated fields.

• The bidtype field has been deprecated.
• The shopping_universal_ads field has been renamed shopping_goal_optimized_ads.

For additional details, see Adwords' API deprecation schedule.

Help Scout

In the CONVERSATION table, the custom field type dropdown now contains the label value.

Mandrill

You can now view the list of schemas and tables in your dashboard in read-only mode.

MySQL

You can now customize the replica ID used to access your database's binary logs. By default, the replica ID is a random integer greater than 1000.

Pinterest Ads

The Pinterest Ads connector now syncs ITEM and PIN_PROMOTION_TARGETING reports.

The Pinterest Ads connector now syncs the following advertising reports:

• Advertiser
• Campaigns
• AdGroups
• Pin Promotions
• Product Groups

Read our Pinterest Ads connector documentation.

Redshift

We no longer sync system columns, such as oid, to your Redshift destination.

Webhooks

We now support writing the data collected from webhook events to your S3 bucket in JSON format as a permanent store.