August 2018link
PingOne SAML Supportlink
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 Historylink
A new sync history section has been added to the integration details page in your Fivetran dashboard. It displays a timeline of your recent syncs, including sync status, start time, and end time.
New connectorslink
Azure Functionslink
Azure Functions is a serverless computing platform that runs code in response to events and automatically manages the compute resources required by that code.
Link to Azure Functions documentation
Confluent Cloudlink
Confluent Cloud is a managed distributed streaming platform.
Link to Confluent Cloud documentation
Criteolink
Criteo is a retargeted advertising platform.
Greenhouselink
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.
Link to Greenhouse documentation
Microsoft Advertisinglink
Microsoft Advertising leverages the power of data and AI technologies to create better customer experiences.
See our Microsoft Advertising documentation for details.
Salesforce Marketing Cloudlink
Salesforce Marketing Cloud provides digital marketing automation, analytics, and lead management for B2B and B2C companies.
Link to Salesforce Marketing Cloud documentation
Snapchat Adslink
Snapchat Ads is a multimedia messaging app.
Link to Snapchat Ads documentation
Taboolalink
Taboola develops and markets a service for online content publishers and advertisers that recommends digital content to website users.
Schema changeslink
Apple Search Adslink
We have renamed the following tables:
OLD NAME | NEW NAME |
---|---|
CAMPAIGN | CAMPAIGN_HISTORY |
AD_GROUP | AD_GROUP_HISTORY |
KEYWORD | KEYWORD_HISTORY |
NEGATIVE_KEYWORD | NEGATIVE_KEYWORD_HISTORY |
TARGETING_DIMENSIONS | TARGETING_DIMENSIONS_HISTORY |
Asanalink
- We have added a new table,
TASK_SECTION
, which is a join table of theTASK
andSECTION
tables. - We have deprecated the
section_id
column from theTASK
table.
Freshdesklink
We have added a new table, TICKET_TAG
.
HubSpotlink
We have added two new columns, attachedVideoOpened
and attachedVideoWatched
, to the ENGAGEMENT_EMAIL
table.
Mavenlinklink
We have added the column manager_id
to the ACCOUNT_MEMBERSHIP
table.
Shopifylink
We have added two new fields, cart_token
and checkout_token
, to the ORDER
table.
Zendesklink
The TICKET_FORM_HISTORY
table is now included in your Fivetran syncs.
Improvementslink
Amazon S3link
We can now sync data from public buckets.
Disable User Provisioning with SAMLlink
We now support the ability to disable user provisioning with SAML. To manage user provisioning, follow these SAML config instructions.
Functionslink
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.
Google Analyticslink
You can now set the Google Analytics connector to update more than once per day. You should note that Google Analytics provides intraday updates on a best-effort basis and does not guarantee them.
Mavenlinklink
Mavenlink 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 Warehouselink
String values will now be created as LONGTEXT
columns in the MySQL warehouse instead of VARCHAR
fields if they are not the primary key. We made this change to better handle MySQL's maximum row size limit.
Oraclelink
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 warehouses.
Verizon Medialink
We have released service version 1 of the Verizon Media connector, which includes the following new features:
We now sync all reporting data, which can be configured at the table level. Prior to setup, you'll need to select the dimensions and metrics for each reporting table.
We now sync account, campaign, ad group, and ad settings metadata as
_HISTORY
tables.
Link to Verizon Media documentation
Zendesklink
- 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.