February 2019link
Per Group SSH Keyslink
Fivetran now uses SSH keys entirely unique to your destination while creating any SSH tunnel connections.
Find the key in your Destination Setup Page and add it to authorized keys on your SSH tunnel server. See detailed instructions in our SSH Tunnel Configuration docs.
New connectorslink
Azure MariaDBlink
Azure Database for MariaDB is a MariaDB database service built on Microsoft's scalable cloud infrastructure for application developers.
Link to Azure MySQL Documentation
Azure MySQLlink
Azure Database for MySQL is a MySQL database service built on Microsoft's scalable cloud infrastructure for application developers.
Link to Azure MySQL Documentation
Lightspeed Retaillink
Lightspeed Retail is a cloud-based point of sale (POS) solution that is suitable for retailers.
Link to Lightspeed Retail Documentation
LinkedIn Ad Analyticslink
We have released a new version of the LinkedIn Ad Analytics connector. The new version delivers Ad Analytics reports at campaign
and creative
levels. The schema change adds metadata tables in addition to report tables.
Link to LinkedIn Ad Analytics Documentation
Splunklink
Splunk is a software platform that searches, analyzes and visualizes the machine-generated data gathered from websites, applications, sensors, and devices.
Schema changeslink
Amplitudelink
Added a new table EVENT_AMPLITUDE_ATTRIBUTION_ID
. Changed the primary key from user_id
to amplitude_id
and project_name
in USER
table.
Apple Search Adslink
In the CAMPAIGN_HISTORY
table changed the loc_invoice_detail_order_number
column from Integer to String.
Iterablelink
- The
USER_MESSAGE
table is deprecated. We will stop syncing this table after March 15, 2019. - Added new field
workflow_id
toCAMPAIGN_HISTORY
table.
Jiralink
The PROJECT
table will have key
and project_type_key
columns either after resync or for all new Jira connectors.
Marketolink
Fivetran now fetches lead activities following the Marketo Activities Data Retention Policy.
High volume activities are fetched for the past 90 days. This includes following activities:
- Add to List
- Change Score
- Change Data Value
- Visit Webpage
- Sync Lead to SFDC
- Sync Lead to Microsoft
- Update Opportunity
- Request Campaign
All other activities are fetched for the past 25 months.
Mavenlinklink
- The
ASSIGNMENT
table is re-synced once a day to detect deleted records. - The
RATE_CARD
table is deprecated and will be removed after March 20, 2019. - Added
RATE_CARD_HISTORY
to replaceRATE_CARD
andRATE_CARD_SET_HISTORY
tables.
Microsoft Advertisinglink
Added new table AD_ATTRIBUTE_HISTORY
.
Optimizelylink
We released a new version of the Optimizely connector.
- Renamed the existing
EVENT
table toVISITOR_ACTION
table. - Added a new
EVENT
table that syncs from/v2/events
. - Converted existing tables
EXPERIMENT
,EXPERIMENT_PAGE
,CAMPAIGN
andCAMPAIGN_PAGE
toHISTORY
tables. - Dropped tables
EXPERIMENT_STATUS
andCAMPAIGN_STATUS
. - Separated existing
METRIC
table intoEXPERIMENT_METRIC_HISTORY
andCAMPAIGN_METRIC_HISTORY
table. - Added field
event_id
inEXPERIMENT_METRIC_HISTORY
andCAMPAIGN_METRIC_HISTORY
table. - Separated existing
CHANGE
table intoEXPERIMENT_CHANGE_HISTORY
andCAMPAIGN_CHANGE_HISTORY
table.
PostgreSQLlink
TIMESTAMP
column types will now be represented asTIMESTAMP WITHOUT TIME ZONE
in the destination.TSRANGE
columns will be represented as JSON, with timestamps without timezones encoded as strings.
Salesforce Marketing Cloudlink
We dropped the following fields from the TRIGGERED_SEND
table:
cc_email
interaction_id
is_always_on
is_send_logging
pre_header
replyto_address
replyto_display_name
send_window_delete
Shopifylink
Added 4 new tables:
DRAFT_ORDER
DRAFT_ORDER_NOTE_ATTRIBUTE
DRAFT_ORDER_LINE
DRAFT_ORDER_LINE_TAX_LINE
Twitter Adslink
We upgraded Twitter Ads API version to v4. Read more about their new version on Twitter's documentation. This upgrade means the following changes to the schema:
- Removed
VIDEO_HISTORY
andVIDEO_REASON_HISTORY
tables as Twitter deprecated thevideos
endpoint. - Removed column
preview_url
from tableCARD_HISTORY
. - From now on the column
app_country_code
of tableCARD_HISTORY
will be delivered ascountry_code
.
UserVoicelink
- Renamed
MESSAGE
table toSUPPORTER_MESSAGE
.
Xerolink
- Made the field
invoice_id
the Primary Key in the table_INVOICE_LINE_ITEM
. - Made the field
overpayment_id
the Primary Key in the table_OVERPAYMENT_LINE_ITEM
. - Made the field
prepayment_id
the Primary Key in the table_PREPAYMENT_LINE_ITEM
. - Made the field
repeating_invoice_id
the Primary Key in the table_REPEATING_INVOICE_LINE_ITEM
.
Fivetran will not store the deleted line_item records
for the above tables.
Zendesklink
Added new TICKET_CUSTOM_FIELD
table with id
and title
fields. For custom fields, TICKET_FIELD_HISTORY.field_name
is a field id that references TICKET_CUSTOM_FIELD.id
.
Improvementslink
DynamoDBlink
You are now able to resync individual tables from the dashboard.
Google Analyticslink
In Service Version 1 of our Google Analytics connector instead of doing a rollback sync for the last 30 days, now we use a trailing window of 1, 7, 15, and 30 days in order to reduce Google Analytics Reporting API(v4) requests.
HubSpotlink
New fields in ENGAGEMENT_*
tables will be synced automatically.
Microsoft Advertisinglink
Added support for the new Ad Type Responsive Search Ad
. We have upgraded V0
of our Bing Ads connector to use the latest Bing Ads SDK v.12
as the previous version v.11
is deprecated.
Deprecated Fieldslink
The AccountStatus
field has been deprecated for CAMPAIGN_PERFORMANCE
and AD_GROUP_PERFORMANCE
report types.
Renamed Fieldslink
The following fields have been renamed. These renamed fields are updated in your setup form but the column names in your destination remain unchanged.
Old Field Name | New Field Name |
---|---|
HistoricQualityScore | HistoricalQualityScore |
HistoricExpectedCtr | HistoricalExpectedCtr |
HistoricAdRelevance | HistoricalAdRelevance |
HistoricLandingPageExperience | HistoricalLandingPageExperience |
FinalAppURL | FinalAppUrl |
FinalMobileURL | FinalMobileUrl |
FinalURL | FinalUrl |
Microsoft Dynamics 365 CRMlink
The tables that do not support Change Tracking will be shown as Not Recommended in Standard Config.
SQL Serverlink
Tables with clustered indices are now queried using smaller page sizes. This reduces the contiguous length of time that a Fivetran connector has a lock on a table from which it's reading, without adversely affecting sync speeds.