Fivetran-enabled data sources

Fivetran is a third-party application that collects data from a wide variety of sources, and then loads that data to Snowflake tables. This data can be made available to Amperity from those Snowflake tables.

Why does Amperity use Fivetran?

Amperity uses Fivetran to enable a wide variety of data sources. This is for many reasons.

  1. Customers may choose to centralize their data on Snowflake, regardless of the built-in sources that Amperity offers.

  2. Customers may require data sources that are not built-in to Amperity, but are availble from Fivetran.

  3. Customers may require the ability to use SQL to query against a Snowflake table before loading data to Amperity. (This is a feature that is built into Snowflake data source in Amperity.)

How Fivetran-enabled sources work

Every Fivetran-enabled workflow is different. Some workflows require permission to intstall Fivetran into your application. Some workflows require an SSH tunnel during the configuration process to enable database interactions. Once configured in Fivetran, all Fivetran-enabled sources use an Amperity built-in Snowflake connector.

Pull data to Amperity from Fivetran.

A Fivetran-enabled data source generally works like this:

  1. Fivetran is configured to pull data from a data source. This process will require allowing Fivetran the right level of access to pull that data from your data source to Fivetran.

  2. Fivetran pulls that data into one (or more) Snowflake tables.

    Important

    Fivetran does not store any data that is pulled to Amperity from any Fivetran-enabled data source.

  3. Amperity is configured to pull data to Amperity from those Snowflake tables.

  4. Domain tables within Amperity are refreshed.

  5. Customer profiles are made available to Stitch. All data is passed to your customer 360 database. The Amperity ID links records across data sources for each unique customer.

Tip

There are a number of Fivetran-enabled data sources that may be configured directly from the Amperity user interface. The following data sources do not require Snowflake and do not require using Fivetran:

Fivetran-enabled sources

Amperity does not document every Fivetran-enabled data source workflow on its own page, with the following exceptions: Adobe Commerce (Magento), HubSpot, Kustomer, Salesforce Pardot, and Square. This group of topics describes the specific steps that are required for those data sources, including the steps you must do in Fivetran and the steps you must do in Amperity. This group of topics is represenatitive of the typical end-to-end configuration process that is required by many Fivetran-enabled data sources.

Caution

The documentation for how to configure each Fivetran-enabled data source is availble from Fivetran. Please use link in the “Fivetran Docs” column in the table below to open that page and to learn more about how to configure that data source for Fivetran.

All of the configuration requirements and steps for each Fivetran-enabled data source are found on the page for that data source within Fivetran documentation. Use the link in the table below to open that data source’s page within the Fivetran documentation site.

All configuration requirements for connecting a data source to Fivetran are specified in Fivetran documentation. Be sure to review those requirements. In a scenario where your Amperity representative will configure Fivetran on your behalf, you will need to provide to your Amperity representative those details.

Amperity uses a well-documented Snowflake connector (Snowflake on AWS or Snowflake on Azure) to pull data from Fivetran for all Fivetran-enabled data sources.

The following table is a list of Fivetran-enabled data sources. You must first configure these data sources to make their data available to Fivetran (and load that data successfully to Fivetran) before you can use a Snowflake connector in Amperity to pull that data to Amperity.

Fivetran docs

Description

Adjust

Adjust

Adjust is an analytics platform that helps marketers grow their mobile apps with solutions for measuring and optimizing campaigns and protecting user data.

Adobe Analytics

Adobe Analytics

Adobe Analytics provides useful intelligence about customer activity on Web sites and mobile devices. Marketers can analyze clickstream data to understand what their customers are doing in real-time, and then optimize customer experiences across brands.

AdRoll

AdRoll

AdRoll is an advertising platform that helps companies grow revenue through seamless marketing and ads.

Airtable

Airtable

Airtable works like a spreadsheet but gives you the power of a database to organize anything.

Amazon Ads

Amazon Ads

Amazon Ads is an online advertising platform that helps brands meet their audiences where they shop, read, listen, and watch.

Amazon Aurora MySQL

Amazon Aurora MySQL

Amazon Aurora PostgreSQL

Amazon Aurora is a MySQL- and PostgreSQL-compatible relational database built for the cloud.

Amazon Cloudfront

Amazon Cloudfront

Amazon CloudFront is a global content delivery network (CDN) service that securely delivers data, videos, applications, and APIs to your viewers with low latency and high transfer speeds.

Amazon DynamoDB

Amazon DynamoDB

Amazon DynamoDB is a fast and flexible NoSQL database service for all applications that need consistent, single-digit millisecond latency at any scale.

Amazon S3

Amazon S3

Amazon Simple Storage Service (Amazon S3) stores customer data files of any size in any file formats.

Amplitude

Amplitude

Amplitude is a self-service digital analytics platform to understand your users, drive conversions, and increase engagement, growth and revenue.

Apache Kafka

Apache Kafka

Apache Kafka is an open-source distributed event streaming platform used for high-performance data pipelines, streaming analytics, data integration, and mission-critical applications.

Apache Kafka on Heroku

Apache Kafka on Heroku

Heroku Kafka is a managed distributed event streaming platform that runs Apache Kafka.

Apple Search Ads

Apple Search Ads

Apple Search Ads helps people discover your app on the App Store, matching customers with your app at the right moments.

AppsFlyer

AppsFlyer

AppsFlyer is a mobile app tracking and attribution analytics platform that helps drive predictable app growth, protects customer privacy and delivers exceptional mobile experiences.

Atlassian Jira

Atlassian Jira

Atlassian Jira is an application designed for issues tracking, project management, and follow-through.

AWS Kinesis

AWS Kinesis

Amazon Kinesis Data Firehose is a fully managed service for delivering real-time streaming data to Amazon S3.

AWS Lambda

AWS Lambda

AWS Lambda runs code for any type of application or backend service that can be configured to run automatically from within Amazon Web Services to support any downstream workflow.

Azure Cloud Functions

Azure Cloud Functions

Azure Functions is a serverless compute service that enables you to run code on-demand without having to explicitly provision or manage infrastructure.

BigCommerce

BigCommerce

BigCommerce is an all-in-one tool used to build storefronts, optimize product searches, and convert shoppers into customers.

Box

Box

Box is a cloud-based file storage service that enables secure data sharing with anyone, anywhere, on any device.

Braintree Payments

Braintree Payments

Braintree – a payment platform from PayPal – provides payment systems for brands that use mobile app- and web-based shopping experiences.

Branch

Branch

Branch is a mobile measurement and deep linking platform that unifies user measurement across devices, platforms, and channels.

Braze

Braze

Braze is a leading marketing automation platform that allows users to create custom experiences based on sophisticated customer attributes and segments, then map those experiences to campaigns.

Campaign Manager

Campaign Manager

Campaign Manager is a web-based ad management system for advertisers and agencies that helps you manage your digital campaigns across websites and mobile devices.

Coupa

Coupa

Coupa is a cloud platform for business spend management. Coupa delivers measurable value through real-time spend visibility, control, compliance, and agility.

Criteo

Criteo

Criteo is a commerce media platform that helps marketers and media owners manage and scale campaigns. Send audiences to Criteo, and then advertise to customers across paid media, including connected TV (CTV), banner ads, and video ads.

Delighted

Delighted

Delighted creates and sends customer experience surveys, tracks and analyzes feedback, and then helps you take action.

Dropbox

Dropbox

Dropbox is a file hosting service that offers cloud storage, file synchronization, personal cloud, and client software.

Facebook Ads

Facebook

Ads on Facebook appear in a variety of locations, including the news feed and within the right-side column on pages. Use Meta Ads Manager to manage ad placements on Facebook.

FinancialForce

FinancialForce

FinancialForce is a Salesforce-native cloud ERP application that gives you a complete, customer-centric view of your business.

Github

Github

GitHub is a platform for developers to build personal projects, support their businesses, and work together on open source technologies.

Gladly

Gladly

Gladly is a customer service platform that is people-centric, not case-centric. Instead of tickets, Gladly manages a single, lifelong conversation with each of your customers.

Google Ads

Google Ads

Google Ads is search-based advertising that can be run across the Google advertising network and is shown to web users. Use search-based advertising to promote your brand, help sell products or services, raise awareness, and increase traffic to your website or stores.

Google Analytics

Google Analytics

Google Analytics 360

Google Analytics 4

Google Analytics 4 Export

Google Analytics is an events- and session-based analytics service that collects data from websites and apps. Google Analytics 4 properties support privacy controls, such as cookieless measurement, and can be integrated directly on websites and apps to help your brand better understand the customer journey.

Google Cloud Functions

Google Cloud Functions

Google Cloud Functions is a serverless computing platform that runs code in response to events and automatically manages the compute resources required by that code.

Google Cloud Storage

Google Cloud Storage

Google Cloud Storage is an online file storage web service for storing and accessing data on Google Cloud Platform infrastructure.

Google Play

Google Play

Google Play syncs reports about individual Android apps to help track and understand your application’s performance.

Google Search Console

Google Search Console

Google Search Console helps you monitor and maintain your site’s presence in Google Search results.

Google Sheets

Google Sheets

Google Sheets lets you create a new spreadsheet and edit it with others at the same time — from your computer, phone or tablet.

Heap

Heap

Heap is a digital insights platform that helps you understand how and why customers engage with your product. Heap automatically collects all customer data from your site or app, then provides direction on the improvements that you can make.

Height

Height

Height is a collaborative work service that helps to maintain a project workflow.

Help Scout

Help Scout

Help Scout is an all-in-one customer service platform that helps you balance everything your customer needs.

Hubspot

Hubspot

HubSpot is a CRM platform built around dedicated hubs for marketing, sales, services, content management, and operations.

Instagram Business

Instagram Business

Instagram Business enables creators and companies to connect with a variety of audiences at scale, and track their social media engagement metrics.

Intercom

Intercom

Intercom brings messaging products for sales, marketing and customer service to one platform, helping businesses have conversations with customers.

Iterable

Iterable

Iterable enables brands to create, execute and optimize campaigns across email, push, SMS, in-app and more with unparalleled data flexibility.

Klaviyo

Klaviyo

Klaviyo is an email platform for targeting, personalizing, measuring, and optimizing email and Facebook campaigns.

Kustomer

Kustomer

Kustomer is a platform for customer experience, service, and support that provides a complete picture of your customer when they contact your company.

Lightspeed

Lightspeed

Lightspeed Retail is a cloud-based point of sale (POS) solution that is suitable for retailers.

LinkedIn Ads

LinkedIn Ads

Linkedin Company Pages

LinkedIn is a social media network focused on professional relationship, business listings, and employment opportunities.

Magento via MySQL

Magento via MySQL

Magento via MySQL Amazon RDS

Magento is an ecommerce platform which provides online merchants with a flexible shopping cart system, and customization of their online store. Magento is now Adobe Commerce.

Mailchimp

Mailchimp

Mandrill

Mailchimp provides marketing automation and email marketing services for e-commerce businesses.

MariaDB

MariaDB

MariaDB on Amazon RDS

MariaDB on Azure Database

MariaDB offers open source database and database as a service (DBaaS) solutions to support scalability, mission-critical deployments, and more.

Marin Software

Marin Software

Marin Software is an online advertising platform to measure, manage, and optimize ad spending across the web and mobile devices.

Marketo

Marketo

Marketo provides inbound marketing, social marketing, CRM, and other related services.

Mavenlink

Mavenlink

Mavenlink offers online project management with time tracking, resource planning, collaboration, finance etc. functions.

Medallia

Medallia

Medallia is a customer feedback management software platform that enables organizations to collect customer feedback and improve the customer experience.

Microsoft Advertising

Microsoft Advertising

Microsoft Advertising is a pay-per-click advertising platform that displays ads based on keywords in a user’s search query.

Microsoft Azure Blob Storage

Microsoft Azure Blob Storage

Azure Blob Storage is an object storage solution for the cloud that is optimized for storing massive amounts of unstructured data.

Microsoft Azure SQL Database

Microsoft Azure SQL Database

Microsoft Azure SQL Database is the intelligent, fully-managed relational cloud database service built for developers.

Microsoft Dynamics 365

Microsoft Dynamics 365

Microsoft Dynamics AX

Microsoft Dynamics CRM

Microsoft Dynamics GP

Microsoft Dynamics NAV

Microsoft Dynamics 365 is a suite of products that connects people, products, and data and helps transform the way your company does business.

Mixpanel

Mixpanel

Mixpanel provides an advanced analytics platform for tracking user actions on web and mobile.

MongoDB

MongoDB

MongoDB Sharded

MongoDB is a free and open-source cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with schemas.

MySQL Database

MySQL Database

MySQL on Azure Database

MySQL on Google Cloud SQL

MySQL on RDS

MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter My, and “SQL”, the abbreviation for Structured Query Language.

Optimizely

Optimizely

Optimizely is an experimentation platform for testing, learning, and deploying positive digital experiences.

Oracle

Oracle

Oracle on Amazon RDS

Oracle EBS

Oracle Eloqua

Oracle Fusion Cloud Applications — CX

Oracle Fusion Cloud Applications — ERP

Oracle Fusion Cloud Applications — HCM

Oracle Fusion Cloud Applications — SCM

Oracle PeopleSoft

Oracle RAC

Oracle Siebel CRM

Oracle is an enterprise-scale and priced relational database with a wide variety of business applications and services.

Oracle Netsuite

NetSuite SuiteAnalytics

Oracle Netsuite offers built-in real-time dashboards, reporting, and analysis all integrated right into the ERP, CRM or e-commerce application that you use every day. Previously called Netsuite SuiteAnalytics.

OsCommerce via MySQL

OsCommerce via MySQL

OsCommerce is an e-commerce and online store-management software program. It can be used on any web server that has PHP and MySQL installed.

Outbrain

Outbrain

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

Pendo

Pendo

Pendo helps product teams understand and guide users to create product experiences.

Pipedrive

Pipedrive

Pipedrive is a sales CRM and pipeline management solution that enables businesses to plan their sales activities and monitor deals.

Pinterest Ads

Pinterest Ads

Pinterest Ads helps businesses increase brand’s visibility and drive conversions.

PostgreSQL Database

PostgreSQL Database

PostgreSQL on Azure Database

PostgreSQL on Google Cloud

PostgreSQL on RDS

PostgreSQL is one of the world’s most popular open source relational databases.

PrestaShop

PrestaShop

PrestaShop via MySQL

PrestaShop is an ecommerce toolkit that helps you sell your products online.

Qualtrics

Qualtrics

Qualtrics is an online survey tool that helps organizations build and distribute surveys, and then analyze responses.

ReCharge

ReCharge

Recharge is a recurring billing and subscriptions service for ecommerce stores that use Shopify.

Recurly

Recurly

Recurly provides a recurring billing and subscriptions solution for e-commerce.

Reddit Ads

Reddit Ads

Reddit is home to unique communities, engaged conversations, and the best memes. Reddit Ads allows brands to find their community on Reddit, and then engage with your customers within the 100K+ active communities on Reddit using targeted ads and promoted posts.

Sage Intacct

Sage Intacct

Sage Intacct provides real-time financial and operational insights, as well as the ability to automate critical processes.

Sailthru

Sailthru

Sailthru is a cross-channel marketing platform built to deliver personalized experiences for consumers across email, web, and mobile channels.

Salesforce

Salesforce

Salesforce Commerce Cloud

Salesforce Marketing Cloud

Salesforce Pardot

Salesforce is a platform that is focused on customer success. Social and mobile cloud technologies -— including flagship sales and CRM applications -— help companies connect with customers in new ways.

SAP

SAP Business ByDesign

SAP Concur

SAP ERP (S/4 HANA)

SAP stands for System Applications and Products in Data Processing. SAP is a market leader in ERP software and helps companies of all sizes.

Segment

Segment

Segment is a platform that collects customer data across devices and channels, sends it to third-party tools, internal systems, or SQL databases.

Sendgrid

Sendgrid

SendGrid is a customer communication platform for transaction- and marketing-focused emails.

ServiceNow

ServiceNow

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

SFTP

SFTP

Secure File Transfer Protocol (SFTP) is a network protocol that provides file access, file transfer, and file management over a reliable data stream. Also available: FTP , FTPS , CSV Browser Upload , and Email Ingestor .

Shopify

Shopify

Shopify is an ecommerce platform for online stores and retail point-of-sale systems that consolidates shopping, payments, marketing, shipping, and customer engagement tools into a single unified experience.

Snapchat Ads

Snapchat Ads

Snapchat is a social media platform that allows users to access pictures and messages for a short time. Snapchat provides a self-serve platform from which brands can manage ads and advertising campaigns.

Snowplow Analytics

Snowplow Analytics

Snowplow Analytics provides enterprise-level event analytics that is powered by the open source Snowplow platform.

Spree Commerce via MySQL

Spree Commerce via MySQL

Spree Commerce is an API-driven ecommerce framework.

SQL Server

SQL Server

SQL Server on RDS

Microsoft’s SQL Server is a powerful enterprise relational database.

Square

Square

Square is a platform for managing online stores, payments, and transactions.

Stripe

Stripe

Stripe is a software platform for businesses of all sizes. Stripe provides transaction histories for all of your online payments.

Taboola

Taboola

Taboola helps people find relevant content online, matching them with news stories, articles, blogs, videos, apps, products and other content they’re likely to want to explore.

TikTok Ads

TikTok Ads

TikTok is the world’s leading destination for short-form mobile videos. TikTok’s mission is to capture and present the world’s creativity, knowledge, and moments that matter in everyday life.

Twilio

Twilio

Twilio powers the future of business communications. Enabling phones, VoIP, and messaging to be embedded into web, desktop, and mobile software.

Twitter Ads

Twitter Ads

Twitter Analytics

Twitter is a social media and online news website that allows marketers and brands to advertise on its platform. Capture data about popular content, retweets, social shares and more for advanced analytics.

Typeform

Typeform

Typeform is an online survey management solution that lets you create forms, surveys, and quizzes that your customers will enjoy answering.

UserVoice

UserVoice

UserVoice gathers and analyzes customer feedback, and then helps you prioritize feature requests that drive product improvements.

Webhooks

Webhooks

A webhook is a user-defined HTTP callback that is activated by an event that occurred on your website or within your application.

WooCommerce

WooCommerce

WooCommerce via MySQL

WooCommerce is a customizable, open-source e-commerce platform that turns your WordPress into an online store.

Workday

Workday

Workday HCM

Workday offers enterprise-level software solutions for financial management, human resources, and planning.

Xero

Xero

Xero accounting software helps to manage invoicing, bank reconciliation, bookkeeping, and more.

Yahoo Gemini (Verizon Media)

Yahoo Gemini (Verizon Media)

Yahoo Gemini drives traffic to your website, raise brand awareness, promote your app, and increase your online sales.

YouTube Analytics

YouTube Analytics

YouTube Analytics helps you better understand your video and channel performance by channel or by content owner.

Zendesk

Zendesk

Zendesk Chat

Zendesk Gather

Zendesk Guide

Zendesk Sell

Zendesk Sunshine

Zendesk Talk

Zendesk Support is a cloud-based customer support platform.