October 2019

New connectors

Zendesk Sunshine

Zendesk Sunshine is an open and flexible CRM platform. It lets you seamlessly connect and understand all your customer data. It is fast, powerful and gives you the freedom to build whatever you want.

Read our Zendesk Sunshine connector documentation.

Schema changes

Greenhouse

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

Lever

We have added a new column, to_stage_index, to the CANDIDATE_STAGE_HISTORY table.

Pinterest Ads

We have made a number of schema changes to support Pinterest Ads API version 3:

• The new objective_type field has replaced the optimization_goal field in the CAMPAIGN_HISTORY table. We will support the optimization_goal field for the next three months, and then it will be deprecated.

• The deprecated bid_type field has been reformatted and renamed to billable_event in the AD_GROUP_HISTORY table.

• We have added the following fields to the tables below:

  • billable_event to the AD_GROUP_HISTORY table
  • creative_type to the PIN_PROMOTION_HISTORY table

• Pinterest has deprecated the following fields, so we have removed them from the tables below:

  • bid_type from the AD_GROUP_HISTORY table
  • campaign_type, bid_type, is_one_tap, and upgrade_status from the CAMPAIGN_HISTORY table
  • upgrade_status from the PIN_PROMOTION_HISTORY table

Salesforce Marketing Cloud

We have started syncing email data from the Content Builder API into the EMAIL table. This lets us fetch data that is not available through the SOAP API. This change adds the new column asset_type_id to the EMAIL table.

Shopify

We have added the following columns to the TRANSACTION table to support currency exchange rate adjustments:

• processed_at
• currency_exchange_id
• currency_exchange_adjustment
• currency_exchange_original_amount
• currency_exchange_final_amount
• currency_exchange_currency

We have added a new table, PRODUCT_IMAGE, which contains the following fields:

• id : A unique numeric identifier for the product image. (primary key)
• product_id : The ID of the product associated with the image. (foreign key, references the PRODUCT table)
• position : The order of the product image in the list. The first product image is at position 1 and is the "main" image for the product.
• width : Width dimension of the image which is determined on upload.
• height : Height dimension of the image which is determined on upload.
• created_at: The date and time when the product image was created.
• updated_at: The date and time when the product image was last modified.
• src : Specifies the location of the product image.
• alt : Alternative source if the main image does not exist.
• variant_ids : IDs of the variations of the product associated with the image.

You can read more about product images in Shopify's API documentation.

Stripe

For version 2 of the Stripe connector, we have added a new column, invoice_id, to the CHARGE table to support mapping between the CHARGE and INVOICE tables.

Improvements

Apple App Store

You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:

• 3 months
• 6 months
• 12 months (default)
• 24 months
• All time

Apple Search Ads

You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:

• 3 months
• 6 months
• 12 months (default)
• 24 months
• All time

Criteo

You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:

• 3 months
• 6 months
• 12 months (default)
• 24 months
• All time

Google Ad Manager

You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:

• 3 months
• 6 months
• 12 months (default)
• 24 months
• All time

Google Ads

You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:

• 3 months
• 6 months
• 12 months (default)
• 24 months
• All time

Google Campaign Manager 360

You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:

• 3 months
• 6 months
• 12 months (default)
• 24 months
• All time

Google Search Console

You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:

• 3 months
• 6 months
• 12 months (default)
• 24 months
• All time

Kustomer

You can now create Kustomer connectors through the Fivetran REST API.

Lever

We now sync the REQUISITION table during every data sync. Previously, we synced this table every 24 hours.

In the REQUISITION table, we have converted the target_hire_date column's data type from TIMESTAMP to INSTANT.

LinkedIn Ad Analytics

Fivetran now requests the following read-only permissions to support changes that LinkedIn recently made to their API permissions:

• r_ads: Retrieve member’s advertising accounts
• r_ads_reporting: Retrieve reporting for member’s advertising accounts

NOTE: You must re-authorize your LinkedIn Ad Analytics connectors in the Fivetran setup form to grant us these permissions. Re-authorizing with the new permissions will ensure your Linked In Ad Analytics connector continues to sync.

Microsoft Advertising

You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:

• 3 months
• 6 months (default)
• 12 months
• 24 months
• All time

MySQL

We are now rolling out support for BLOB, TINYBLOB, MEDIUMBLOB, LONGBLOB, and YEAR data types in version 4 of our MySQL connector.

We are now rolling out the ability to sync MySQL DATETIME columns to the destination as TIMESTAMP_NTZ columns for version 4 of our MySQL connector.

We have a fixed a bug that caused zeroed DATE and DATETIME values to sync incorrectly. MySQL allows 0000-00-00 and 0000-00-00 00:00:00 as values for DATE and DATETIME primary key columns respectively. Previously, we converted these values to 1970-01-01 and 1970-01-01 00:00:00. Therefore, zeroed times and the real values of 1970-01-01 and 1970-01-01 00:00:00 were mapped to the same value in the destination. Fivetran now converts these values as follows:

• DATE: from 1970-01-01 to -999999999-01-01
• DATETIME: from 1970-01-01 00:00:00 to -999999999-01-01 00:00:00

Oracle

The two-hour limit on importing tables has been removed resulting in fewer syncs appearing as "Rescheduled" in the dashboard.

Syncs that fail due to falling behind processing archive logs during the incremental update phase will appear as "Rescheduled" in the dashboard and are attempted again immediately. Previously, there was no indication of a problem.

These changes will be rolled out over the next month.

Outbrain

You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:

• 3 months
• 6 months
• 12 months (default)
• 24 months
• All time

Pinterest Ads

We have upgraded the connector to Pinterest Ads API version 3, since versions 1 and 2 of the API have been deprecated. For more details, see Pinterest Ads' API documentation.

PostgreSQL

We can now sync single and multidimensional JSON, JSONB, and HSTORE arrays.

We now require that the PostgreSQL database configuration parameter 'wal_sender_timeout' is set to 0 or greater than 10 minutes. The value is validated during the setup test.

Snapchat Ads

You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:

• Three months
• Six months
• 12 months (default)
• 24 months
• All time

Snowflake

Snowflake does not allow the following ANSI reserved keywords to be column names when they are capitalized:

• CONSTRAINT
• CURRENT_DATE
• CURRENT_TIME
• CURRENT_TIMESTAMP
• CURRENT_USER
• LOCALTIME
• LOCALTIMESTAMP

To ensure a valid column name, Fivetran converts the keyword to lowercase and encases it in double quotes (for example, LOCALTIME becomes "localtime"). When you query these columns, be sure to use the converted column name.

Taboola

You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:

• 3 months
• 6 months
• 12 months (default)
• 24 months
• All time

Verizon Media

You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:

• 3 months
• 6 months
• 12 months (default)
• 24 months
• All time