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.

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:

• Adobe Analytics (pull directly using SFTP)

• Amazon S3 (pull any file from cloud-based storage)

• Azure Blob Storage (pull any file from cloud-based storage)

• Braze (pull directly using an Amazon S3-based workflow)

• Cordial (pull directly using a REST API)

• Google Analytics (pull directly using a REST API)

• Google Cloud Storage (pull any file from cloud-based storage)

• Heap (pull directly using an Amazon S3-based workflow)

• Klaviyo (pull directly using a REST API)

• Optimizely (pull directly using an Amazon S3-based workflow)

• Sailthru (pull directly using a REST API)

• Salesforce Marketing Cloud

• SFTP (pull data from any SFTP site)

• Shopify (pull directly using a REST API)

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 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 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 is an advertising platform that helps companies grow revenue through seamless marketing and ads.
	Airtable	Airtable works like a spreadsheet but gives you the power of a database to organize anything.
	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 PostgreSQL	Amazon Aurora is a MySQL- and PostgreSQL-compatible relational database built for the cloud.
	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 is a fast and flexible NoSQL database service for all applications that need consistent, single-digit millisecond latency at any scale.
	Amazon S3	Amazon Simple Storage Service (Amazon S3) stores customer data files of any size in any file formats.
	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 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	Heroku Kafka is a managed distributed event streaming platform that runs Apache Kafka.
	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 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 is an application designed for issues tracking, project management, and follow-through.
	AWS Kinesis	Amazon Kinesis Data Firehose is a fully managed service for delivering real-time streaming data to Amazon S3.
	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 Functions is a serverless compute service that enables you to run code on-demand without having to explicitly provision or manage infrastructure.
	BigCommerce	BigCommerce is an all-in-one tool used to build storefronts, optimize product searches, and convert shoppers into customers.
	Box	Box is a cloud-based file storage service that enables secure data sharing with anyone, anywhere, on any device.
	Braintree Payments	Braintree – a payment platform from PayPal – provides payment systems for brands that use mobile app- and web-based shopping experiences.
	Branch	Branch is a mobile measurement and deep linking platform that unifies user measurement across devices, platforms, and channels.
	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 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 is a cloud platform for business spend management. Coupa delivers measurable value through real-time spend visibility, control, compliance, and agility.
	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 creates and sends customer experience surveys, tracks and analyzes feedback, and then helps you take action.
	Dropbox	Dropbox is a file hosting service that offers cloud storage, file synchronization, personal cloud, and client software.
	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 is a Salesforce-native cloud ERP application that gives you a complete, customer-centric view of your business.
	Github	GitHub is a platform for developers to build personal projects, support their businesses, and work together on open source technologies.
	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 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 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 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 is an online file storage web service for storing and accessing data on Google Cloud Platform infrastructure.
	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 helps you monitor and maintain your site’s presence in Google Search results.
	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 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 is a collaborative work service that helps to maintain a project workflow.
	Help Scout	Help Scout is an all-in-one customer service platform that helps you balance everything your customer needs.
	Hubspot	HubSpot is a CRM platform built around dedicated hubs for marketing, sales, services, content management, and operations.
	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 brings messaging products for sales, marketing and customer service to one platform, helping businesses have conversations with customers.
	Iterable	Iterable enables brands to create, execute and optimize campaigns across email, push, SMS, in-app and more with unparalleled data flexibility.
	Klaviyo	Klaviyo is an email platform for targeting, personalizing, measuring, and optimizing email and Facebook campaigns.
	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 Retail is a cloud-based point of sale (POS) solution that is suitable for retailers.
	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 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 Mandrill	Mailchimp provides marketing automation and email marketing services for e-commerce businesses.
	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 is an online advertising platform to measure, manage, and optimize ad spending across the web and mobile devices.
	Marketo	Marketo provides inbound marketing, social marketing, CRM, and other related services.
	Mavenlink	Mavenlink offers online project management with time tracking, resource planning, collaboration, finance etc. functions.
	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 is a pay-per-click advertising platform that displays ads based on keywords in a user’s search query.
	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 is the intelligent, fully-managed relational cloud database service built for developers.
	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 provides an advanced analytics platform for tracking user actions on web and mobile.
	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 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 is an experimentation platform for testing, learning, and deploying positive digital experiences.
	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.
	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 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 is a native advertising platform using targeted advertising to recommend articles, slideshows, blog posts, photos or videos to a reader.
	Pendo	Pendo helps product teams understand and guide users to create product experiences.
	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 helps businesses increase brand’s visibility and drive conversions.
	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 via MySQL	PrestaShop is an ecommerce toolkit that helps you sell your products online.
	Qualtrics	Qualtrics is an online survey tool that helps organizations build and distribute surveys, and then analyze responses.
	ReCharge	Recharge is a recurring billing and subscriptions service for ecommerce stores that use Shopify.
	Recurly	Recurly provides a recurring billing and subscriptions solution for e-commerce.
	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 provides real-time financial and operational insights, as well as the ability to automate critical processes.
	Sailthru	Sailthru is a cross-channel marketing platform built to deliver personalized experiences for consumers across email, web, and mobile channels.
	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 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 is a platform that collects customer data across devices and channels, sends it to third-party tools, internal systems, or SQL databases.
	Sendgrid	SendGrid is a customer communication platform for transaction- and marketing-focused emails.
	ServiceNow	ServiceNow is a cloud platform that provides service management software as a service.
	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 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 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 provides enterprise-level event analytics that is powered by the open source Snowplow platform.
	Spree Commerce via MySQL	Spree Commerce is an API-driven ecommerce framework.
	SQL Server SQL Server on RDS	Microsoft’s SQL Server is a powerful enterprise relational database.
	Square	Square is a platform for managing online stores, payments, and transactions.
	Stripe	Stripe is a software platform for businesses of all sizes. Stripe provides transaction histories for all of your online payments.
	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 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 powers the future of business communications. Enabling phones, VoIP, and messaging to be embedded into web, desktop, and mobile software.
	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 is an online survey management solution that lets you create forms, surveys, and quizzes that your customers will enjoy answering.
	UserVoice	UserVoice gathers and analyzes customer feedback, and then helps you prioritize feature requests that drive product improvements.
	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 via MySQL	WooCommerce is a customizable, open-source e-commerce platform that turns your WordPress into an online store.
	Workday Workday HCM	Workday offers enterprise-level software solutions for financial management, human resources, and planning.
	Xero	Xero accounting software helps to manage invoicing, bank reconciliation, bookkeeping, and more.
	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 helps you better understand your video and channel performance by channel or by content owner.
	Zendesk Zendesk Chat Zendesk Gather Zendesk Guide Zendesk Sell Zendesk Sunshine Zendesk Talk	Zendesk Support is a cloud-based customer support platform.